Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I cannot connect to a hive table using jdbc query source

I am trying to read a table so I can merge it with another one. in the JDBC connection string I am getting the following error:

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException

Thanks in advance!

I cannot connect to a hive table using jdbc query source

I am trying to read a table so I can merge it with another one. in the JDBC connection string I am getting the following error:

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException

Thanks in advance!

I cannot connect to a hive table using jdbc query source

I am trying to read a table so I can merge it with another one. in the JDBC connection string I am getting the following error:

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException

Thanks in advance!

I cannot connect to a hive Hive table using jdbc JDBC query source

I am trying to read a table so I can merge it with another one. in the JDBC connection string I am getting the following error:

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException

org/apache/thrift/TException

Thanks in advance!

I cannot connect to a Hive table using JDBC query source

I am trying to read a table so I can merge it with another one. in the JDBC connection string I am getting the following error:

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException

Thanks in advance!This is the trace form sdc.log:

2017-10-02 11:00:48,368 [user:myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:webserver-798] INFO  StandaloneAndClusterRunnerProviderImpl - Pipeline execution mode is: STANDALONE 
2017-10-02 11:01:25,090 [user:myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:webserver-783] INFO  StandaloneRunner - Preparing to start pipeline 'HDTTESTUPDATE2pipelineid::0'
2017-10-02 11:01:25,112 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:runner-pool-2-thread-19] INFO  StandaloneRunner - Starting pipeline HDTTESTUPDATE2pipelineid 0
2017-10-02 11:01:25,144 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:runner-pool-2-thread-19] INFO  ProductionPipelineRunner - Adding error listeners0
2017-10-02 11:01:25,214 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  JdbcUtil - Registered JDBC drivers:
2017-10-02 11:01:25,220 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  JdbcUtil - Driver class org.apache.hive.jdbc.HiveDriver (version 2.1)
2017-10-02 11:01:25,229 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HikariDataSource - HikariPool-6 - is starting.
2017-10-02 11:01:25,237 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HikariPool - HikariPool-6 - is closing down.
2017-10-02 11:01:25,239 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] ERROR JdbcUtil - Failed to initialize connection pool: {}
com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:581)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:152)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:73)
    at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:630)
    at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.init(JdbcSource.java:211)
    at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:52)
    at com.streamsets.pipeline.configurablestage.DStage.init(DStage.java:40)
    at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:156)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:105)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:53)
    at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:299)
    at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:214)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:96)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:79)
    at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:646)
    at com.streamsets.datacollector.execution.runner.common.AsyncRunner.lambda$start$3(AsyncRunner.java:143)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/apache/thrift/TException
    at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
    at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496)
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:565)
    ... 22 more
Caused by: java.lang.ClassNotFoundException: org.apache.thrift.TException
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    ... 27 more
2017-10-02 11:01:25,239 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] ERROR JdbcSource - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:638)
    at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.init(JdbcSource.java:211)
    at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:52)
    at com.streamsets.pipeline.configurablestage.DStage.init(DStage.java:40)
    at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:156)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:105)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:53)
    at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:299)
    at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:214)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:96)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:79)
    at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:646)
    at com.streamsets.datacollector.execution.runner.common.AsyncRunner.lambda$start$3(AsyncRunner.java:143)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:581)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:152)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:73)
    at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:630)
    ... 19 more
Caused by: java.lang.NoClassDefFoundError: org/apache/thrift/TException
    at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
    at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496)
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:565)
    ... 22 more
Caused by: java.lang.ClassNotFoundException: org.apache.thrift.TException
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    ... 27 more
2017-10-02 11:01:25,421 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.exec.warehousedir does not exist
2017-10-02 11:01:25,447 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Authentication: Simple
2017-10-02 11:01:25,447 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Connection to Hive become stale, reconnecting.
2017-10-02 11:01:25,448 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Supplied authorities: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:25,448 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Resolved authority: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:25,449 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConnection - Will try to open client transport with JDBC Uri: jdbc:hive2://xxxxxxxxx:10481/default;user=xxxxxxx;password=xxxxxxxx
2017-10-02 11:01:27,036 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HdfsTargetConfigBean - Authentication Config: Using Simple
2017-10-02 11:01:27,061 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  RecordWriterManager - Created the following glob path for file recovery: */*/psft_gss/*/_tmp_HDT_TEST_FINAL*
2017-10-02 11:01:27,267 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.exec.warehousedir does not exist
2017-10-02 11:01:27,288 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Authentication: Simple
2017-10-02 11:01:27,288 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Connection to Hive become stale, reconnecting.
2017-10-02 11:01:27,289 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Supplied authorities: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,289 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Resolved authority: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,289 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConnection - Will try to open client transport with JDBC Uri: jdbc:hive2://xxxxxxxxx:xxxxxxx/default;user=xxxxxxxx;password=xxxxxxx
2017-10-02 11:01:27,668 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.exec.warehousedir does not exist
2017-10-02 11:01:27,668 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.support.sql11.reserved.keywords does not exist
2017-10-02 11:01:27,686 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Authentication: Simple
2017-10-02 11:01:27,687 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Connection to Hive become stale, reconnecting.
2017-10-02 11:01:27,697 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Supplied authorities: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,697 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Resolved authority: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,697 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConnection - Will try to open client transport with JDBC Uri: jdbc:hive2://xxxxxxxxx:xxxxxxx/default;user=xxxxxxxxx;password=xxxxxxxxxL
2017-10-02 11:01:27,998 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HdfsTargetConfigBean - Destroy
2017-10-02 11:01:28,041 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] ERROR ProductionPipelineRunnable - An exception occurred while running the pipeline, com.streamsets.datacollector.runner.PipelineRuntimeException: CONTAINER_0800 - Pipeline 'HDTTESTUPDATE2pipelineid' validation error : JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
com.streamsets.datacollector.runner.PipelineRuntimeException: CONTAINER_0800 - Pipeline 'HDTTESTUPDATE2pipelineid' validation error : JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:129)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:79)
    at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:646)
    at com.streamsets.datacollector.execution.runner.common.AsyncRunner.lambda$start$3(AsyncRunner.java:143)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

I cannot connect to a Hive table using JDBC query source

I am trying to read a table so I can merge it with another one. in the JDBC connection string I am getting the following error:

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException

This is the trace form sdc.log:

2017-10-02 11:00:48,368 [user:myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:webserver-798] INFO  StandaloneAndClusterRunnerProviderImpl - Pipeline execution mode is: STANDALONE 
2017-10-02 11:01:25,090 [user:myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:webserver-783] INFO  StandaloneRunner - Preparing to start pipeline 'HDTTESTUPDATE2pipelineid::0'
2017-10-02 11:01:25,112 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:runner-pool-2-thread-19] INFO  StandaloneRunner - Starting pipeline HDTTESTUPDATE2pipelineid 0
2017-10-02 11:01:25,144 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:runner-pool-2-thread-19] INFO  ProductionPipelineRunner - Adding error listeners0
2017-10-02 11:01:25,214 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  JdbcUtil - Registered JDBC drivers:
2017-10-02 11:01:25,220 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  JdbcUtil - Driver class org.apache.hive.jdbc.HiveDriver (version 2.1)
2017-10-02 11:01:25,229 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HikariDataSource - HikariPool-6 - is starting.
2017-10-02 11:01:25,237 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HikariPool - HikariPool-6 - is closing down.
2017-10-02 11:01:25,239 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] ERROR JdbcUtil - Failed to initialize connection pool: {}
com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:581)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:152)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:73)
    at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:630)
    at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.init(JdbcSource.java:211)
    at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:52)
    at com.streamsets.pipeline.configurablestage.DStage.init(DStage.java:40)
    at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:156)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:105)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:53)
    at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:299)
    at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:214)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:96)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:79)
    at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:646)
    at com.streamsets.datacollector.execution.runner.common.AsyncRunner.lambda$start$3(AsyncRunner.java:143)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/apache/thrift/TException
    at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
    at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496)
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:565)
    ... 22 more
Caused by: java.lang.ClassNotFoundException: org.apache.thrift.TException
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    ... 27 more
2017-10-02 11:01:25,239 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] ERROR JdbcSource - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:638)
    at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.init(JdbcSource.java:211)
    at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:52)
    at com.streamsets.pipeline.configurablestage.DStage.init(DStage.java:40)
    at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:156)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:105)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:53)
    at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:299)
    at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:214)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:96)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:79)
    at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:646)
    at com.streamsets.datacollector.execution.runner.common.AsyncRunner.lambda$start$3(AsyncRunner.java:143)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:581)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:152)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:73)
    at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:630)
    ... 19 more
Caused by: java.lang.NoClassDefFoundError: org/apache/thrift/TException
    at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
    at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496)
    at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:565)
    ... 22 more
Caused by: java.lang.ClassNotFoundException: org.apache.thrift.TException
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:360)
    at com.streamsets.pipeline.SDCClassLoader.loadClass(SDCClassLoader.java:323)
    ... 27 more
2017-10-02 11:01:25,421 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.exec.warehousedir does not exist
2017-10-02 11:01:25,447 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Authentication: Simple
2017-10-02 11:01:25,447 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Connection to Hive become stale, reconnecting.
2017-10-02 11:01:25,448 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Supplied authorities: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:25,448 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Resolved authority: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:25,449 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConnection - Will try to open client transport with JDBC Uri: jdbc:hive2://xxxxxxxxx:10481/default;user=xxxxxxx;password=xxxxxxxx
2017-10-02 11:01:27,036 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HdfsTargetConfigBean - Authentication Config: Using Simple
2017-10-02 11:01:27,061 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  RecordWriterManager - Created the following glob path for file recovery: */*/psft_gss/*/_tmp_HDT_TEST_FINAL*
2017-10-02 11:01:27,267 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.exec.warehousedir does not exist
2017-10-02 11:01:27,288 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Authentication: Simple
2017-10-02 11:01:27,288 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Connection to Hive become stale, reconnecting.
2017-10-02 11:01:27,289 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Supplied authorities: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,289 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Resolved authority: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,289 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConnection - Will try to open client transport with JDBC Uri: jdbc:hive2://xxxxxxxxx:xxxxxxx/default;user=xxxxxxxx;password=xxxxxxx
2017-10-02 11:01:27,668 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.exec.warehousedir does not exist
2017-10-02 11:01:27,668 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] WARN  HiveConf - HiveConf of name hive.support.sql11.reserved.keywords does not exist
2017-10-02 11:01:27,686 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Authentication: Simple
2017-10-02 11:01:27,687 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConfigBean - Connection to Hive become stale, reconnecting.
2017-10-02 11:01:27,697 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Supplied authorities: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,697 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  Utils - Resolved authority: xxxxxxxxxx:xxxxxx
2017-10-02 11:01:27,697 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HiveConnection - Will try to open client transport with JDBC Uri: jdbc:hive2://xxxxxxxxx:xxxxxxx/default;user=xxxxxxxxx;password=xxxxxxxxxL
2017-10-02 11:01:27,998 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:0] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] INFO  HdfsTargetConfigBean - Destroy
2017-10-02 11:01:28,041 [user:*myuserid] [pipeline:HDT_TEST_UPDATE2/HDTTESTUPDATE2pipelineid] [runner:] [thread:ProductionPipelineRunnable-HDTTESTUPDATE2pipelineid-HDT_TEST_UPDATE2] ERROR ProductionPipelineRunnable - An exception occurred while running the pipeline, com.streamsets.datacollector.runner.PipelineRuntimeException: CONTAINER_0800 - Pipeline 'HDTTESTUPDATE2pipelineid' validation error : JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
com.streamsets.datacollector.runner.PipelineRuntimeException: CONTAINER_0800 - Pipeline 'HDTTESTUPDATE2pipelineid' validation error : JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: org/apache/thrift/TException
    at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:129)
    at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:79)
    at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:646)
    at com.streamsets.datacollector.execution.runner.common.AsyncRunner.lambda$start$3(AsyncRunner.java:143)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:233)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)