Thanks John,
That's our future plan but for now our main datastore is in MySQL which
collects data from many sources. We are migrating one by one. So for now we
have to move this data to MySQL.
I found solution from one of the site
http://stackoverflow.com/questions/31014910/write-drill-query-out
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
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 wrote:
> Hello Nirav,
> To my knowledge (just a user so I don’t have any deep insights) there’s no
> such functionality as of
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.
