[DRILL-4214] JDBC connectivity through Cloudera

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.0.0
• Component/s: Client - JDBC
• Labels: newbie test

Environment

Drill 1.0.0 Cloudera cdh 5.4.0

• Assignee: Unassigned
• Reporter: Jinith Joseph
• Created: 20/Dec/15 12:59
• Updated: 29/Dec/15 07:58
• Resolved: 29/Dec/15 07:58

Description

Drill JDBC Java API works fine when executing from IDE Development and the cosole. But when attempting to run using Job Designer in Cloudera, its giving error as below :

Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.JavaMain], main() threw exception, java.lang.NoSuchMethodError: com.google.common.base.Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J
org.apache.oozie.action.hadoop.JavaMainException: java.lang.NoSuchMethodError: com.google.common.base.Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J
at org.apache.oozie.action.hadoop.JavaMain.run(JavaMain.java:60)
at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:46)
at org.apache.oozie.action.hadoop.JavaMain.main(JavaMain.java:38)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:228)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
at org.apache.hadoop.mapred.LocalContainerLauncher$EventHandler.runSubtask(LocalContainerLauncher.java:370)
at org.apache.hadoop.mapred.LocalContainerLauncher$EventHandler.runTask(LocalContainerLauncher.java:295)
at org.apache.hadoop.mapred.LocalContainerLauncher$EventHandler.access$200(LocalContainerLauncher.java:181)
at org.apache.hadoop.mapred.LocalContainerLauncher$EventHandler$1.run(LocalContainerLauncher.java:224)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoSuchMethodError: com.google.common.base.Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J
at org.apache.drill.common.util.PathScanner.scanForImplementations(PathScanner.java:98)
at org.apache.drill.common.util.PathScanner.scanForImplementationsArr(PathScanner.java:77)
at org.apache.drill.common.logical.data.LogicalOperatorBase.getSubTypes(LogicalOperatorBase.java:88)
at org.apache.drill.common.config.DrillConfig.<init>(DrillConfig.java:77)
at org.apache.drill.common.config.DrillConfig.create(DrillConfig.java:169)
at org.apache.drill.common.config.DrillConfig.create(DrillConfig.java:142)
at org.apache.drill.common.config.DrillConfig.create(DrillConfig.java:97)
at org.apache.drill.exec.metrics.DrillMetrics.<clinit>(DrillMetrics.java:40)
at io.netty.buffer.PooledByteBufAllocatorL.<init>(PooledByteBufAllocatorL.java:45)
at io.netty.buffer.PooledByteBufAllocatorL.<clinit>(PooledByteBufAllocatorL.java:43)
at org.apache.drill.exec.memory.TopLevelAllocator.<init>(TopLevelAllocator.java:48)
at org.apache.drill.exec.memory.TopLevelAllocator.<init>(TopLevelAllocator.java:74)
at org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:120)
at org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection.<init>(DrillJdbc41Factory.java:97)
at org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:60)
at org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:46)
at org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:54)
at net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.alshaya.drill.Drill_Jdbc_Test.GetLastModifiedDate(Drill_Jdbc_Test.java:29)
at com.alshaya.drill.Drill_Jdbc_Test.main(Drill_Jdbc_Test.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.oozie.action.hadoop.JavaMain.run(JavaMain.java:57)
... 19 more