RE: Storage Handler for Apache Hive

[Stepan Migunov]

Thank you, Artem!

Does it mean that Phoenix-Hive integration works with Hadoop >= 2.7 only?





*From:* Artem Ervits [mailto:artemerv...@gmail.com]
*Sent:* Tuesday, March 27, 2018 12:10 PM
*To:* user@phoenix.apache.org
*Subject:* Re: Storage Handler for Apache Hive



Stepan, you're using version of Hadoop where StopWatch class is not defined



https://github.com/apache/hadoop/tree/release-2.6.4-RC0/hadoop-common-project/hadoop-common/src/main/java/org/apache/hadoop/util/StopWatch.java



If you at least go to Hadoop 2.7, this error will disappear



https://github.com/apache/hadoop/blob/release-2.7.1/hadoop-common-project/hadoop-common/src/main/java/org/apache/hadoop/util/StopWatch.java





On Tue, Mar 27, 2018, 4:47 AM Stepan Migunov <
stepan.migu...@firstlinesoftware.com> wrote:

Hi,

Phoenix 4.12.0-HBase-1.1, hadoop 2.6.4, hive 2.1.1

I have setup Hive for using external Phoenix tables. But after
phoenix-hive.jar was included into the hive-site.xml, the hive console give
exception on some operations (e.g. show databases or query with order by
clause):

Exception in thread "main" java.lang.NoClassDefFoundError:
org/apache/hadoop/util/StopWatch
        at
org.apache.hadoop.mapred.FileInputFormat.getSplits(FileInputFormat.java:314)
        at
org.apache.hadoop.hive.ql.exec.FetchOperator.getNextSplits(FetchOperator.java:372)
        at
org.apache.hadoop.hive.ql.exec.FetchOperator.getRecordReader(FetchOperator.java:304)
        at
org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:459)
        at
org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:428)
        at
org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:146)
        at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2098)
        at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:252)
        at
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:183)
        at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:399)
        at
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:776)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:714)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:641)
        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:221)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: java.lang.ClassNotFoundException:
org.apache.hadoop.util.StopWatch
        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)
        ... 19 more

Any suggestions are welcome.