1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com

If anyone has a problem to run Hive in CDH3 VM, try this:

Don't lose time like me. I had the same issue and resolved it by the following way:

For granting write access to the derby metastore database directory used by Hive :

cd /var/lib/hive/metastore/metastore_db
sudo chmod a+rwx . --recursive

(Be warned that this will give permissions to all users but this shouldn't be a problem. You can change r-w-x bits accordingly if you want)

Then clear the lock files in directory '/var/lib/hive/metastore/metastore_db':

sudo rm *.lck

Then it should work like below, if you fire the command 'show databases;'

hive> show databases;
Time taken: 3.134 seconds

1 Answer(s)


As per today's class move away from CDH3...CDH4 is released on Oct 2013 and now CDH5 is available

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)