Ideally below should work.  use default;show tables; Please check HiveServer2, HMS logs and share the stack-trace.  To identify the RootCause.  ... View more

Thanks @MGreen for the help ... View more

2.  An alternative is to write a script (e.g., Bash) that interacts with Hive and potentially your desired output format. ... View more

Hello @smruti , Thanks for the help.  ... View more

Hello @smruti , Please let me know if any way where we can have call or meet to review the script ? I will in mean time will try to remove the -n options and check if that works. ... 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

@cravani Thanks for the help 🙂 ... View more