Saturday, 9 July 2016

02. Sqoop Import Exception SqlException : Failed to start database.

Sqoop Import Exception SqlException : Failed to start database.




cmd:

''sqoop import --connect jdbc:mysql://localhost/Gopal_Lab --table emp -m 1 --hive import"




Fix:
remove .lck in dir and re-run.

sudo rm -rf /var/lib/hive/metastore/metastore_db/*.lck

Permanent fix:
Default hive metastore embedded derby,  not possible to start multiple instance of hive at the same time. 
changing hive metastore to mysql or postgres server this issue can be solved the problem.