Did you try using '\' character? ... View more

Can i get any help on this? ... View more

@Michael Young Any thoughts? ... View more

@Michael Young Both hive views are working. I have not changed any java version. I am using 1.8.0_101. ... View more

It started working. All i did is to restart the ambari-agents and ambari-server. Thanks for the help @Michael Young ... View more

@Michael Young I am running java 1.8.0_101. The link you pointed hortonworks community has a solution saying "java update to 1.8.0.71 fixed the issue". Do you think 1.8.0_101 should be degraded to 1.8.0.71. Is that a good practice? Thanks ... View more

@Michael Young I am able to connect via beeline client can execute the queries pretty much same as from hive client. beeline> !connect jdbc:hive2://10.20.20.51:10000 Connecting to jdbc:hive2://10.20.20.51:10000 Enter username for jdbc:hive2://10.20.20.51:10000: root Enter password for jdbc:hive2://10.20.20.51:10000: ******** Connected to: Apache Hive (version 1.2.1000.2.4.2.0-258) Driver: Hive JDBC (version 1.2.1000.2.4.2.0-258) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://10.20.20.51:10000> show databases; +----------------+--+ | database_name | +----------------+--+ | default | | test | +----------------+--+ 2 rows selected (0.096 seconds) 0: jdbc:hive2://10.20.20.51:10000> select * from test; Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'test' (state=42S02,code=10001) 0: jdbc:hive2://10.20.20.51:10000> select * from test.testtable; +-----------------+----------------+--+ | testtable.name | testtable.age | +-----------------+----------------+--+ | xyz | 25 | +-----------------+----------------+--+ 1 row selected (0.56 seconds) 0: jdbc:hive2://10.20.20.51:10000> ... View more

@Michael Young First of everything, when i get into hive view i get the null pointer error. It is not letting run anything from hive view. I changed the execution engine to mr, I still get the same issue. Its a 2 node cluster and I am using ambari 2.2.2.0 and HDP - 2.4.2.0. I am using hive client to talk to the metastore. Let me know if you need anything else. Thanks ... View more