Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-4338

Create Table fails after upgrade from 0.9 to 0.10

    Details

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

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

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              gimelit Geula Vainappel
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: