One option would be to take your reporting results and do a create table as select (CTAS) and use parquet files which can be very fast. Let's say you were doing aggregations by day...
Create table aggbyday as Select dayfield, count(1) as cntbyday from log table group by dayfield Then point your reporting tool at drill with odbc or jdbc That's our plan for reporting at least. On Tuesday, December 1, 2015, Nirav Shah <[email protected]> wrote: > Thanks Magnus, > > I am fetching data from log files --> Processing It --> want to move to > MySql for reporting. > > Regards, > Nirav > > On Tue, Dec 1, 2015 at 3:10 PM, Magnus Pierre <[email protected] > <javascript:;>> wrote: > > > Hello Nirav, > > To my knowledge (just a user so I don’t have any deep insights) there’s > no > > such functionality as of now included in Apache Drill. It could be added > > but focus has been on getting data from RDBMS in a convenient way rather > > than moving data to RDBMS. > > > > Regards, > > Magnus > > > > > 1 dec 2015 kl. 10:31 skrev Nirav Shah <[email protected] > <javascript:;>>: > > > > > > Hi, > > > > > > I am trying to move data from drill to mysql. is Insert/update allowed > > > from drill to MySQL? > > > If yes than how? > > > > > > Thanks in advance. > > > > > > Best, > > > Nirav > > > > > -- Sent from my iThing
