Unsubscribe
Get Outlook for Android<https://aka.ms/ghei36>
________________________________
From: Prabhakar Bhosaale <bhosale.p.v@gmail.com>
Sent: Friday, January 17, 2020 12:27:15 AM
To: user@drill.apache.org <user@drill.apache.org>
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
|