Below is just a simple example of hive transactions. These are very useful on slowly changing type 1 dimension tables for which you do not wish to retain history, but only the most recent value of the row. The table must be bucketed, and the transactional=true property must be set on the table as shown below.<\/p>\n
\r\n0: jdbc:hive2:\/\/localhost:10000\/brierley> create table t(c int) clustered by (c) into 10 buckets stored as orc tblproperties('transactional'='true');\r\nNo rows affected (0.077 seconds)\r\n0: jdbc:hive2:\/\/localhost:10000\/brierley> insert into table t values(1);\r\nINFO : Tez session hasn't been created yet. Opening session\r\n<\/pre>\n…snip…<\/p>\n
\r\nINFO :\r\nINFO : Table brierley.t stats: [numFiles=11, numRows=1, totalSize=2871, rawDataSize=0]\r\n0: jdbc:hive2:\/\/localhost:10000\/brierley> select * from t;\r\n+------+--+\r\n| t.c |\r\n+------+--+\r\n| 2 |\r\n+------+--+\r\n1 row selected (0.172 seconds)\r\n0: jdbc:hive2:\/\/localhost:10000\/brierley>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Below is just a simple example of hive transactions. These are very useful on slowly changing type 1 dimension tables for which you do not wish to retain history, but only the most recent value of the row. The table…<\/p>\n