hmm, not meant to state the obvious, but did you check to see if the table
you're trying to create already exist in hive?
what query did u use that triggered the error?
On Wed, Jun 22, 2011 at 8:49 PM, Vikramsinh Katkar <
vikramsinh_kat...@persistent.co.in> wrote:
> Hello ,
>
> I will try with N
Hello ,
I will try with Network Derby, however I expected Mysql to perform better than
Derby. I will keep you posted on result.
However please note I used to get following kind of errors :
1)
FAILED: Error in metadata: AlreadyExistsException(message:Table
DL_611_VerificationOutput_DSF_111 a
Hi,
I have a sequence file where I have delimited data and some data is decimal
fields.
For eg: decimal(16,6). Sample value : 123.456735.
How do I upload such a sequence file and what shud I give in table definition
for decimal values as above ?
Thanks in advance !
Sent from my iPhone
Esteban,
Thanks for the quick reply! That resolved the issue.
The "IS_COMPRESSED" error is also in the HIVE-2176.3.patch.
Clint
From: Esteban Gutierrez [mailto:este...@cloudera.com]
Sent: Wednesday, June 22, 2011 3:14 PM
To: user@hive.apache.org
Subject: Re: Trouble creating ind
Clint,
sorry, I think I was too cryptic :)
The default schema creation script is setting the column type for
"DEFERRED_REBUILD"
as bit(1) instead of boolean in the "IDXS" table and the JDBC driver is
failing silently for that type mismatch. Also, it seems that "IS_COMPRESSED"
in one of the intern
Hi Clint,
Indeed this is a bug, "DEFERRED_REBUILD" should be boolean and not bit(1) in
"IDXS".
Regards,
Esteban.
--
Support Engineer, Cloudera.
On Wed, Jun 22, 2011 at 11:25 AM, Clint Green wrote:
> Dear Hive User List,
>
> ** **
>
> I am trying to build indexes on a hive 0.7.1 environm
Dear Hive User List,
I am trying to build indexes on a hive 0.7.1 environment using postgresql as
the metastore, but it is failing silently.
The following command doesn't generate any errors:
hive> CREATE TABLE t (i INT);
OK
Time taken: 0.299 seconds
hive> CREATE INDEX i ON TABLE t (
