drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abdel Hakim Deneche <adene...@maprtech.com>
Subject Re: CTAS on MySQL*
Date Fri, 03 Jun 2016 18:28:22 GMT
MySQL storage plugin is indeed read only, you cannot create a table on
mysql through Drill.


On Fri, Jun 3, 2016 at 10:05 AM, Shankar Mane <shankar.mane@games24x7.com>

> As we know, we can able to read MySQL data using drill mysql storage
> plugin. But it seems it is Read Only and No Write permissions .
> Can we create table (CTAS) on mysql ?
> If it is possible, We can able to configured Read/Write permissions at
> mysql Storage plugin Level. Storage plgins like dfs, hive has this setting.
> * Doing CTAS on mysql and Reading from MySQL is very costly and it might
> also defeat the purpose of distributed storage and multi-node executions
> regards,
> shankar


Abdelhakim Deneche

Software Engineer


Now Available - Free Hadoop On-Demand Training

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message