Hi, Drill can easily query directories including subdirectories and then join data with other directories, tables etc. Please refer to Drill documentation for more details. For example, you can start from this article: https://drill.apache.org/docs/querying-directories/ <https://drill.apache.org/docs/querying-directories/>
Kind regards, Arina > On Jan 14, 2020, at 11:56 AM, Prabhakar Bhosaale <[email protected]> > wrote: > > Hi All, > > I am new to apache drill and trying to retrieve data from json files by > querying the directories. > > The directory structure is > > |------>Year2012--->trans.json > | > | > transactions-->| > | > |------>Year2013--->trans.json > > I would like to query trans.json from both the sub-directories as one table > and then join the resultant table with another table in a single query. > Please help with possible options. thx > > Regards > Prabhakar
