Get the detail of MySQL server using "My Lab" tab. Look at the MySQL credentials tab on the lab details page (https://cloudxlab.com/my-lab#mysql-credentials)
Check the MySQL: Connect
mysql -h cxln2.c.thelab-240901.internal -u sqoopuser -pNHkkP876rp
Select the sqoopex database
use sqoopex;
Check the MySQL: Explore The table in MySQL using
select * from widgets;
Exit mysql
Import - It might ask for password. Keep the password
sqoop import --connect jdbc:mysql://cxln2.c.thelab-240901.internal/sqoopex --table widgets -m 2 --hive-import --username sqoopuser -P --hive-database sqoop_testing --split-by id
Start hive
use sqoop_testing;
select * from widgets;
Loading comments...