MySQL storage plugin is indeed read only, you cannot create a table on
mysql through Drill.
Thanks
On Fri, Jun 3, 2016 at 10:05 AM, Shankar Mane <shankar.mane@games24x7.com>
wrote:
> 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
<http://www.mapr.com/>
Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
|