There are a few solutions outlined in the link below that might help...
Work with your Hadoop administrator to ensure that you have permissions to access the table.
Note: Simply granting permissions to a username may not be sufficient; a directory path may also need to be specified.
For more information, see Directories and Permissions in Hadoop's knowledge base.
Ensure that the latest drivers are installed and configured correctly: Drivers & Activation.
Work with Hortonworks support to ensure that the Hadoop user's home directory has been created correctly. Please note that the following error message might appear in the Hortonworks Hadoop log files:
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=<>, access=WRITE, inode="/user":<>
Ensure that the correct user with the required permissions is used with the ODBC driver and verify that the ODBC driver is configured correctly. If the issue persists, contact the Hadoop Hive distribution provider for assistance.