drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prabhakar Bhosaale <bhosale....@gmail.com>
Subject querying json from multiple subdirectories
Date Tue, 14 Jan 2020 09:56:29 GMT 
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
Prabhakar
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message