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.

Does Hive LLAP support acid transaction tables

Highlighted

Does Hive LLAP support acid transaction tables

I am running a query which has an acid transaction table and I have also enabled acid transaction properties.When I run this query in the LLAP,The query does not run and it automatically is killing LLAP.

Does LLAP does not support acid transactions ?

5 REPLIES 5
Highlighted

Re: Does Hive LLAP support acid transaction tables

Rising Star
Highlighted

Re: Does Hive LLAP support acid transaction tables

Explorer

Did you enable following in ambari console

Set Enable Interactive Query to Yes

Set ACID Transactions to On

Highlighted

Re: Does Hive LLAP support acid transaction tables

Contributor

Yes, it does. Can you share the below information:

1. Your current version

2. Error stack trace

3. Also confirm if Interactive Query and Acid Transactions are set to True from Hive -> Configurations in Ambari

Highlighted

Re: Does Hive LLAP support acid transaction tables

I can actually see the query(ACID tables) running on LLAP, but it too slow compared to Hive query.Hive takes around 30sec and LLAP is taking around 14500secs to finish.

Does LLAP have an higher penalty over hive

Highlighted

Re: Does Hive LLAP support acid transaction tables

Contributor

What are you trying to compare exactly? Hive insert query performance in LLAP vs HS2 mode? It will be helpful to know if: Queue, user limits, memory settings are all the same? and if its batch insert or single row? how many llap containers are running in cluster vs total configured yarn

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