[
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)
