@hshaikh, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution to help others find the answer more easily in the future. ... View more

@jayes Please make sure that you have set this property in "HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml" under Hive on Tez configuration. I tried this and it works for me: Beeline version 3.1.3000.7.1.7.2000-305 by Apache Hive 0: jdbc:hive2://c1649-node2.coelab.cloudera.c> set dfs.replication=1; No rows affected (0.208 seconds) 0: jdbc:hive2://c1649-node2.coelab.cloudera.c> set hive.security.authorization.sqlstd.confwhitelist.append; +----------------------------------------------------+ | set | +----------------------------------------------------+ | hive.security.authorization.sqlstd.confwhitelist.append=mapred\..*|hive\..*|mapreduce\..*|spark\..*|dfs\..* | +----------------------------------------------------+ 1 row selected (0.109 seconds) ... View more