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 metarus...@gmail.comwrote: Hi! Have you enabled Hive

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 and m

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