question Re: Running queries on Hive in Support Questions

Running queries on Hive

Jackallboy — Fri, 27 Jun 2025 10:17:08 GMT

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?

Re: Running queries on Hive

DianaTorres — Sat, 28 Jun 2025 02:36:37 GMT

@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.

Re: Running queries on Hive

Shmoo — Wed, 02 Jul 2025 00:23:53 GMT

Hi @Jackallboy ,

Could you please provide more details from your cluster?

- Version

- Which client are you connecting from?

- Share entire stack error

Best,

Cristian

Re: Running queries on Hive

ggangadharan — Wed, 02 Jul 2025 07:48:48 GMT

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.

Re: Running queries on Hive

JoseManuel — Wed, 02 Jul 2025 15:13:21 GMT

@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

Re: Running queries on Hive

yagoaparecidoti — Wed, 02 Jul 2025 20:43:38 GMT

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.

Re: Running queries on Hive

DianaTorres — Fri, 04 Jul 2025 18:19:43 GMT

@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.