Jun 12 2014 11:15 AM
The error message shows that a connection pool is not being created as the current user is a read-only user and don't have write permissions on metastore_db files.
This happens when we try to login to hive from a different user other than permitted.
The easiest way to get rid of it is to give all permissions to all users to required files.[required files location must have come when you had seen the second exception]
Below are the steps:
1. Check which user are you using to login.
2. Now do a ls to the location to see if the user have enough write and execute permissions.
Command: ls -l [location] [default is /var/lib/hive/metastore/metastore_db]
3. From step2 list, check what all permissions are available to files under metastore_db
It should be 'rwx' for the user you got from step1.
4. If not, give rwx permissions to all user using a sudo command.
Command: cd [location]
Command: sudo chmod a+rwx . --recursive
Command: rm *.lck
Hope this solves the problem.
Please post, if still you get the error.
Happy Learning @ Dezyre!!