Support Questions
Find answers, ask questions, and share your expertise

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

Explorer

output of debug

16/02/24 18:52:43 [IPC Client (473524237) connection to nn1.hortonwork.local/192.168.2.156:8050 from hdfs]: DEBUG ipc.Client: IPC Client (473524237) connection to nn1.hortonwork.local/192.168.2.156:8050 from hdfs got value #119 16/02/24 18:52:43 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getApplicationReport took 1ms

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

Explorer

java.io.FileNotFoundException: /etc/security/clientKeys/all.jks (No such file or directory)

....i found below exception while debuging

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

Explorer

Hello Bhushan - I see the same issue - Have you Found any solution to this problem ..? Do you have any ideas on how to fix that

Cannot load customized ssl related configuration. Fallback to system-generic settings java.io.FileNotFoundException: /etc/security/clientKeys/all.jks (No such file or directory)

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

Explorer

Hi Ashnee - Can you share the Fix the for the Same Issue - I see the same problem when i'm trying to run hive.

Cannot load customized ssl related configuration. Fallback to system-generic settings java.io.FileNotFoundException: /etc/security/clientKeys/all.jks (No such file or directory)

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

New Contributor

Set ssl.client.truststore.location to the correct location in your HDFS configuration within ambari.

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

Explorer

What is the fix for this issue ? I am facing the same issue, I am new to the Hive. Do we need to crete the SSL certificate ?

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

Super Guru

@Bhushan Mahajan

By looking at your problem it looks like your cluster resources are exhausted and its unable to launch the TEZ container.

People - Please ignore below error while checking debug output

java.io.FileNotFoundException: /etc/security/clientKeys/all.jks (No such file or directory)

You can try launching hive shell using below command, however if you don't have free resources then your complex query will not run although you can run select * query.

hive --hiveconf hive.execution.engine=mr

Hope this information helps!

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

Explorer

Yes, from some other link I came to know that cluster resources are exhausted. I Killed all those jobs and after that its working fine.

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

New Contributor

@Kuldeep Kulkarni

./hive --hiveconf hive.execution.engine=mr which: no hbase in (/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.121-0.b13.el7_3.x86_64/jre/bin:/home/hadoop/hadoop-2.7.3/sbin:/home/hadoop/ha doop-2.7.3/bin:/home/hadoop/.local/bin:/home/hadoop/bin) SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/hadoop/hadoop-2.7.3/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/hadoop/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Logging initialized using configuration in jar:file:/home/hadoop/hadoop-2.7.3/hive/lib/hive-common-2.1.1.jar!/hive-log4j2.properties Async: true Exception in thread "main" java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D at org.apache.hadoop.fs.Path.initialize(Path.java:205) at org.apache.hadoop.fs.Path.<init>(Path.java:171) at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:644) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:563) at org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:531) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:705) 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.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D at java.net.URI.checkPath(URI.java:1823) at java.net.URI.<init>(URI.java:745) at org.apache.hadoop.fs.Path.initialize(Path.java:202)

Re: I am not getting hive shell prompt , it is usual problem and did not solve yet

New Contributor

-----------

@Kuldeep K

Exception in thread "main" java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D at org.apache.hadoop.fs.Path.initialize(Path.java:205) at org.apache.hadoop.fs.Path.<init>(Path.java:171) at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:644) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:563) at org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:531) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:705) 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.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D at java.net.URI.checkPath(URI.java:1823) at java.net.URI.<init>(URI.java:745) at org.apache.hadoop.fs.Path.initialize(Path.java:202)