Sqoopex database in MySQL not present

Technical Discussions Sqoop
#1

Sqoopex database in MySQL is not available
I used the below to connect to MySQL:
mysql -h cxln2.c.thelab-240901.internal -u sqoopuser -pNHkkP876rp

The host is the one mentioned in my Lab

There databases available are only these:
information_schema, retail_db

How do I proceed with my course?

#2

Hi, Shruti.

  1. Kindly create the “sqoopex” db if not there.
  2. Using server name connect to Mysql.
    mysql -u sqoopuser -p -h cxln2.c.thelab-240901.internal
    Password : NHkkP876rp

The use the below fro your web-console.

sqoop import --connect jdbc:mysql://cxln2.c.thelab-240901.internal/sqoopex --table widgets -m 2 --hive-import --username sqoopuser -P --hive-database sqoop_testing

Also check the tables created in Hive and if you have imported the same into Mysql.

All the best!