Querying json files from multiple subdirectories

[Prabhakar Bhosaale]

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