Unsubscribe Get Outlook for Android<https://aka.ms/ghei36>
________________________________ From: Prabhakar Bhosaale <[email protected]> Sent: Friday, January 17, 2020 12:27:15 AM To: [email protected] <[email protected]> Subject: Querying json files from multiple subdirectories This message originated from outside of DHI 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
