Hive
  1. Hive
  2. HIVE-2058

MySQL Upgrade scripts missing new defaults for two table's columns

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 0.7.0
    • Fix Version/s: None
    • Component/s: Metastore
    • Labels:
      None

      Description

      Upgraded from 0.5.0 to 0.7.0, and the upgrade scripts to 0.6.0 and 0.7.0 did not have two defaults that are necessary for being able to create a hive table. The columns missing default values are:

      COLUMNS.INTEGER_IDX
      SDS.IS_COMPRESSED

      I set them both to zero(0) (false for IS_COMPRESSED, obviously)

      The absence of these two default prevents the ability to create a table in Hive.

        Activity

        Stephen Tunney created issue -
        Stephen Tunney made changes -
        Field Original Value New Value
        Labels derby_triage10_5_2
        Alexander Alten-Lorenz made changes -
        Assignee Alexander Alten-Lorenz [ alo.alt ]
        Thejas M Nair made changes -
        Priority Blocker [ 1 ] Major [ 3 ]
        Thejas M Nair made changes -
        Affects Version/s 0.7.0 [ 12315150 ]
        Hide
        Thejas M Nair added a comment -

        This is an issue that was reported for hive 0.7, and it is not clear if this issue is present in newer versions, so marking it as major instead of blocker.

        Stephen Tunney
        Is this an issue with upgrade script for one particular database (derby?) ? (I see you had a derby label earlier).

        Show
        Thejas M Nair added a comment - This is an issue that was reported for hive 0.7, and it is not clear if this issue is present in newer versions, so marking it as major instead of blocker. Stephen Tunney Is this an issue with upgrade script for one particular database (derby?) ? (I see you had a derby label earlier).

          People

          • Assignee:
            Alexander Alten-Lorenz
            Reporter:
            Stephen Tunney
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:

              Development