[jira] [Commented] (HIVE-2058) MySQL Upgrade scripts missing new defaults for two table's columns

["Thejas M Nair (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-2058?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13756270#comment-13756270 ] 

Thejas M Nair commented on HIVE-2058:
-------------------------------------

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.

[~stunney]
Is this an issue with upgrade script for one particular database (derby?) ? (I see you had a derby label earlier).


                
> MySQL Upgrade scripts missing new defaults for two table's columns
> ------------------------------------------------------------------
>
>                 Key: HIVE-2058
>                 URL: https://issues.apache.org/jira/browse/HIVE-2058
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.7.0
>            Reporter: Stephen Tunney
>            Assignee: Alexander Alten-Lorenz
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira