[jira] [Commented] (HIVE-12553) MySQL Metastore hive.stats.autogather

["Aleksey Vovchenko (JIRA)" <ji...@apache.org>]

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