question Re: Is there a way to get results of hive command instead of getting job id in WebHCat? in Archives of Support Questions (Read Only)

Is there a way to get results of hive command instead of getting job id in WebHCat?

aervits — Thu, 05 Nov 2015 01:33:51 GMT

If I execute the following

curl -s -d execute="select+*+from+sample_08;" \

-d statusdir="outputofthejob" \

'http://localhost:50111/templeton/v1/hive?user.name=root'

I get a job id of the job in JSON format, is there a way to get actual result of the query rather than job id?

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

pardeep_kumar — Thu, 05 Nov 2015 01:36:32 GMT

@Artem Ervits So you mean, you want output of query i.e. "Select * from emp where dept_id=10"?

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

nsabharwal — Thu, 05 Nov 2015 01:43:21 GMT

@Artem Ervits

The actual result is going under "outputofthejob" on HDFS. I don't see any options to get exact data using that command or any other option. Limit information in the doc.

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

nsabharwal — Thu, 05 Nov 2015 01:46:33 GMT

@Pardeep I believe, Yes

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

aervits — Thu, 05 Nov 2015 01:51:12 GMT

yes, I want to see the results instead of looking in outputofthejob/part-m-0000. I didn't see any options in WebHCat wiki.

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

nsabharwal — Thu, 05 Nov 2015 02:03:28 GMT

@Artem Ervits Time to open an enhancement request 😉

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

aervits — Thu, 05 Nov 2015 02:21:39 GMT

https://issues.apache.org/jira/browse/HIVE-12339

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

deepesh1 — Thu, 05 Nov 2015 02:55:01 GMT

No, WebHCat does not provide any options to get the query output as part of the response object. Either you use the WebHDFS api to inspect the contents of the output directory or if your concern is the transport mode, you could JDBC connection to the HiveServer2 configured in HTTP mode.

Re: Is there a way to get results of hive command instead of getting job id in WebHCat?

asreekumar — Tue, 10 Nov 2015 01:37:56 GMT

Performing a hdfs cat on stdout file inside the outputofthejob directory will give the output from hive.

hdfs dfs -cat <location-of-outputofthejob>/stdout