phoenix.jpgI have made the changes according to below website:-
https://community.hortonworks.com/questions/1652/how-can-i-query-hbase-from-hive.html
https://phoenix.apache.org/hive_storage_handler.html
After settings all the jars and added the property in
custom hive-env
export HIVE_AUX_JARS_PATH=/usr/hdp/current/hive-webhcat/share/hcatalog/hive-hcatalog-core.jar
custome hive-site export HIVE_AUX_JARS_PATH="${HIVE_AUX_JARS_PATH}:/usr/hdp/current/phoenix-client/phoenix-hive.jar"
WebHcat Server is not started no error message showing in logs:
log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.
log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.DailyRollingFileAppender.
Exception in thread "main" java.lang.IllegalStateException: Variable substitution depth too large: 20 "${HIVE_AUX_JARS_PATH}:/usr/hdp/current/phoenix-client/phoenix-hive.jar"
at org.apache.hadoop.conf.Configuration.substituteVars(Configuration.java:967)
at org.apache.hadoop.conf.Configuration.get(Configuration.java:987)
at org.apache.hadoop.hive.conf.HiveConfUtil.dumpConfig(HiveConfUtil.java:77)
at org.apache.hadoop.hive.conf.HiveConfUtil.dumpConfig(HiveConfUtil.java:59)
at org.apache.hive.hcatalog.templeton.AppConfig.dumpEnvironent(AppConfig.java:256)
at org.apache.hive.hcatalog.templeton.AppConfig.init(AppConfig.java:198)
at org.apache.hive.hcatalog.templeton.AppConfig.<init>(AppConfig.java:173)
at org.apache.hive.hcatalog.templeton.Main.loadConfig(Main.java:97)
at org.apache.hive.hcatalog.templeton.Main.init(Main.java:81)
at org.apache.hive.hcatalog.templeton.Main.<init>(Main.java:76)
at org.apache.hive.hcatalog.templeton.Main.main(Main.java:289)
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)
