Support Questions
Find answers, ask questions, and share your expertise

Discrepency in INSERT OVERWRITE with between Beeline and CLI

Expert Contributor

We are facing issue with insert ovewrite after upgrade from 2.5.3 to 2.6.1

Tried running with different destination . It created the folder but fails with below error

Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xyz] does not have [WRITE] privilege on [/tmp/*] (state=42000,code=40000) Closing: 0: jdbc:hive2://host:2181,host:2181,host:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xyz] does not have [WRITE] privilege on [/user/*] (state=42000,code=40000) Closing: 0: jdbc:hive2://host:2181,host:2181,host:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

2 REPLIES 2

Contributor

Like it says your permissions haven't been set up quite right. Could be down to some permissions not being applied after your update? Check ranger(or whatever control manager you're using) and confirm that the relevant user/group has the expected write permission on your HDFS location(s).

Expert Contributor

I have tried the destination as /tmp on hdfs and still faces the same issue