You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sam William <sa...@stumbleupon.com> on 2013/01/04 23:22:04 UTC
0.8.0 -> 0.9.0 mysql schema upgrade
When I upgraded to 0.9.0, Im getting an exception when I try to create tables
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@4774e78a" using statement "INSERT INTO `SDS` (`SD_ID`,`NUM_BUCKETS`,`LOCATION`,`INPUT_FORMAT`,`CD_ID`,`OUTPUT_FORMAT`,`SERDE_ID`,`IS_COMPRESSED`) VALUES (?,?,?,?,?,?,?,?)" failed : Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value
NestedThrowables:
java.sql.SQLException: Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value
The upgrade script from 0.8 to 0.9 doesnt have anything ? What am I missing ?
Sam William
sampd@stumbleupon.com
Re: 0.8.0 -> 0.9.0 mysql schema upgrade
Posted by Aniket Mokashi <an...@gmail.com>.
AFAIK, 0.8 and 0.9 have same schema. Did you upgrade to 0.10 accidentally?
On Sun, Feb 17, 2013 at 9:31 PM, FangKun Cao <ca...@gmail.com> wrote:
> Hi Sam William:
>
> Check this issue: https://issues.apache.org/jira/browse/HIVE-3649
>
> and
>
> http://svn.apache.org/repos/asf/hive/tags/release-0.10.0/metastore/scripts/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql
>
>
> 2013/1/5 Sam William <sa...@stumbleupon.com>
>
>> Looks like this column is not even there in the 0.8/0.9 schema files . I
>> have no idea, how I have it in my schema . I just set a default 'false'
>> value and I m fine now.
>> Sam
>>
>> On Jan 4, 2013, at 2:22 PM, Sam William <sa...@stumbleupon.com> wrote:
>>
>> > When I upgraded to 0.9.0, Im getting an exception when I try to create
>> tables
>> >
>> > FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of
>> object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@4774e78a"
>> using statement "INSERT INTO `SDS`
>> (`SD_ID`,`NUM_BUCKETS`,`LOCATION`,`INPUT_FORMAT`,`CD_ID`,`OUTPUT_FORMAT`,`SERDE_ID`,`IS_COMPRESSED`)
>> VALUES (?,?,?,?,?,?,?,?)" failed : Field 'IS_STOREDASSUBDIRECTORIES'
>> doesn't have a default value
>> > NestedThrowables:
>> > java.sql.SQLException: Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a
>> default value
>> >
>> >
>> > The upgrade script from 0.8 to 0.9 doesnt have anything ? What am I
>> missing ?
>> >
>> > Sam William
>> > sampd@stumbleupon.com
>> >
>> >
>> >
>>
>> Sam William
>> sampd@stumbleupon.com
>>
>>
>>
>>
>
>
> --
> Best wishs！
> Fangkun.Cao
>
--
"...:::Aniket:::... Quetzalco@tl"
Re: 0.8.0 -> 0.9.0 mysql schema upgrade
Posted by FangKun Cao <ca...@gmail.com>.
Hi Sam William:
Check this issue: https://issues.apache.org/jira/browse/HIVE-3649
and
http://svn.apache.org/repos/asf/hive/tags/release-0.10.0/metastore/scripts/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql
2013/1/5 Sam William <sa...@stumbleupon.com>
> Looks like this column is not even there in the 0.8/0.9 schema files . I
> have no idea, how I have it in my schema . I just set a default 'false'
> value and I m fine now.
> Sam
>
> On Jan 4, 2013, at 2:22 PM, Sam William <sa...@stumbleupon.com> wrote:
>
> > When I upgraded to 0.9.0, Im getting an exception when I try to create
> tables
> >
> > FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of
> object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@4774e78a"
> using statement "INSERT INTO `SDS`
> (`SD_ID`,`NUM_BUCKETS`,`LOCATION`,`INPUT_FORMAT`,`CD_ID`,`OUTPUT_FORMAT`,`SERDE_ID`,`IS_COMPRESSED`)
> VALUES (?,?,?,?,?,?,?,?)" failed : Field 'IS_STOREDASSUBDIRECTORIES'
> doesn't have a default value
> > NestedThrowables:
> > java.sql.SQLException: Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a
> default value
> >
> >
> > The upgrade script from 0.8 to 0.9 doesnt have anything ? What am I
> missing ?
> >
> > Sam William
> > sampd@stumbleupon.com
> >
> >
> >
>
> Sam William
> sampd@stumbleupon.com
>
>
>
>
--
Best wishs！
Fangkun.Cao
Re: 0.8.0 -> 0.9.0 mysql schema upgrade
Posted by Sam William <sa...@stumbleupon.com>.
Looks like this column is not even there in the 0.8/0.9 schema files . I have no idea, how I have it in my schema . I just set a default 'false' value and I m fine now.
Sam
On Jan 4, 2013, at 2:22 PM, Sam William <sa...@stumbleupon.com> wrote:
> When I upgraded to 0.9.0, Im getting an exception when I try to create tables
>
> FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@4774e78a" using statement "INSERT INTO `SDS` (`SD_ID`,`NUM_BUCKETS`,`LOCATION`,`INPUT_FORMAT`,`CD_ID`,`OUTPUT_FORMAT`,`SERDE_ID`,`IS_COMPRESSED`) VALUES (?,?,?,?,?,?,?,?)" failed : Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value
> NestedThrowables:
> java.sql.SQLException: Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value
>
>
> The upgrade script from 0.8 to 0.9 doesnt have anything ? What am I missing ?
>
> Sam William
> sampd@stumbleupon.com
>
>
>
Sam William
sampd@stumbleupon.com