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 throws org.apache.ambari.view.hive.persistence.utils.ItemNotFound

Highlighted

Hive throws org.apache.ambari.view.hive.persistence.utils.ItemNotFound

Contributor

Hi All,

Hive throws this error when running select query. Ambari Veiw

Any idea

Thanks in advance..

2 REPLIES 2
Highlighted

Re: Hive throws org.apache.ambari.view.hive.persistence.utils.ItemNotFound

Please provide some additional details such as what exactly you were running, snippets of the data you were trying to use, and details on what version of HDP or Sandbox you were running?

Highlighted

Re: Hive throws org.apache.ambari.view.hive.persistence.utils.ItemNotFound

@Shihab

Please follow the following steps and restart the services Ambari is recommending to restart:

For more information follow this link:

http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.0.0/bk_ambari_views_guide/content/_setup_HDFS_pr...

  1. In Ambari Web, browse to Services > HDFS > Configs.
  2. Under the Advanced tab, navigate to the Custom core-site section.
  3. Click Add Property… to add the following custom properties:
    hadoop.proxyuser.root.groups=*
    hadoop.proxyuser.root.hosts=*

    Notice the ambari-server daemon account name root is part of the property name. Be sure to modify this property name for the account name you are running the ambari-server as. For example, if you were running ambari-server daemon under an account name of ambariusr, you would use the following properties instead:

    hadoop.proxyuser.ambariusr.groups=*
    hadoop.proxyuser.ambariusr.hosts=*
    
Don't have an account?
Coming from Hortonworks? Activate your account here