title: load array data mysql to ElasticSearch using logstash jdbc
body: <p>Hi i am new to ES and i m trying to load data from 'MYSQL' to 'Elasticsearch'</p>
  
  <p>I am getting below error when trying to loadata in array format, any help</p>
  
  <p>Here is mysql data, need array data for new &amp; hex value columns</p>
  
  <pre><code>cid  color      new     hex      create            modified
  1    100 euro   abcd   #86c67c  5/5/2016 15:48   5/13/2016 14:15
  1    100 euro    1234   #fdf8ff  5/5/2016 15:48   5/13/2016 14:15
  </code></pre>
  
  <p>Here us the logstash config</p>
  
  <pre><code>input {
   jdbc {
     jdbc_driver_library =&gt; "/etc/logstash/mysql/mysql-connector-java-5.1.39-bin.jar"
     jdbc_driver_class =&gt; "com.mysql.jdbc.Driver"
     jdbc_connection_string =&gt; "jdbc:mysql://127.0.0.1:3306/test"
     jdbc_user =&gt; "root"
     jdbc_password =&gt; "*****"
     schedule =&gt; "* * * * *"
  
     statement =&gt; "select cid,color, new as 'cvalue.new',hexa_value as 'cvalue.hexa',created,modified from colors_hex_test order by cid"
     jdbc_paging_enabled =&gt; "true"
     jdbc_page_size =&gt; "50000"
  }
  }
  
  output {
      elasticsearch {
          index =&gt; "colors_hexa"
          document_type =&gt; "colors"
          document_id =&gt; "%{cid}"
          hosts =&gt; "localhost:9200"
  </code></pre>
  
  <p>Need array data for cvalue (new, hexa) like</p>
  
  <pre><code>{
    "_index": "colors_hexa",
    "_type": "colors",
    "_id": "1",
    "_version": 218,
    "found": true,
    "_source": {
      "cid": 1,
      "color": "100 euro",
      "cvalue" : {
              "new": "1234",
              "hexa_value": "#fdf8ff",
          }
      "created": "2016-05-05T10:18:51.000Z",
      "modified": "2016-05-13T08:45:30.000Z",
      "@version": "1",
      "@timestamp": "2016-05-14T01:30:00.059Z"
    }
  }
  </code></pre>
  
  <p>this is the error i m getting while running logstash</p>
  
  <pre><code> "status"=&gt;400, "error"=&gt;{"type"=&gt;"mapper_parsing_exception",
   "reason"=&gt;"Field name [cvalue.hexa] cannot contain '.'"}}}, :level=&gt;:warn}
  </code></pre>