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 <caofang...@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 >> > sa...@stumbleupon.com >> > >> > >> > >> >> Sam William >> sa...@stumbleupon.com >> >> >> >> > > > -- > Best wishs！ > Fangkun.Cao > -- "...:::Aniket:::... Quetzalco@tl"
