Re: create table in mysql db

[Andries Engelbrecht]

Unfortunately Drill can not write to MySQL, only read. Perhaps write to a CSV 
file on HDFS and then import the CSV file into MySQL.

Regards
--Andries


On 3/28/18, 5:50 AM, "Shrinivas Deshmukh" <shrinivas.deshmuk...@gmail.com> 
wrote:

    Hi,
    
    This is Shrinivas.
    
    I am joining a mysql db table with a csv file in hdfs. I want to store the
    results in a new mysql db table. I get an error :  Schema [MySQL.dummy] is
    immutable.
    
    MySQL is my mysql plugin name and dummy is the database name.
    
    Here is my MySQL plugin configuration :
    {
      "type": "jdbc",
      "driver": "com.mysql.jdbc.Driver",
      "url": "jdbc:mysql://host:3306",
      "username": "root",
      "password": "",
      "enabled": true
    }
    
    Please help me.
    
    Thank you.
    
    Regards,
    Shrinivas Deshmukh.