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 <the...@hortonworks.com> wrote: > 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 > <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. > > -- > 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. > -- 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.
