You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Andy Pernsteiner <ap...@maprtech.com> on 2015/04/22 14:33:44 UTC
Proper syntax for CTAS w/ Partition By
I'm trying to use CTAS in drill to create a parquet table that is
partitioned by 2 columns (equity -> date). I'm not finding a direct
reference on how to do this. Does someone have an example of how they were
able to accomplish this?
--
Andy Pernsteiner
Manager, Field Enablement
ph: 206.228.0737
www.mapr.com
Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
Re: Proper syntax for CTAS w/ Partition By
Posted by NeerajaMapR <nr...@maprtech.com>.
Auto partitioning using CTAS syntax is not available yet.
> On Apr 22, 2015, at 7:23 AM, Sivasubramaniam, Latha <La...@Aspect.com> wrote:
>
> I was looking for the same and did not find a syntax for that. One of the earlier post indicated that it is not supported yet.
>
> -Latha
>
> -----Original Message-----
> From: Andy Pernsteiner [mailto:apernsteiner@maprtech.com]
> Sent: Wednesday, April 22, 2015 5:34 AM
> To: user@drill.apache.org
> Subject: Proper syntax for CTAS w/ Partition By
>
> I'm trying to use CTAS in drill to create a parquet table that is partitioned by 2 columns (equity -> date). I'm not finding a direct reference on how to do this. Does someone have an example of how they were able to accomplish this?
>
>
>
> --
> Andy Pernsteiner
> Manager, Field Enablement
> ph: 206.228.0737
>
> www.mapr.com
>
> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
RE: Proper syntax for CTAS w/ Partition By
Posted by "Sivasubramaniam, Latha" <La...@Aspect.com>.
I was looking for the same and did not find a syntax for that. One of the earlier post indicated that it is not supported yet.
-Latha
-----Original Message-----
From: Andy Pernsteiner [mailto:apernsteiner@maprtech.com]
Sent: Wednesday, April 22, 2015 5:34 AM
To: user@drill.apache.org
Subject: Proper syntax for CTAS w/ Partition By
I'm trying to use CTAS in drill to create a parquet table that is partitioned by 2 columns (equity -> date). I'm not finding a direct reference on how to do this. Does someone have an example of how they were able to accomplish this?
--
Andy Pernsteiner
Manager, Field Enablement
ph: 206.228.0737
www.mapr.com
Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>