Hive Installation Issues


1 Answer(s)


Hi Indu,

Please try the following solution. Your metastore_db must be in /home/<username>  folder.

  1. Go to metastore_db
  2. Copied the db.lck to db.lck1 and dbex.lck to dbex.lck1
  3. Deleted the lock entries from db.lck and dbex.lck
  4. Log out from hive shell as well as from all running instances of HDFS
  5. Re-login to HDFS and hive shell. If you run DDL commands, it may again give you the "Could not instantiate HiveMetaStoreClient error"
  6. Now copy back the db.lck1 to db.lck and dbex.lck1 to dbex.lck
  7. Log out from all hive shell and HDFS instances
  8. Relogin and you should see your old tables

Please try the solution and let me know if this works for you.

Thanks.