Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive view NullPointerException

Highlighted

hive view NullPointerException

Hi,

I'm getting below error while running select query in hive view. I checked proxy settings and evrything looks fine, this is a custom hive view on secured cluster and SSL hadoop.

Can anyone suggest where to look?.

java.lang.NullPointerException

at org.apache.ambari.view.hive2.resources.jobs.JobService.getOne(JobService.java:139)

at sun.reflect.GeneratedMethodAccessor561.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)

at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)

at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)

at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)

at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)

at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)

2 REPLIES 2
Highlighted

Re: hive view NullPointerException

@Jitendra Yadav

Atlas in the mix? Any data tagged?

This indicates that one of the tables involved in the view join where the field is involved in the join is passing a null value when a not null is expected. I've seen this type of behavior with tagged data on base tables for the view.

Is there more in hive log? The error excerpt above is just a symptom of passing a null object when one is required, not very helpful.

To test the assumption presented above you could test whether you can query step by step the base tables with the same where clause, but without the join.

Re: hive view NullPointerException

@Constantin Stanca

There was no error in hive/hdfs/yarn etc. during that time frame, even I tried to restart all the services but didn't helped.

But when I restarted Ambari server the issue got resolved, don't know how this exception is related to ambari restart :)

Don't have an account?
Coming from Hortonworks? Activate your account here