Hi Markenson, it is really nice use case. I guess with this kind use of data i guess ppl will be able to save more on their servers.
REgards Prabhakar On Sat, Apr 3, 2021 at 5:50 PM Markenson França <[email protected]> wrote: > 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 > > >
