JDBC does not support presto

[qinzl1]

@metadaddy
Hi Does SDC JDBC not support presto

JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Unrecognized connection property ''

[metadaddy]

It looks like the Presto JDBC driver is not responding correctly. Hard to say what the problem is without a stack trace from sdc.log

Feel free to engage further via the StreamSets community - https://streamsets.com/community - this really isn't an issue with the tutorials.

[qinzl1]

@metadaddy
[stage:] DEBUG HikariConfig - HikariPool-175 - configuration:
[stage:] DEBUG HikariConfig - allowPoolSuspension.............false
[stage:] DEBUG HikariConfig - autoCommit......................false
[stage:] DEBUG HikariConfig - catalog.........................none
[stage:] DEBUG HikariConfig - connectionInitSql...............none
[stage:] DEBUG HikariConfig - connectionTestQuery.............none
[stage:] DEBUG HikariConfig - connectionTimeout...............30000
[stage:] DEBUG HikariConfig - dataSource......................none
[stage:] DEBUG HikariConfig - dataSourceClassName.............none
[stage:] DEBUG HikariConfig - dataSourceJNDI..................none
[stage:] DEBUG HikariConfig - dataSourceProperties............{password=, =}
[stage:] DEBUG HikariConfig - driverClassName................."io.prestosql.jdbc.PrestoDriver"
[stage:] DEBUG HikariConfig - healthCheckProperties...........{}
[stage:] DEBUG HikariConfig - healthCheckRegistry.............none
[stage:] DEBUG HikariConfig - idleTimeout.....................600000
[stage:] DEBUG HikariConfig - initializationFailTimeout.......1
[stage:] DEBUG HikariConfig - isolateInternalQueries..........false
[stage:] DEBUG HikariConfig - jdbcUrl.........................jdbc:presto://172.22.200.26:8090/hive/default
[stage:] DEBUG HikariConfig - leakDetectionThreshold..........0
[stage:] DEBUG HikariConfig - maxLifetime.....................1800000
[stage:] DEBUG HikariConfig - maximumPoolSize.................1
[stage:] DEBUG HikariConfig - metricRegistry..................none
[stage:] DEBUG HikariConfig - metricsTrackerFactory...........none
[stage:] DEBUG HikariConfig - minimumIdle.....................1
[stage:] DEBUG HikariConfig - password........................
[stage:] DEBUG HikariConfig - poolName........................"HikariPool-175"
[stage:] DEBUG HikariConfig - readOnly........................true
[stage:] DEBUG HikariConfig - registerMbeans..................false
[stage:] DEBUG HikariConfig - scheduledExecutor...............none
[stage:] DEBUG HikariConfig - schema..........................none
[stage:] DEBUG HikariConfig - threadFactory...................internal
[stage:] DEBUG HikariConfig - transactionIsolation............default
[stage:] DEBUG HikariConfig - username........................"hdfs"
[stage:] DEBUG HikariConfig - validationTimeout...............5000
[stage:] INFO HikariDataSource - HikariPool-175 - Starting...
[stage:] DEBUG PoolBase - HikariPool-175 - Failed to create/setup connection: Unrecognized connection property ''

Above are all the configurations in SDC 。i don't know why it throws :Unrecognized connection property '' ERROR. when config the same items for idea, it works

[metadaddy]

Feel free to engage further via the StreamSets community - https://streamsets.com/community - this really isn't an issue with the tutorials.