Disallow useless DISTRIBUTE BY/SORT BY/CLUSTER BY in strict mode ----------------------------------------------------------------
Key: HIVE-2537 URL: https://issues.apache.org/jira/browse/HIVE-2537 Project: Hive Issue Type: Improvement Reporter: Adam Kramer Priority: Minor This query: CREATE TABLE my_tablename AS SELECT a, b, c FROM somewhere CLUSTER BY c; ...has an unnecessary CLUSTER BY, because the resulting data will be loaded into a non-bucketed table without any enforcement of bucketing. We should disallow this in strict mode. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira