hivebigdataclouderaimpala

ACID table error in IMPALA?Hive upgraded to Hive3

I am very new to Hive and Impala.

I was trying to run an already existing table in IMPALA but I got the following error.

AnalysisException: Table dev_test.customer not supported. Transactional (ACID) tables are only supported when they are configured as insert_only.

The version is Hive 3. I am clueless as in what to do. I did see some documentation, articles online, but still could not solve the issue. I have attached a screenshot of the error screen. Let me know if you need more information.

enter image description here

enter image description here

Any help is greatly appreciated. Thanks!

Solution

  • Unfortunately you cant see the data through Impala and you have to use hive.
    you can change table properties to insert_only to see this data.

    alter TABLE tmp2 set
TBLPROPERTIES ( 
  'transactional'='true', 'transactional_properties'='insert_only'
  );

    Screenshot of statement output When you set a table to FULL ACID or hive upgrades to full acid, table file format changed to ORC and this is not supported by Impala so you can not access them. So you need to use hive to access these tables. If you choose the workaround and change table properties, you will loose all ACID benefits like UPD/DEL etc.