Webhcat show database error missing operand

[#1]

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?

[#2]

Can you try the following?

http://vn1:50111/templeton/v1/ddl/database/?user.name=hive

[#3]

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!

[#4]

@Jesse zhao

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 ?