Hi Prabhakar, I would think that the following query would work: SELECT <fields> FROM dfs.<workspace>.`transactions/`
That should merge everything into one table and you should get a dir0 column with the directory names. --C > On Jan 14, 2020, at 4: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
