Duplicate CD_ID in CDS table was linked to an old table which was created
before hive 0.7.0 to 0.9.0 migration, this might be causing this issue. I
am still debugging this issue , looks like there was some problem in
upgrade.
On Sun, Mar 10, 2013 at 8:47 PM, Dean Wampler <
dean.wamp...@thinkbigan
If you upgrade Hive, you have to do a upgrade/migration on the metastore
database. There are scripts that come with hive distributions for this. If
you're starting from scratch, you could just drop the old database.
On Sun, Mar 10, 2013 at 1:23 AM, Abhishek Gayakwad wrote:
> it is an old installa
Please use "if not exists" clause and let us know if it works.
I am wondering if a table exists already in your database with the same
name.
-Ramki.
On Sat, Mar 9, 2013 at 11:23 PM, Abhishek Gayakwad wrote:
> it is an old installation, we recently upgraded hive 0.7.0 to 0.9.0
>
> and we are no
it is an old installation, we recently upgraded hive 0.7.0 to 0.9.0
and we are not using "if not exists" clause
On Sun, Mar 10, 2013 at 4:37 AM, Ramki Palle wrote:
> Just wondering if your create table syntax include "if not exists" such as
>
> CREATE EXTERNAL TABLE IF NOT EXISTS my_table (
>
Just wondering if your create table syntax include "if not exists" such as
CREATE EXTERNAL TABLE IF NOT EXISTS my_table (
...
...
...
)
On Sun, Mar 10, 2013 at 2:34 AM, Viral Bajaria wrote:
> Is this is a new installation of Hive or did you upgrade ? How many tables
> do you already have ?
>
Is this is a new installation of Hive or did you upgrade ? How many tables
do you already have ?
On Sat, Mar 9, 2013 at 12:00 PM, Abhishek Gayakwad wrote:
> while trying to create external table in oozie hive action, I am getting
> following error, hive version is 0.9.0
>
>
> Caused by: javax.jd
