Jun 29 2014 11:44 PM
Appreciate the efforts you made to resolve the issue but this time it looks like issue is coming due to insufficient permissions to current user for creating metastore directory.
Please try running following command:
sudo chmod -R 777 /var/lib/hive/metastore/metastore_db
and then re-try running hive queries.
This should work now.
Please post, if further help is required.