Discrepency in INSERT OVERWRITE with between Beeline and CLI

[#1]

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]

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).

[#3]

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