title: How to write spark dataframe to impala database
body: <p>I use the following code to write the spark dataframe to impala through JDBC connection.</p>
  
  <pre><code>df.write.mode("append").jdbc(url="jdbc:impala://10.61.1.101:21050/test;auth=noSasl",table="t_author_classic_copy", pro)
  </code></pre>
  
  <p>But I get the following error: java.sql.SQLException: No suitable driver found</p>
  
  <p>then I change the mode:</p>
  
  <pre><code>df.write.mode("overwrite").jdbc(url="jdbc:impala://10.61.1.101:21050/test;auth=noSasl",table="t_author_classic_copy", pro)
  </code></pre>
  
  <p>but it still get an error: </p>
  
  <pre><code>CAUSED BY: Exception: Syntax error
  ), Query: CREATE TABLE t_author_classic_copy1 (id TEXT NOT NULL, domain_id TEXT NOT NULL, pub_num INTEGER , cited_num INTEGER , rank DOUBLE PRECISION ).
  </code></pre>