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:[email protected]] Sent: Wednesday, April 22, 2015 5:34 AM To: [email protected] 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>
