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 >
