Hi Charls, Thanks for your suggestion. Actually the transactions folder will have more yearwise folder. But i want to query only few folders at a time. The
Regards Prabhakar On Fri, Jan 17, 2020, 20:01 Charles Givre <[email protected]> wrote: > Hi there, > If you have that directory structure, the following query should work: > > SELECT * > FROM dfs.<workspace>.`transactions/` as t1 > > Obviously replacing <workspace> with your workspace. You can then join > that with anything that Drill can query. > Best, > -- C > > > > > On Jan 17, 2020, at 1:27 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 > >
