[HIVE-4338] Create Table fails after upgrade from 0.9 to 0.10

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.10.0
• Component/s: Database/Schema

Environment

Ubuntu 3.2.0-23-generic #36-Ubuntu on AMD

• Assignee: Unassigned
• Reporter: Geula Vainappel
• Created: 11/Apr/13 10:14
• Updated: 29/Jul/13 17:29
• Resolved: 27/Jul/13 17:32

Description

I ran apt-get upgrade on a relatively old cdh installation. Many things were upgraded, among them hadoop, hdfs and hive (from 0.9 to 0.10). After the upgrade, CREATE TABLE started failing. I rebooted the machine, and it is still not working. The error I am receiving is:
hive> create table ttt(line string);
FAILED: Error in metadata: MetaException(message:javax.jdo.JDODataStoreException: Error(s) were found while auto-creating/validating the datastore for classes. The errors are printed in the log, and are attached to this exception.
NestedThrowables:
java.sql.SQLSyntaxErrorException: In an ALTER TABLE statement, the column 'IS_STOREDASSUBDIRECTORIES' has been specified as NOT NULL and either the DEFAULT clause was not specified or was specified as DEFAULT NULL.)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask