Timothy Garza created HIVE-12553: ------------------------------------ Summary: 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)