drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject Re: querying json from multiple subdirectories
Date Tue, 14 Jan 2020 12:13:05 GMT
Hi Prabhakar, 
I would think that the following query would work:

SELECT <fields>
FROM dfs.<workspace>.`transactions/`

That should merge everything into one table and you should get a dir0 column with the directory
names.

--C

> On Jan 14, 2020, at 4: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
View raw message