drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Blondowski <dan.blondow...@dhigroupinc.com>
Subject Re: Querying json files from multiple subdirectories
Date Fri, 17 Jan 2020 14:43:27 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message