Hi Charls,
Thanks for your suggestion. Actually the transactions folder will have more
yearwise folder. But i want to query only few folders at a time. The
Regards
Prabhakar
On Fri, Jan 17, 2020, 20:01 Charles Givre <cgivre@gmail.com> wrote:
> Hi there,
> If you have that directory structure, the following query should work:
>
> SELECT *
> FROM dfs.<workspace>.`transactions/` as t1
>
> Obviously replacing <workspace> with your workspace. You can then join
> that with anything that Drill can query.
> Best,
> -- C
>
>
>
> > On Jan 17, 2020, at 1:27 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
>
>
|