I guess I was mainly thinking about parquet tables created by Drill, in this case selecting a subset of the files wouldn't make sense, right ?
On Thu, Feb 11, 2016 at 10:32 AM, Steven Phillips <ste...@dremio.com> wrote: > I don't understand why they wouldn't be allowed. They seem perfectly valid. > > On Thu, Feb 11, 2016 at 9:42 AM, Abdel Hakim Deneche < > adene...@maprtech.com> > wrote: > > > I have the following table tpch100/lineitem that contains 97 parquet > files: > > > > tpch100/lineitem/part-m-00000.parquet > > tpch100/lineitem/part-m-00001.parquet > > tpch100/lineitem/part-m-00002.parquet > > > > ... > > tpch100/lineitem/part-m-00096.parquet > > > > I can run the following queries: > > > > SELECT COUNT(*) FROM `tpch100/lineit*; > > SELECT COUNT(*) FROM `tpch100/lineitem/part-m-0001*'; > > SELECT COUNT(*) FROM `tpch100/lineitem/*'; > > > > The third query will fail if the table has metadata (it has to do with > the > > .drill.parquet_metadata showing up at the top of the file system results) > > > > My question is: should the 2nd and 3rd queries be allowed, if we are > > querying a table folder that doesn't contain any sub folders ? > > > > -- > > > > Abdelhakim Deneche > > > > Software Engineer > > > > <http://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 > > > > > > -- Abdelhakim Deneche Software Engineer <http://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>