Running queries on Hive

[#1]

Hello everyone.
So I have this problem while running Hive, for example I want to create external table for my dataset, and instead of executing it, shows this error:

"FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient"

it's quite basic, but for the life of me, I can't seems to be able to fix it. I even deleted and redownloaded the Hive client and change versions, nothing change. Anyone care to lend a hand?

[#2]

@Jackallboy Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Hive experts @Shmoo @mszurap  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

[#3]

Hi @Jackallboy ,

Could you please provide more details from your cluster? 

- Version

- Which client are you connecting from?

- Share entire stack error

Best,

Cristian

[#4]

Please connect using the Beeline client included with the CDP parcel. Then, check the HiveServer2 (HS2) logs to determine the root cause. Sharing the complete stack trace will also help us identify the issue.

[#5]

@Jackallboy 
What client are you using to create your table?
It is suggested to use Beeline client to create your table
HiveServer2 will authenticate to the Hive Metastore on your behalf to execute your task
Please update us with more specifics if you need further assistance

[#6]

hi @Jackallboy ,

according to your report, the client is not able to connect to the HMS, which is generating the error.

to validate your test and creation of the external table, do the following:

1. access a host in the cluster, authenticate, and run "beeline". This way, you will connect to Hive automatically.

2. then run your ddl to create the external table and check the behavior.

if it is created successfully, the problem you reported is in the client that is trying to create the external table.

so, where are you trying to create the external table? Using an external tool, external connection, etc.

[#7]

@Jackallboy Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, can you provide the information requested? Thanks.