[ https://issues.apache.org/jira/browse/HIVE-18046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16250075#comment-16250075 ]
Sergey Shelukhin commented on HIVE-18046: ----------------------------------------- +1 pending tests > Metastore: default IS_REWRITE_ENABLED=false instead of NULL > ----------------------------------------------------------- > > Key: HIVE-18046 > URL: https://issues.apache.org/jira/browse/HIVE-18046 > Project: Hive > Issue Type: Bug > Components: Materialized views, Metastore > Affects Versions: 3.0.0 > Reporter: Gopal V > Assignee: Jesus Camacho Rodriguez > Priority: Minor > Attachments: HIVE-18046.patch > > > The materialized view impl breaks old metastore sql write access, by > complaining that the new table creation does not set this column up. > {code} > `IS_REWRITE_ENABLED` bit(1) NOT NULL, > {code} > {{NOT NULL DEFAULT 0}} would allow old metastore direct sql compatibility > (not thrift). > {code} > 2017-11-09T07:11:58,331 ERROR [HiveServer2-Background-Pool: Thread-2354] > metastore.RetryingHMSHandler: Retrying HMSHandler after 2000 ms (attempt 1 of > 10) with error: javax.jdo.JDODataStoreException: Insert of object > "org.apache.hadoop.hive.metastore.model.MTable@249dbf1" using statement > "INSERT INTO `TBLS` > (`TBL_ID`,`CREATE_TIME`,`DB_ID`,`LAST_ACCESS_TIME`,`OWNER`,`RETENTION`,`SD_ID`,`TBL_NAME`,`TBL_TYPE`,`VIEW_EXPANDED_TEXT`,`VIEW_ORIGINAL_TEXT`) > VALUES (?,?,?,?,?,?,?,?,?,?,?)" failed : Field 'IS_REWRITE_ENABLED' doesn't > have a default value > at > org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) > at > org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:720) > at > org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) > at > org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:1038) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)