ERROR tool ImportTool Encountered IOException running import job java io IOException Cannot run program hive error 2 No such file or directory

Question

The file is getting created in hdfs but when it starts loading in hive I get an error

sqoop import --connect jdbc:mysql://localhost/edureka_kp --username root --password Edurekasql_123 --table prod --target-dir /sqoop/prod-imp --fields-terminated-by "," --hive-import --hive-table prod

19/03/20 04:06:19 INFO hive.HiveImport: Loading uploaded data into Hive
19/03/20 04:06:19 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Cannot run program "hive": error=2, No such file or directory

>>> sqlContext.sql("show databases").show()
+------------+
|databaseName|
+------------+
| default|
+------------+

>>> sqlContext.sql("show tables").show()
+--------+---------+-----------+
|database|tableName|isTemporary|
+--------+---------+-----------+
| default| prod| false|
+--------+---------+-----------+

>>> sqlContext.sql("select * from prod").show()
+---+---------+----------+---+
| id|prod_name|prod_price|qty|
+---+---------+----------+---+
+---+---------+----------+---+

Answer 1

The tables look fine. Follow these steps and see if it works:

Step 1:

Create a database

Step 2:

Check for the table in mysql.

Step 3:

Sqoop command execution.

Here new_hive is the database name.

Step 4:

Now check for the new table in the hive database.