[
https://issues.apache.org/jira/browse/HIVE-12553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15232642#comment-15232642
]
Aleksey Vovchenko commented on HIVE-12553:
------------------------------------------
This table is created in JDBCStatsPublisher.java in 291 line. When
JDBCStatsUtils.getCreate("")(in line 290) executes it uses constants containing
table name and Primary Key size.
> 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)
