Re: CTAS error in manual

Specifying columns for CTAS is not supported, nor is dynamic partitioning with CTAS (it gives explicit errors when trying to run the query above or similar ones). I was trying to run these queries yesterday. On Mon, Oct 20, 2014 at 8:59 PM, Thejas Nair wrote: > Sergey, what part is not supported

Re: CTAS error in manual

Sergey, what part is not supported ? Are you referring to the type being specified for the destination table in CTAS ? On Mon, Oct 20, 2014 at 5:47 PM, Sergey Shelukhin wrote: > Hi. > Hive manual describes the following syntax for CTAS: > CREATE TABLE T (key int, value string) PARTITIONED BY (ds

Re: CTAS error in manual

That's in the last bullet of the design doc's Syntax section: Dynamic Partitions -- Syntax . It was in the original document created by Carl Steinbach in 2011. -- Lefty On Mon, Oct 20, 2014 at 8:47 PM, S