Hi, Reading the wiki on dynamic partition, there is best practice example to solve the issue of creating too many dynamic partitions on a specific node. However, the query does not work. (http://wiki.apache.org/hadoop/Hive/Tutorial#Dynamic-partition_Insert)
Is this form of query support? FROM table_a INSERT OVERWRITE TABLE table_b PARTITION(dt) SELECT * FROM ( SELECT *, dt DISTRIBUTE BY dt ) T; Thanks, --wil