With Hive version 0.13 and higher, the default security does not allow the user who creates the table to read from or write to the table. To enable reading from and writing to the table without having to modify access permissions after creating the table, do the following:
- In hive-site.xml, add the property hive.security.authorization.createtable.owner.grants and set its value to SELECT and UPDATE.
- Ensure the user has read/write privileges to Hive data files on the Hadoop file system.