title: java.lang.IllegalArgumentException: Can't get JDBC type for array<string>
body: <p><em>I want to import the output data into the mysql database, but the following error occurs, I will not convert the array to the desired string type, can help me?</em></p>
  
  <pre><code> val Array(trainingData, testData) = msgDF.randomSplit(Array(0.9, 0.1))
      val pipeline = new Pipeline().setStages(Array(labelIndexer, word2Vec, mlpc, labelConverter))
      val model = pipeline.fit(trainingData)
      val predictionResultDF = model.transform(testData)
      val rows = predictionResultDF.select("song", "label", "predictedLabel")
      val df = rows.registerTempTable("song_classify")
      val sqlcommand = "select * from song_classify"
      val prop = new java.util.Properties
      prop.setProperty("user", "root")
      prop.setProperty("password", "123")
      sqlContext.sql(sqlcommand)
        .write.mode(SaveMode.Append).jdbc("jdbc:mysql://localhost:3306/yuncun", "song_classify", prop)
      sc.stop
  </code></pre>
  
  <p><em>Here is the console output</em></p>
  
  <pre><code>Exception in thread "main" java.lang.IllegalArgumentException: Can't get JDBC type for array&lt;string&gt;
      at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$getJdbcType$2.apply(JdbcUtils.scala:148)
      at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$getJdbcType$2.apply(JdbcUtils.scala:148)
      at scala.Option.getOrElse(Option.scala:121)
  </code></pre>
  
  <p><strong><em>I want to store the following data in the mysql database</em></strong></p>
  
  <pre><code>+---------+-----+--------------+
  |     song|label|predictedLabel|
  +---------+-----+--------------+
  |   [一吻天荒]|    1|             2|
  |  [有一点动心]|    1|             2|
  |   [有你真好]|    1|             2|
  |  [永远不分开]|    1|             2|
  |[我要我们在一起]|    2|             2|
  |  [后来的我们]|    2|             2|
  |     [喜欢]|    2|             2|
  |     [夜车]|    2|             2|
  |   [寂寞疯了]|    2|             2|
  |     [拥抱]|    2|             2|
  |   [方圆几里]|    2|             2|
  |   [时间煮雨]|    2|             2|
  |    [爱上你]|    2|             2|
  |     [献世]|    2|             2|
  |   [说散就散]|    2|             2|
  +---------+-----+--------------+
  </code></pre>
  
  <p><strong>But the first column is an array, so the program is getting an error</strong></p>
  
  <p><strong>Can you help me propose a change plan? Thank you</strong></p>