Not sure about that, but this is supported:
FROM (SELECT *, dt from table_a DISTRIBUTE BY dt) T
INSERT OVERWRITE TABLE table_b PARTITION(dt)
SELECT * ;
On Mar 1, 2011, at 5:28 AM, Wil - wrote:
> 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.
> Is this form of query support?
> FROM table_a
> INSERT OVERWRITE TABLE table_b PARTITION(dt)
> SELECT * FROM (
> SELECT *, dt
> DISTRIBUTE BY dt
> ) T;