Max Khlupnov created BAHIR-229:
----------------------------------
Summary: JdbcStreamWriter.scala caused an error if used with
postgreSql JDBC driver
Key: BAHIR-229
URL: https://issues.apache.org/jira/browse/BAHIR-229
Project: Bahir
Issue Type: Bug
Components: Spark Structured Streaming Connectors
Affects Versions: Spark-2.3.0
Environment: Windows 10
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.12</version>
</dependency>
Reporter: Max Khlupnov
Fix For: Spark-2.4.0
Attachments: consoleLog.txt
h2. *JdbcStreamWriter.scala caused an error for PostgreSql JDBC driver:*
*org.postgresql.util.PSQLException: ERROR: syntax error at or near "REPLACE"*
*Postgre doesn't support REPLACE keyword only INSERT. However REPLACE
hardcoded.*
*Only mySql supports REPLACE keyword all other Jdbc driver will fail*
*https://github.com/apache/bahir/blob/d1200cb1cab57ac337b067443d47cef67d574fbd/sql-streaming-jdbc/src/main/scala/org/apache/bahir/sql/streaming/jdbc/JdbcStreamWriter.scala*
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
