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 <[email protected]> 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 <[email protected]> 写道： > > > > 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 < > [email protected]> > > 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 <[email protected]> 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 > >> > >
