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
