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 <[email protected]> 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>
