You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by hadoop hive <ha...@gmail.com> on 2014/07/02 16:36:38 UTC

Re: Error in create table

Seems that you have created wrong table structure in hive metastore.

Which hive are you using ??  you need to check which schema is required for
your Hadoop version .
On Jun 26, 2014 4:37 PM, "Rishabh Bhardwaj" <rb...@yahoo.com> wrote:

> Hi all,
> I have set mysql as my metastore but when I try to create a table the
> follwoing error comes.. FAILED: Error in metadata:
> MetaException(message:javax.jdo.JDODataStoreException: Insert of object
> "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@1316bc6e"
> using statement "INSERT INTO `SDS`
> (`SD_ID`,`SERDE_ID`,`OUTPUT_FORMAT`,`LOCATION`,`NUM_BUCKETS`,`INPUT_FORMAT`,`IS_STOREDASSUBDIRECTORIES`,`CD_ID`,`IS_COMPRESSED`)
> VALUES (?,?,?,?,?,?,?,?,?)" failed : Unknown column
> 'IS_STOREDASSUBDIRECTORIES' in 'field list'
>
> Please help me with this.
>
> Thanks,
> Rishabh.
>