chestnut-c commented on code in PR #9607:
URL: https://github.com/apache/seatunnel/pull/9607#discussion_r2222492147
##########
seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/vertica/VerticaDialect.java:
##########
@@ -53,16 +54,35 @@ public String quoteIdentifier(String identifier) {
@Override
public Optional<String> getUpsertStatement(
String database, String tableName, String[] fieldNames, String[]
uniqueKeyFields) {
+ return Optional.empty();
+ }
+
+ @Override
+ public Optional<String> getUpsertStatementByTableSchema(
+ String database, String tableName, TableSchema tableSchema,
String[] uniqueKeyFields) {
+ String[] fieldNames = tableSchema.getFieldNames();
List<String> nonUniqueKeyFields =
Arrays.stream(fieldNames)
.filter(fieldName ->
!Arrays.asList(uniqueKeyFields).contains(fieldName))
.collect(Collectors.toList());
String valuesBinding =
- Arrays.stream(fieldNames)
- .map(fieldName -> ":" + fieldName + " " +
quoteIdentifier(fieldName))
+ tableSchema.getColumns().stream()
+ .map(
+ column -> {
+ String fieldName = column.getName();
+ String sourceType = column.getSourceType();
+ return "CAST("
+ + ":"
+ + fieldName
+ + " AS "
+ + sourceType
+ + ")"
+ + " AS "
+ + quoteIdentifier(fieldName);
Review Comment:
> why we must add cast as statement? Is it the only way to fix
`[Vertica]VJDBC ERROR: Failed to find conversion function from unknown to in`
error?
@Hisoka-X Yes, after testing, vertica jdbc currently needs to display the
specified type to execute, and the same error occurs when upgrading to a higher
version. The test found that the inferred type is not supported and needs to be
explicitly specified to succeed
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
