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.

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>

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