RE: PK violation during Hive add partition

2012-12-10 Thread Karlen Lie
Thanks! Looks like I've missed enabling the concurrency flag. -karlen From: Edward Capriolo [mailto:edlinuxg...@gmail.com] Sent: Monday, December 10, 2012 7:19 AM To: user@hive.apache.org Subject: Re: PK violation during Hive add partition This also could be an issue with datanucleas

Re: PK violation during Hive add partition

2012-12-10 Thread Edward Capriolo
This also could be an issue with datanucleas and m$ sql server. The project only officially supports derby and MySQL. Only tests using derby. Everything else is at your own risk. On Mon, Dec 10, 2012 at 10:08 AM, Ruslan Al-Fakikh wrote: > Hi! > > Have you enabled Hive concurrency? Hive should not

Re: PK violation during Hive add partition

2012-12-10 Thread Ruslan Al-Fakikh
Hi! Have you enabled Hive concurrency? Hive should not be accessed concurrently if the appropriate property is not enabled. Ruslan On Sat, Dec 8, 2012 at 6:01 AM, Karlen Lie wrote: > nal table, and the query below is run concurrently by multiple oo

PK violation during Hive add partition

2012-12-07 Thread Karlen Lie
Hello, We are running into intermittent errors while running the below query. Some background on this, our table (tbl_someTable) that we're altering is an external table, and the query below is run concurrently by multiple oozie workflows. ALTER TABLE tbl_someTable ADD IF NOT EXISTS PARTITION