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


      

Reply via email to