Re: INSERT OVERWRITE partition while SELECT is going on

2015-04-03 Thread Lefty Leverenz
I'm no expert, but I don't think SELECTs are broken by an INSERT. See Locking for details. As I understand it, the INSERT needs an exclusive lock on the partition which it cannot get while the partition has a shared lock on it. Can someo

INSERT OVERWRITE partition while SELECT is going on

2015-04-03 Thread Thomas Kwan
Hi there, If we have multiple SELECTs going on for a table, will doing a "INSERT OVERWRITE" to replace a partition break those SELECTs? thanks in advance

Re: Dataset for hive

2015-04-03 Thread Fabio C.
Thanks Gopal, but since it was a while ago and I didn't have to generate too much data I just run the tpc-ds generator binaries in parallel and uploaded it manually. Anyway if you want to have a look at the error: http://hortonworks.com/community/forums/topic/hive-testbench-error/ Maybe it's trivia