How to set tblproperties of hive table using hive-site.xml or how to create all table as transaction table by setting properties in hive-site.xml

Question

I want to create HIVE table with the transactional table with TBLPROPERTIES ("transactional"="true") set using create table statement. instead of setting for all tables can I set TBLPROPERTIES using hive-site.xml.

damientseng · Answer 1 · 2020-01-04T03:25:48.147

0

Unfortunately, we can't set it in hive-site.xml since transactional is a per table property. And we should not do it that way beacause 'transactional table' comes with some prerequisites and limitations.

edited Jan 04 '20 at 03:25

answered Jan 04 '20 at 03:10

damientseng

533
2
19

How to set tblproperties of hive table using hive-site.xml or how to create all table as transaction table by setting properties in hive-site.xml

1 Answers1