You can create a view that renames the columns to whatever you like. For example:
CREATE VIEW mydata AS SELECT dir0 as "year", dir1 as "month", dir2 as "day", dir3 as "hour", a, b, ..., z FROM `/warehouse/database/table/` Then you can query: select * from mydata where year = 2012 -- Jacques Nadeau CTO and Co-Founder, Dremio On Fri, Sep 4, 2015 at 2:35 PM, Grant Overby (groverby) <[email protected]> wrote: > I’m using parquet files in hdfs. My files are stored thusly: > > /warehouse/database/table/field0/field1/field2/field3/fileX.parquet > > I’d like to give a name to field0..3 that could be used in queries in > stead of dir0, dir1, dir2, dir3. Is this possible? > [ > http://www.cisco.com/web/europe/images/email/signature/est2014/logo_06.png?ct=1398192119726 > ] > > Grant Overby > Software Engineer > Cisco.com<http://www.cisco.com/> > [email protected]<mailto:[email protected]> > Mobile: 865 724 4910 > > > > > > > [http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif] Think > before you print. > > This email may contain confidential and privileged material for the sole > use of the intended recipient. Any review, use, distribution or disclosure > by others is strictly prohibited. If you are not the intended recipient (or > authorized to receive for the recipient), please contact the sender by > reply email and delete all copies of this message. > > Please click here< > http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for > Company Registration Information. > > > > >
