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 >>