Home Forums Hive / HCatalog Error when filling table in HCatalog

This topic contains 4 replies, has 3 voices, and was last updated by  Ajit Singh 4 months ago.

  • Creator
    Topic
  • #47040

    Adam Rench
    Participant

    Hello all,

    I’m getting an error when attempting to create a table and load data from a CSV file using “create a new table from a file” option in Hue. I’m on HDP 2 and have entered in the Groups and Users proxy settings into the webhcat-site.xml file as well.

    The table gets created but it looks like when it is trying to load the data, that’s when it errors out. I get this error message.

    HCatClient error executing hive query: {“error”:”User: hcat is not allowed to impersonate arench”} (error 500)

    I’m assuming the config is missing from my webhcat-site.xml page but I’m not 100% on that. Here’s my webhcat-site.xml file contents nevertheless.

    </property>
    <property>
    <name>templeton.override.enabled</name>
    <value>false</value>
    </property>
    <property>
    <name>templeton.hive.archive</name>
    <value>hdfs:///apps/webhcat/hive.tar.gz</value>
    </property>
    <property>
    <name>webhcat.proxyuser.hue.groups</name>
    <value>*</value>
    </property>
    <property>
    <name>templeton.pig.archive</name>
    <value>hdfs:///apps/webhcat/pig.tar.gz</value>
    </property>
    <property>
    <name>templeton.pig.path</name>
    <value>pig.tar.gz/pig/bin/pig</value>
    </property>
    <property>
    <name>templeton.libjars</name>
    <value>/usr/lib/zookeeper/zookeeper.jar</value>
    </property>
    <property>
    <name>templeton.hcat</name>
    <value>/usr/bin/hcat</value>
    </property>
    <property>
    <name>templeton.zookeeper.hosts</name>
    <value>hdpmaster1.hdp.hadoop:2181,hdpmaster2.hdp.hadoop:2181,hdpslave1.hdp.hadoop:2181</value>
    </property>
    <property>
    <name>templeton.storage.class</name>
    <value>org.apache.hive.hcatalog.templeton.tool.ZooKeeperStorage</value>
    </property>
    <property>
    <name>templeton.jar</name>
    <value>/usr/lib/hcatalog/share/webhcat/svr/webhcat.jar</value>
    </property>
    <property>
    <name>templeton.port</name>
    <value>50111</value>
    </property>
    <property>
    <name>webhcat.proxyuser.hue.hosts</name>
    <value>*</value>
    </property>
    <property>
    <name>templeton.exec.timeout</name>
    <value>60000</value>
    </property>
    <property>
    <name>templeton.hive.path</name>
    <value>hive.tar.gz/hive/bin/hive</value>
    </property>
    <property>
    <name>templeton.streaming.jar</name>
    <value>hdfs:///apps/webhcat/hadoop-streaming.jar</value>
    </property>
    <property>
    <name>templeton.hadoop.conf.dir</name>
    <value>/etc/hadoop/conf</value>
    </property>
    <property>
    <name>templeton.hadoop</name>
    <value>/usr/bin/hadoop</value>
    </property>
    </configuration>

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #57697

    Ajit Singh
    Participant

    in the base OS, is the user “arench” with the same password and “users” group created?

    Collapse
    #47350

    Adam Rench
    Participant

    Hi Thejas,

    Thanks for the reply. I did check and there were a few missing entries that were listed on the page you linked. So I made those updates but I’m still getting this error.

    Collapse
    #47313

    Thejas Nair
    Participant

    Can you check if you have the proxy user configurations under https://cwiki.apache.org/confluence/display/Hive/WebHCat+InstallWebHCat set correctly ?

    Collapse
    #47216

    Adam Rench
    Participant

    FYI – I logged in using the Hue user and I was able to load the data into the table. So it’s something that my profile is not seeing when trying to use the Hue user’s permissions.

    Collapse
Viewing 4 replies - 1 through 4 (of 4 total)