You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by luoc <lu...@apache.org> on 2021/04/02 13:23:23 UTC

[DISCUSSION] One of the most impressive features

Hi all,
  I'm from drill team, there will be many new features in release 1.19, However, I’m also looking forward to getting your reply about using drill.
  At ApacheCon 2021 ( + ApacheCon 2021 Asia), there is a topic about track drill talk, So I hope for a positive response that what is one of the most impressive features of drill in your projects?
  That’s for all the developers and drill users, Thanks for your time.

Kind regards
luoc

Re: [DISCUSSION] One of the most impressive features

Posted by Markenson França <ma...@gmail.com>.

Cool!

If you need something, fell free to tell me.

Regards,
Markenson Paulo França


Em sáb., 3 de abr. de 2021 às 09:51, luoc <lu...@apache.org> escreveu:

> Hi Prabhakar,
>   We welcome your feedback.
>
> > 2021年4月3日 下午8:48，luoc <lu...@apache.org> 写道：
> >
> > Hi Markenson,
> >  That’s wonderful. Your use-case is very detailed and comprehensive.
> there's a good chance show at the ApacheCon. I'm also looking forward to
> your contribution. Please let us know if you have any  issues in
> development.
> >
> >> 2021年4月3日 下午8:31，Prabhakar Bhosaale <bh...@gmail.com> 写道：
> >>
> >> Hey Luoc,
> >> nice to hear the updates in 1.19. will see how i can fit it one of real
> >> usecase.
> >>
> >>
> >> Regards
> >> Prabhakar
> >>
> >> On Sat, Apr 3, 2021 at 5:55 PM luoc <lu...@apache.org> wrote:
> >>
> >>> Hi Prabhakar,
> >>> Great. Drill can combine data from multiple data sources on the fly in
> a
> >>> single query, federated query & analysis is one of the features of
> apache
> >>> drill. That's exactly what I love about drill.
> >>> In release 1.19, drill supported the Cassandra/Scylla, ElasticSearch,
> >>> Splunk, XML and more. Then, they are based on the EVF framework, more
> >>> stability and more powerful than previous version.
> >>>
> >>>> 2021年4月3日 下午8:19，Markenson França <ma...@gmail.com> 写道：
> >>>>
> >>>> Hi Luoc and Prabhakar,
> >>>>
> >>>> We use Drill for data merging in Brazillian Federal Court at Rio de
> >>> Janeiro.
> >>>>
> >>>> We developed two stages: extraction and consolidation.
> >>>>
> >>>> Extractor get data from several databases (Oracle, MySql, Postgres,
> >>>> SqlServer, Ingres, Http and MUMPS) put them in a standard plain text
> >>>> format.
> >>>>
> >>>> Consolidator is a piece of Python code using Dril for getting all data
> >>>> pieces of plain text and combine them in same standard format.
> >>>>
> >>>> The result are data blocks available by tematic area (HR, Aquisition
> >>>> sector, Law data, etc ) used directely by users (Excel importing via
> >>>> network paths) or available through Metabase*.
> >>>>
> >>>> Using Drill at consolidation stage we are  avoiding production servers
> >>>> overload and joining unthinkable databases like  MUMPS+Oracle+SQL
> Server.
> >>>> Drill consolidation works at speed of the light (thanks for Drill
> >>>> performance). Querying plain data with SQL is amazing.
> >>>>
> >>>> Regards,
> >>>> Markenson
> >>>>
> >>>> *I have been used a csv driver Metabase we developed to publish Drill
> >>> data
> >>>> for users (https://github.com/Markenson/csv-metabase-driver). I'm
> >>> trying to
> >>>> developed a driver for Drill via jdbc.
> >>>>
> >>>>
> >>>>
> >>>> Em sáb, 3 de abr de 2021 08:18, Prabhakar Bhosaale <
> >>> bhosale.p.v@gmail.com>
> >>>> escreveu:
> >>>>
> >>>>> Hi Luoc,
> >>>>> the impressive feature for me is to query the data from files
> >>>>> (json,csv,parquette etc.) using sql syntax. This makes life very
> easy.
> >>>>> Also i am not sure as i have not tried it but i guess i can query two
> >>>>> different storage (json file and oracle database) and combine the
> data.
> >>>>> thx
> >>>>>
> >>>>> Regards
> >>>>> Prabhakar
> >>>>>
> >>>>> On Fri, Apr 2, 2021 at 6:53 PM luoc <lu...@apache.org> wrote:
> >>>>>
> >>>>>> Hi all,
> >>>>>> I'm from drill team, there will be many new features in release
> 1.19,
> >>>>>> However, I’m also looking forward to getting your reply about using
> >>>>> drill.
> >>>>>> At ApacheCon 2021 ( + ApacheCon 2021 Asia), there is a topic about
> >>>>> track
> >>>>>> drill talk, So I hope for a positive response that what is one of
> the
> >>>>> most
> >>>>>> impressive features of drill in your projects?
> >>>>>> That’s for all the developers and drill users, Thanks for your time.
> >>>>>>
> >>>>>> Kind regards
> >>>>>> luoc
> >>>>>
> >>>
> >>>
> >
>
>