spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dieter Vekeman (JIRA)" <>
Subject [jira] [Created] (SPARK-25013) JDBC urls with jdbc:mariadb don't work as expected
Date Fri, 03 Aug 2018 10:34:00 GMT
Dieter Vekeman created SPARK-25013:

             Summary: JDBC urls with jdbc:mariadb don't work as expected
                 Key: SPARK-25013
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.3.1
            Reporter: Dieter Vekeman

When using the MariaDB JDBC driver, the JDBC connection url should be  
However this does not work well in Spark (see below)

The MariaDB driver also supports using mysql which does work.

The problem seems to have been described and identified in:

All works well with spark using connection string with {{"jdbc:mysql:..."}}, but not using
{{"jdbc:mariadb:..."}} because MySQL dialect is then not used.
when not used, defaut quote is {{"}}, not {{`}}
So, some internal query generated by spark like {{SELECT `i`,`ip` FROM tmp}} will then be
executed as {{SELECT "i","ip" FROM tmp}} with dataType previously retrieved, causing the exception

The author of the comment says
{quote}I'll make a pull request to spark so "jdbc:mariadb:" connection string can be handle{quote}

Did the pull request get lost or should a new one be made?

This message was sent by Atlassian JIRA

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message