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)
