Created 05-04-2017 07:54 PM
hello guys,
so I was trying to connect hive metadata through webhcat. I started webhcat_server successfully.I first test the link:
http://vn1:50111/templeton/v1/status
It returns :
{"status":"ok","version":"v1"}
which is a success.Then I try
http://vn1:50111/templeton/v1/ddl/database?user.name=hive
It gives me error
{"statement":"show databases like '*';","error":"unable to show databases for: *","exec": {"stdout":"", "stderr":"which: no /opt/lib/hadoop/bin/hadoop in ((null)) dirname: missing operand Try 'dirname --help' for more information. /opt/lib/hadoop/bin/hadoop: line 26: /opt/lib/hive-hcatalog/sbin/../libexec/hadoop-config.sh: No such file or directory /opt/lib/hadoop/bin/hadoop: line 144: exec: : not found", "exitcode":127 } }
I did quite a research on Internet. some people run into the same problem but no one has an answer.
I can successfully start hcatalog server & webhcat server.
I notice that there is no hadoop-config.sh under /hive-hcatalog/libexec...But should that be under /hadoop/libexec? Is there something wrong with script maybe?
Created 05-05-2017 05:09 PM
Can you try the following?
http://vn1:50111/templeton/v1/ddl/database/?user.name=hive
Created 05-05-2017 05:20 PM
Yes sir that won't work either. But I move on to this question because I found out that in higher version Vertica (8+) you can directly create external table mapping partitions on HDFS. So no Hcatalog needed anymore. Thanks!
Created 05-06-2017 05:59 PM
Not sure which HDP/Hive version you are working with, looks like its looking for the binary in this location /opt/lib/hadoop/bin/hadoop , can you tell us why its looking for the binaries there ?
If you are using ambari, then can you ensure that hive-env contains all the binaries and also, in ambari, templeton.hadoop contains the location of binaries, can you check where its pointing ?