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

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

Contributor

@Michael Young

I tried that too. I dont get user impersonation error but i still get nullpointerexception

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

@Praneender Vuppala

Is the Thrift Server running?

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

@Praneender Vuppala

I wonder if you are hitting this issue: https://issues.apache.org/jira/browse/AMBARI-15727, probably not. You can try setting Hive queries to MR instead of Tez to see if the problem still exists.

Can you provide more information about your environment? What version of Ambari are you using? What version of HDP?

You said you can run a query from the hive shell. Are you use the "hive" or the "beeline" client. The hive client talks to the metastore directly. The beeline client uses the thrift server and uses more of the overall stack.

Here is the documentation for the beeline client: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-BeelineExamp...

View solution in original post

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

Contributor

@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

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

@Praneender Vuppala

Can you try using the beeline client to run the same queries that you run via the hive client? I'm curious if that works, as the communication mechanism is different.

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

Contributor

@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>

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

@Praneender Vuppala

You can take a look at the Ambari Server logs to see if you can get more information about the errors:

/var/log/ambari-server/ambari-server.log

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

Contributor

@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

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

What version of java are you running? Type

java -version

Are you using OpenJDK or Oracle? Did you install it manually? Or did you install it via yum?

This link walks you through the process of changing your JDK for HDP: https://docs.hortonworks.com/HDPDocuments/Ambari-2.2.1.1/bk_ambari_reference_guide/content/ch_changi...

Re: Ambari Hive view, Files view, Tez view does not work. throws null pointer exception

Contributor

It started working. All i did is to restart the ambari-agents and ambari-server.

Thanks for the help @Michael Young