jdbc url connection error in hive metadata

asked 2019-06-26 03:16:36 -0600

song gravatar image

updated 2019-06-27 00:00:50 -0600

metadaddy gravatar image

I try to save the data in oracle into hive(cloudera hadoop)

Authorized to make sdc accessible to hive database. I confirmed that the create table query from hue using "sdc" was performed.

However, the database connection error continues to occur in the JDBC URL of "hive metadata1".

What is unique is that a "default database connection error" has occurred even though i specified the database name(mydb).

I do not know which setting is fault.

image description

2019-06-26 17:00:08,556 [TEST] - jdbc_to_hdfs_song/HHIWeDAS20BayInfoOracletoHadoopsyj8e0d31ad-a268-4841-98ff-65f0f708c47e   ERROR   Error Connecting to Hive Database with URL jdbc:hive2://aa.aaa.co.kr:10000/mydb HiveConfigBean  *admin  0   preview-pool-1-thread-3
com.streamsets.pipeline.api.StageException: HIVE_22 - Cannot make connection with default hive database starting with URL: jdbc:hive2://aa.aaa.co.kr:10000/mydb. Reason:null
    at com.streamsets.pipeline.stage.lib.hive.HiveMetastoreUtil.getHiveConnection(HiveMetastoreUtil.java:854)
    at com.streamsets.pipeline.stage.lib.hive.HiveConfigBean.getHiveConnection(HiveConfigBean.java:170)
    at com.streamsets.pipeline.stage.lib.hive.HiveConfigBean.init(HiveConfigBean.java:289)
    at com.streamsets.pipeline.stage.processor.hive.HiveMetadataProcessor.init(HiveMetadataProcessor.java:187)
    at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:48)
    at com.streamsets.pipeline.api.base.configurablestage.DStage.init(DStage.java:36)
    at com.streamsets.datacollector.runner.StageRuntime.lambda$init$0(StageRuntime.java:211)
    at com.streamsets.datacollector.util.LambdaUtil.withClassLoaderInternal(LambdaUtil.java:148)
    at com.streamsets.datacollector.util.LambdaUtil.withClassLoader(LambdaUtil.java:44)
    at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:209)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:106)
    at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:43)
    at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:403)
    at com.streamsets.datacollector.runner.Pipeline.lambda$init$0(Pipeline.java:392)
    at com.streamsets.datacollector.runner.PipeRunner.acceptConsumer(PipeRunner.java:221)
    at com.streamsets.datacollector.runner.PipeRunner.forEach(PipeRunner.java:175)
    at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:389)
    at com.streamsets.datacollector.runner.preview.PreviewPipeline.run(PreviewPipeline.java:49)
    at com.streamsets.datacollector.execution.preview.sync.SyncPreviewer.start(SyncPreviewer.java:233)
    at com.streamsets.datacollector.execution.preview.async.AsyncPreviewer.lambda$start$0(AsyncPreviewer.java:101)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226)
    at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:33)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226)
    at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:33)
    at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222)
    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 com.streamsets.datacollector.metrics.MetricSafeScheduledExecutorService$MetricsTask.run(MetricSafeScheduledExecutorService.java:100)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
edit retag flag offensive close merge delete