question Re: Hive View Create New Instance in Archives of Support Questions (Read Only)

Hive View Create New Instance

muanang — Mon, 14 Nov 2016 14:49:19 GMT

Hi!

I'm trying to crate new instance for my hive view, but I couldn't see where the "Create Instance" anywhere on Ambari>Views as stated here in guide below;

http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.1.0/bk_ambari_views_guide/content/creating_the_hive_view_instance.html

Please help.

Re: Hive View Create New Instance

Former Member — Mon, 14 Nov 2016 14:51:16 GMT

@Michael Dennis "MD" Uanang

Are you getting any error in the "/var/log/ambari-server/ambari-server.log" ?

Is it kerberized error?

Re: Hive View Create New Instance

muanang — Tue, 15 Nov 2016 09:06:16 GMT

Hi @jss

1. Yes I'm getting errors. See below;

Caused by: KrbException: Cannot locate default realm
	at sun.security.krb5.Config.getDefaultRealm(Config.java:1029)
	... 93 more
15 Nov 2016 09:02:23,706  WARN [qtp-ambari-client-6023] ViewRegistry:855 - Could not find the cluster identified by OLDclusterNAME.
15 Nov 2016 09:02:23,707 ERROR [qtp-ambari-client-6023] ViewContextImpl:241 - Failed to get username
java.lang.reflect.InvocationTargetException
	at sun.reflect.GeneratedMethodAccessor617.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hadoop.security.authentication.util.KerberosUtil.getDefaultRealm(KerberosUtil.java:84)
	at org.apache.ambari.server.view.ViewContextImpl.getUsername(ViewContextImpl.java:233)
	at org.apache.ambari.view.hive.utils.SharedObjectsFactory.getTagName(SharedObjectsFactory.java:145)

2. I'm not in kerberized mode. :? But I have ranger on my cluster.

Re: Hive View Create New Instance

Former Member — Tue, 15 Nov 2016 11:42:14 GMT

@Michael Dennis "MD" Uanang

There are multiple errors in your logs:

1. Below error indicates that it is not able to locate "/etc/krb5.conf" file. Or may be it is not readable because of incorrect file permission issues.

Caused by: KrbException: Cannot locate default realm
	at sun.security.krb5.Config.getDefaultRealm(Config.java:1029)
	... 93 more

2. Looks like the view is not created properly. YOu shoudl recreate the view using "local cluster" option.

15 Nov 2016 09:02:23,706  WARN [qtp-ambari-client-6023] ViewRegistry:855 - Could not find the cluster identified by OLDclusterNAME.

3. Following error also indicates that you have kerberos installed, but it is not properly installed. See below "KerberosUtil.getDefaultRealm"

15 Nov 2016 09:02:23,707 ERROR [qtp-ambari-client-6023] ViewContextImpl:241 - Failed to get username
java.lang.reflect.InvocationTargetException
	at sun.reflect.GeneratedMethodAccessor617.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hadoop.security.authentication.util.KerberosUtil.getDefaultRealm(KerberosUtil.java:84)
	at org.apache.ambari.server.view.ViewContextImpl.getUsername(ViewContextImpl.java:233)
	at org.apache.ambari.view.hive.utils.SharedObjectsFactory.getTagName(SharedObjectsFactory.java:145)

If you are using kerberos then you should setup the "WebHDFS Authentication" and "Hive Authentication" attribute of your HiveView with the principal defined in it as described in the following link:

http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.1.0/bk_ambari_views_guide/content/section_kerberos_setup_hive_view.html

Re: Hive View Create New Instance

muanang — Wed, 16 Nov 2016 11:29:01 GMT

WOW. Thank you for laying it out for me. For #2, how can I recreate the view? Do I need to resolve issue #1 and #3 first? 🙂