Hi Divya, this is the expected behavior [1]:
The output of CTAS using a PARTITION BY clause creates separate files. Each >> file contains one partition value, and Drill can create multiple files for >> the same partition value. > > Partition pruning uses the Parquet column statistics to determine which >> columns can be used to prune. > > [1] https://drill.apache.org/docs/partition-by-clause/ Kind regards Arina On Fri, Jul 28, 2017 at 9:03 AM, Divya Gehlot <[email protected]> wrote: > Hi, > I have created the parquet table using CTAS PARTITION BY (Partition1,.....) > but it didnt created the partition directories , all the parquet files are > under directory . > > Am I missing something ? > Appreciate the help. > > Thanks, > > Divya >
