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.

run queries on managed tables in hive version 3

run queries on managed tables in hive version 3

New Contributor

Hi,


trying to run queries on hive managed tables in hive version3, but ı m getting errors. from my understanding, hive catalog and spark catalog was separated in hortonworks (HDP) 3 version+.


My question is - hive, spark catalog separation is just valid for HDP3+ ? or is it related with directly hive version3?


wondering that because the only way seems to use hortonwork hivewarehouseconnector for now, so if there is any way to run queries on hive managed tables in hdp3+ cluster, could you share?


Versions;

spark 2.3

HDP 3.1

Hive 3.1.x


Thanks.


2 REPLIES 2

Re: run queries on managed tables in hive version 3

@Baris Akgun this is a feature of hive 3. The integration between spark and hive in hive 3 is solely through the connector. There are a number feature-rich reasons why this is the case.

Highlighted

Re: run queries on managed tables in hive version 3

New Contributor

Thanks, so Hivewarehouseconnector is kind of unique solution if I try to connect Hive3 from spark. Am I correct? or is there any other way to connect hive3 from spark?


Thanks.

Don't have an account?
Coming from Hortonworks? Activate your account here