You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2013/11/26 21:00:36 UTC

[jira] [Commented] (HIVE-5893) hive-schema-0.13.0.mysql.sql contains reference to nonexistent column

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

Carl Steinbach commented on HIVE-5893:
--------------------------------------

{noformat}
mysql> source hive-schema-0.13.0.mysql.sql
source hive-schema-0.13.0.mysql.sql
...
ERROR 1054 (42S22): Unknown column 'VERSION_COMMENT' in 'field list'
Query OK, 0 rows affected (0.00 sec)
...
{noformat}

Here's the problem:

{noformat}
% diff hive-schema-0.12.0.mysql.sql hive-schema-0.13.0.mysql.sql 
diff hive-schema-0.12.0.mysql.sql hive-schema-0.13.0.mysql.sql 
760c760
<   `VERSION_COMMENT` VARCHAR(255),
---
>   `COMMENT` VARCHAR(255),
764c764
< INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '0.12.0', 'Hive release version 0.12.0');
---
> INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '0.13.0', 'Hive release version 0.13.0');
%
{noformat}


> hive-schema-0.13.0.mysql.sql contains reference to nonexistent column
> ---------------------------------------------------------------------
>
>                 Key: HIVE-5893
>                 URL: https://issues.apache.org/jira/browse/HIVE-5893
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.13.0
>            Reporter: Carl Steinbach
>




--
This message was sent by Atlassian JIRA
(v6.1#6144)