Member since
12-09-2015
106
Posts
40
Kudos Received
20
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2941 | 12-26-2018 08:07 PM | |
2583 | 08-17-2018 06:12 PM | |
1334 | 08-09-2018 08:35 PM | |
12025 | 01-03-2018 12:31 AM | |
981 | 11-07-2017 05:53 PM |
06-05-2016
03:36 AM
1 Kudo
Try looking at your metastore log file for any errors from ql.Initiator or ql.Worker.
... View more
05-19-2016
06:09 PM
1 Kudo
it should be insert into table test32 partition(dt=3) (id) select * from test31;
... View more
05-18-2016
06:29 PM
Does https://issues.apache.org/jira/browse/HIVE-9481 help?
... View more
05-13-2016
07:09 PM
https://issues.apache.org/jira/browse/HIVE-12634 will help here
... View more
05-12-2016
06:24 PM
1 Kudo
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
05-12-2016
06:22 PM
1 Kudo
Here is the detailed doc https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions
... View more
02-24-2016
12:25 AM
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
02-08-2016
07:24 PM
1 Kudo
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
01-25-2016
09:02 PM
2 Kudos
This not supported and there is no efficient way to do this. This will be handled once support for MERGE statement is added
... View more
- « Previous
- Next »