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

schematool is broken in hive 1.0.0

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.0
    • Component/s: Metastore
    • Labels:
      None

      Description

      Schematool gives following error -

      bin/schematool -dbType derby -initSchema
      Starting metastore schema initialization to 1.0
      org.apache.hadoop.hive.metastore.HiveMetaException: Unknown version specified for initialization: 1.0
      

      Metastore schema hasn't changed from 0.14.0 to 1.0.0. So there is no need for new .sql files for 1.0.0. However, schematool needs to be made aware of the metastore schema equivalence.

      1. HIVE-9514.1.patch
        1 kB
        Thejas M Nair

        Activity

        Hide
        thejas Thejas M Nair added a comment -

        I ran all metastore tool unit tests for this and they pass. Also manually verified schema initialization and upgrade with derby. Also ran queries with "hive.metastore.schema.verification=true"

        Show
        thejas Thejas M Nair added a comment - I ran all metastore tool unit tests for this and they pass. Also manually verified schema initialization and upgrade with derby. Also ran queries with "hive.metastore.schema.verification=true"
        Hide
        thejas Thejas M Nair added a comment -

        Also manually tested upgrade from 0.11 on mysql. The fix is applicable to all databases, so I don't think verifying it against all variants is necessary.

        Show
        thejas Thejas M Nair added a comment - Also manually tested upgrade from 0.11 on mysql. The fix is applicable to all databases, so I don't think verifying it against all variants is necessary.
        Hide
        vikram.dixit Vikram Dixit K added a comment -

        +1 LGTM.

        Show
        vikram.dixit Vikram Dixit K added a comment - +1 LGTM.
        Hide
        thejas Thejas M Nair added a comment -

        Patch committed to branch-1.0 and trunk.

        Show
        thejas Thejas M Nair added a comment - Patch committed to branch-1.0 and trunk.
        Hide
        thejas Thejas M Nair added a comment -

        Brock Noland Can you please merge this into branch 1.1 ?

        Show
        thejas Thejas M Nair added a comment - Brock Noland Can you please merge this into branch 1.1 ?
        Hide
        brocknoland Brock Noland added a comment -

        Committed to 1.1.0 thx!

        Show
        brocknoland Brock Noland added a comment - Committed to 1.1.0 thx!
        Hide
        thejas Thejas M Nair added a comment -

        Updating release version for jiras resolved in 1.0.0 .

        Show
        thejas Thejas M Nair added a comment - Updating release version for jiras resolved in 1.0.0 .
        Hide
        thejas Thejas M Nair added a comment -

        This issue has been fixed in Apache Hive 1.0.0. If there is any issue with the fix, please open a new jira to address it.

        Show
        thejas Thejas M Nair added a comment - This issue has been fixed in Apache Hive 1.0.0. If there is any issue with the fix, please open a new jira to address it.

          People

          • Assignee:
            thejas Thejas M Nair
            Reporter:
            thejas Thejas M Nair
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development