hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12553) MySQL Metastore hive.stats.autogather
Date Thu, 31 Mar 2016 16:56:25 GMT

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

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

I wonder if this is an issue specific to the the EMR variant of hive. 
I don't see a table definition by that name  (PARTITION_STATS_VS ) in apache hive codebase.
I checked master and branch-1.2 .

cc [~ashutoshc]

> MySQL Metastore hive.stats.autogather
> -------------------------------------
>
>                 Key: HIVE-12553
>                 URL: https://issues.apache.org/jira/browse/HIVE-12553
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 1.2.1
>         Environment: AWS EMR Hadoop Cluster(Amazon Linux AMI release 2015.03) , MySQL
v5.5.42 (Hive Metastore)
>            Reporter: Timothy Garza
>
> PARTITION_STATS_VS table is autogenerated in the Hive Metastore when AutoGather Stats
setting is active (default).
> The CREATE TABLE statement fails due to syntax errors because the Primary Key column
of the table is set to varchar(4000) which is beyond the maximum limitation of a MySQL key
of 767 bytes.
> Even if you create the table manually using an appropriate setting, eg varchar(255) the
AutoGather functionality will detect this and ALTER the table column to be varchar(4000).
This again fails to execute.
> Error:
> ERROR jdbc.JDBCStatsPublisher: Error during JDBC initialization.
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long;
max key length is 767 bytes



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message