You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@zeppelin.apache.org by "Seok-Joon,Yun (JIRA)" <ji...@apache.org> on 2018/04/01 07:27:00 UTC

[jira] [Created] (ZEPPELIN-3376) Can't apply jdbc option method

Seok-Joon,Yun created ZEPPELIN-3376:
---------------------------------------

             Summary: Can't apply jdbc option method
                 Key: ZEPPELIN-3376
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-3376
             Project: Zeppelin
          Issue Type: Bug
          Components: Interpreters
         Environment: zeppelin lastest version
            Reporter: Seok-Joon,Yun


I used spark.read.format("jdbc"). I need using unicode option. So I use this way.

 

val df = spark.read.format("jdbc").option("url", "jdbc:mysql:/...3306/dbname").option("dbtable", query).option("user", "username").option("password", "password").option("useUnicode", "true").option("characterEncoding", "utf8").load()

 

But It is not executed, because query contains Korean words.

So I change code this way.

 

val df = spark.read.format("jdbc").option("url", "jdbc:mysql:/...3306/dbname?useUnicode=true&characterEncoding=utf8").option("dbtable", query).option("user", "username").option("password", "password").load()

 

It worked well.

 

I can not be sure this is a zeppelin problem. It maybe problem of jdbc driver or spark library.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)