my hive commands fails


2 Answer(s)


Hi Paul,

Try this and let me know if this works for you or not?

Steps:
1. Stop hadoop services.
2. Delete the following file: (located in /home/<user> folder)

rm metastore_db/*.lck

3. Start the hadoop services again.

Hope this helps.


It fixed it.  I had sean this command in web but i thought the metastore was in  /usr/local/hive 

actualy there is a metastore there too.  Now  I created a database but  that database is created not in MySQL but in derby.log, because when i log on to mysql and list databases it is not there( but from hive i can see). Besides i can see derby.log with latest time stamp.  I saw one  this site 

http://www.helicaltech.com/change-hive-metastore-from-derby-to-mysql/

but hive they are using is diffreet version-  

 

regards

 

paul