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.