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
|