Try looking at your metastore log file for any errors from ql.Initiator or ql.Worker. ... View more

it should be insert into table test32 partition(dt=3) (id) select * from test31; ... View more

Does https://issues.apache.org/jira/browse/HIVE-9481 help? ... View more

https://issues.apache.org/jira/browse/HIVE-12634 will help here ... View more

Hive Acid tables are not integrated with Spark. To write to an Acid table in a streaming fashion you could use https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-StreamingAPIs (hdfs dfs -ls -R output shows the table to not be in expected format for Acid table. You can check metastore log for errors regarding compaction, but I would not expect it to work) ... View more

Here is the detailed doc https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions ... View more

ACID is not yet integrated with HCatalog ... View more

try "set hive.txn.manager" and see what it prints. This is "sticky" setting so set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager won't always take effect. It's more reliable to set it in hive-site.xml ... View more

How often to run compaction is a function of how quickly you are generating delta files (see https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-BasicDesignfor more info). Less frequent compactions will make reads more expensive. Keep in mind that this system is designed for slowly changing data. Updating 1 row out of 1 billion row table every second will not work well. The cost of executing an SQL UPDATE statement that matches 1 row and 10K rows is roughly the same. The other response regarding the state of this feature in Hive 0.14 is still valid. ... View more