Seems like you are using a MySQL metadata store ... do you have write permissions on the store? ... can you create another table?
If not, perhaps you can try with the plain vanilla metastore and see if the problem persists. -Ajo. On Fri, Jan 28, 2011 at 2:31 AM, lei liu <liulei...@gmail.com> wrote: > When I execute "create table tag16(auction int, tagid int, cost double, > title string, description string) ROW FORMAT DELIMITED FIELDS TERMINATED BY > ','" , the hive throw "AILED: Error in metadata: javax.jdo.JDOException: > Couldnt obtain a new sequence (unique id) : Binary logging not possible. > Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog > mode 'STATEMENT' > NestedThrowables: > java.sql.SQLException: Binary logging not possible. Message: Transaction > level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask" error. > > Could everyone tell me the reason? > > > > Thanks, > > LiuLei >
