That's in the last bullet of the design doc's Syntax section: Dynamic Partitions -- Syntax <https://cwiki.apache.org/confluence/display/Hive/DynamicPartitions#DynamicPartitions-Syntax>. It was in the original document created by Carl Steinbach in 2011.
-- Lefty On Mon, Oct 20, 2014 at 8:47 PM, Sergey Shelukhin <ser...@hortonworks.com> wrote: > Hi. > Hive manual describes the following syntax for CTAS: > CREATE TABLE T (key int, value string) PARTITIONED BY (ds string, hr int) > AS > SELECT key, value, ds, hr+1 hr1 FROM srcpart WHERE ds is not null and > hr>10; > and similar statements. As far as I can tell, this is not actually > supported. Is that an error? > > -- > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity to > which it is addressed and may contain information that is confidential, > privileged and exempt from disclosure under applicable law. If the reader > of this message is not the intended recipient, you are hereby notified that > any printing, copying, dissemination, distribution, disclosure or > forwarding of this communication is strictly prohibited. If you have > received this communication in error, please contact the sender immediately > and delete it from your system. Thank You. >