[BAHIR-229] JdbcStreamWriter.scala caused an error if used with postgreSql JDBC driver

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Spark-2.3.0
• Fix Version/s: Spark-2.4.0
• Component/s: Spark Structured Streaming Connectors

Environment

Windows 10
<dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.2.12</version>
        </dependency>

• Assignee: Unassigned
• Reporter: Max Khlupnov
• Created: 18/May/20 21:48
• Updated: 18/May/20 21:48

Description

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*