drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arina Yelchiyeva <arina.yelchiy...@gmail.com>
Subject Re: querying json from multiple subdirectories
Date Tue, 14 Jan 2020 10:14:49 GMT
Hi, 

Drill can easily query directories including subdirectories and then join data with other
directories, tables etc.
Please refer to Drill documentation for more details.
For example, you can start from this article: 
https://drill.apache.org/docs/querying-directories/ <https://drill.apache.org/docs/querying-directories/>


Kind regards,
Arina

> On Jan 14, 2020, at 11:56 AM, Prabhakar Bhosaale <bhosale.p.v@gmail.com> wrote:
> 
> 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