- To get help related to create-hive-table command
sqoop help create-hive-table
- Command to create a table in hive
sqoop create-hive-table --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table orders --hive-database training_sqoop_retail
- To validate the table created
DESCRIBE FORMATTED orders;