hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <>
Subject Re: CTAS error in manual
Date Tue, 21 Oct 2014 02:26:51 GMT
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, Sergey Shelukhin <>

> 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?
> --
> 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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message