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 <bhosale....@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 <l...@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 <markensonfra...@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....@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 <l...@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 >>>> >> >>