Hcat client error in Hue 2.9

[#1]

Hi guys

I have HDP 2.3 and Hue 2.9. While i am trying to create table from HDFS data in metadata manager. Getting below error:

HCatClient error on create table: {"error":"User: HTTP/hdpdn2.hadoop.com@HADOOP.COM is not allowed to impersonate admin"} (error 500)

P.S- Logged in hue through default admin user.

Please help..Let me know if any further info is required.

[#2]

Issue seems to be related to impersonation. What would help is to see your hue.ini file. But have a look at this site Issue is related to impersonation. Ensure to follow these steps here.

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_installing_manually_book/content/configur...

similar issues in another HCC article: https://community.hortonworks.com/questions/26792/hue-is-not-allowed-to-impersonate-403.html

Question: Why not use Ambari VIEWs?

[#3]

@Dan Rice

As per your suggestion i am trying hive view but it gives below error:

09 Jan 2017 02:55:23,976 ERROR [qtp-ambari-client-13583] ServiceFormattedException:95 - H020 Could not establish connecton to hdpdn2.hadoop.com:10000: org.apache.thrift.transport.TTransportException: Peer indicated failure: Unsupported mechanism type PLAIN: org.apache.thrift.transport.TTransportException: Peer indicated failure: Unsupported mechanism type PLAIN 09 Jan 2017 02:55:23,976 ERROR [qtp-ambari-client-13583] ServiceFormattedException:96 - org.apache.ambari.view.hive.client.HiveClientException: H020 Could not establish connecton to hdpdn2.hadoop.com:10000: org.apache.thrift.transport.TTransportException: Peer indicated failure: Unsupported mechanism type PLAIN: org.apache.thrift.transport.TTransportException: Peer indicated failure: Unsupported mechanism type PLAIN

Note: Beehive works fine. Also i am using Ambari 2.2.0. This seems to be the same issue for hue too.

please suggest..