[
https://issues.apache.org/jira/browse/HIVE-12553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16340951#comment-16340951
]
Ping Lu commented on HIVE-12553:
--------------------------------
The table name should be PARTITION_STATS_V2.
> 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
> Priority: Major
>
> 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
(v7.6.3#76005)
