[pgollakoti@cluster-hive-nl8l ~]$ hive --hiveconf SET hive.druid.broker.address.default=localhost /usr/hdp/2.6.2.0-205/hive/bin/hive.distro: line 106: [: too many arguments log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender. Logging initialized using configuration in file:/etc/hive/2.6.2.0-205/0/hive-log4j.properties hive> CREATE EXTERNAL TABLE druid_table_1 STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ("druid.datasource"="wikiticker"); Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.hive.ql.session.SessionState$LogHelper.(Lorg/slf4j/Logger;)V at org.apache.hadoop.hive.druid.DruidStorageHandler.(DruidStorageHandler.java:93) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.apache.hadoop.hive.ql.parse.ParseUtils.ensureClassExists(ParseUtils.java:230) at org.apache.hadoop.hive.ql.parse.StorageFormat.fillStorageFormat(StorageFormat.java:64) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeCreateTable(SemanticAnalyzer.java:11168) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:10352) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10437) at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:218) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:237) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:465) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:321) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1221) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1262) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1158) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1148) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:217) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:169) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:380) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:740) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:685) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) [pgollakoti@cluster-hive-nl8l ~]$ ll /usr/hdp/current/hive-client/lib/*hive* -rw-r--r--. 1 root root 120428 Aug 26 09:54 /usr/hdp/current/hive-client/lib/hive-accumulo-handler-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 46 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-accumulo-handler.jar -> hive-accumulo-handler-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 49725 Aug 26 09:53 /usr/hdp/current/hive-client/lib/hive-ant-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 33 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-ant.jar -> hive-ant-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 148377 Aug 26 09:55 /usr/hdp/current/hive-client/lib/hive-beeline-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 37 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-beeline.jar -> hive-beeline-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 40146 Aug 26 09:55 /usr/hdp/current/hive-client/lib/hive-cli-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 33 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-cli.jar -> hive-cli-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 359939 Aug 26 09:52 /usr/hdp/current/hive-client/lib/hive-common-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 36 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-common.jar -> hive-common-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 122558 Aug 26 09:55 /usr/hdp/current/hive-client/lib/hive-contrib-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 37 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-contrib.jar -> hive-contrib-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 36961450 Sep 7 13:39 /usr/hdp/current/hive-client/lib/hive-druid-handler-2.3.0.jar -rw-r--r--. 1 root root 22006904 Aug 26 09:54 /usr/hdp/current/hive-client/lib/hive-exec-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 34 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-exec.jar -> hive-exec-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 54747 Apr 28 2012 /usr/hdp/current/hive-client/lib/hive-hbase-handler-0.9.0.jar -rw-r--r--. 1 root root 54747 Apr 28 2012 /usr/hdp/current/hive-client/lib/hive-hbase-handler-0.9.0.jar.1 -rw-r--r--. 1 root root 119491 Aug 26 09:55 /usr/hdp/current/hive-client/lib/hive-hbase-handler-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 43 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-hbase-handler.jar -> hive-hbase-handler-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 29161 Aug 26 09:56 /usr/hdp/current/hive-client/lib/hive-hwi-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 33 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-hwi.jar -> hive-hwi-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 111628 Aug 26 09:54 /usr/hdp/current/hive-client/lib/hive-jdbc-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 34 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-jdbc.jar -> hive-jdbc-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 43010 Oct 19 2011 /usr/hdp/current/hive-client/lib/hive-json-serde.jar -rw-r--r--. 1 root root 40852 May 11 2013 /usr/hdp/current/hive-client/lib/hive-json-serde.jar.zip -rw-r--r--. 1 root root 6276641 Aug 26 09:53 /usr/hdp/current/hive-client/lib/hive-metastore-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 6920621 Sep 8 09:34 /usr/hdp/current/hive-client/lib/hive-metastore-2.0.0.jar -rw-r--r--. 1 root root 8119135 Sep 8 09:49 /usr/hdp/current/hive-client/lib/hive-metastore-2.3.0.jar lrwxrwxrwx. 1 root root 39 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-metastore.jar -> hive-metastore-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 922483 Aug 26 09:53 /usr/hdp/current/hive-client/lib/hive-serde-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 35 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-serde.jar -> hive-serde-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 1999980 Aug 26 09:54 /usr/hdp/current/hive-client/lib/hive-service-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 37 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-service.jar -> hive-service-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 34328 Aug 26 09:52 /usr/hdp/current/hive-client/lib/hive-shims-0.20S-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 65652 Aug 26 09:52 /usr/hdp/current/hive-client/lib/hive-shims-0.23-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 10459 Aug 26 09:52 /usr/hdp/current/hive-client/lib/hive-shims-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 114512 Aug 26 09:52 /usr/hdp/current/hive-client/lib/hive-shims-common-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 42 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-shims-common.jar -> hive-shims-common-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 41 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-shims.jar -> hive-shims-0.20S-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 13605 Aug 26 09:52 /usr/hdp/current/hive-client/lib/hive-shims-scheduler-1.2.1000.2.6.2.0-205.jar lrwxrwxrwx. 1 root root 45 Sep 4 10:50 /usr/hdp/current/hive-client/lib/hive-shims-scheduler.jar -> hive-shims-scheduler-1.2.1000.2.6.2.0-205.jar -rw-r--r--. 1 root root 18493 Aug 26 10:47 /usr/hdp/current/hive-client/lib/ranger-hive-plugin-shim-0.7.0.2.6.2.0-205.jar /usr/hdp/current/hive-client/lib/hive-json-serde: total 24 -rw-r--r--. 1 root root 5358 Sep 7 06:38 build.xml drwxr-xr-x. 2 root root 4096 Sep 7 06:38 lib -rw-r--r--. 1 root root 106 Sep 7 06:38 README.txt drwxr-xr-x. 3 root root 4096 Sep 7 06:38 src drwxr-xr-x. 3 root root 4096 Sep 7 06:38 test /usr/hdp/current/hive-client/lib/ranger-hive-plugin-impl: total 11432 -rw-r--r--. 1 root root 8632395 Aug 26 10:47 eclipselink-2.5.2.jar -rw-r--r--. 1 root root 190432 Aug 26 10:47 gson-2.2.4.jar -rw-r--r--. 1 root root 732765 Aug 26 10:47 httpclient-4.5.1.jar -rw-r--r--. 1 root root 326724 Aug 26 10:47 httpcore-4.4.4.jar -rw-r--r--. 1 root root 41029 Aug 26 10:47 httpmime-4.5.2.jar -rw-r--r--. 1 root root 162126 Aug 26 10:47 javax.persistence-2.1.0.jar -rw-r--r--. 1 root root 26720 Aug 26 10:47 noggit-0.6.jar -rw-r--r--. 1 root root 85076 Aug 26 10:47 ranger-hive-plugin-0.7.0.2.6.2.0-205.jar -rw-r--r--. 1 root root 193996 Aug 26 10:47 ranger-plugins-audit-0.7.0.2.6.2.0-205.jar -rw-r--r--. 1 root root 587434 Aug 26 10:47 ranger-plugins-common-0.7.0.2.6.2.0-205.jar -rw-r--r--. 1 root root 12069 Aug 26 10:47 ranger-plugins-cred-0.7.0.2.6.2.0-205.jar -rw-r--r--. 1 root root 692590 Aug 26 10:47 solr-solrj-5.5.1.jar