You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Vimal Sharma <vi...@hortonworks.com> on 2017/04/10 10:58:29 UTC
Hive WebHcat Usage
Hi Lefty,
I was using the documentation (https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Hive) created by you to execute Hive queries using WebHcat REST API.
Below is the CURL call which I am using to execute the query:
curl -s -d execute="desc + tpcds_bin_partitioned_orc_100 + . + catalog_page" -d statusdir=“output" 'ctr-e129-1487033772569-69920-01-000002.hwx.site:50111/templeton/v1/hive?user.name=root’
I get the JOB ID in the request result
{"id":"job_1491300039844_0137”}
I tried other simple queries(like select * from tableName) as well. But unlike the example described in the documentation, I am not getting any results in the HDFS directory
hadoop fs –cat output/stdout
hadoop fs –cat output/stderr
doesn’t contain anything.
Do you have any comments on what might be the issue.
Thanks in advance
Vimal
Re: Hive WebHcat Usage
Posted by Vimal Sharma <vi...@hortonworks.com>.
Hi Lefty,
Never mind. The M-R jobs were stuck due to a Tez configuration issue.
I am now able to see the job output in the specified directory.
Thanks
Vimal
From: default <vi...@hortonworks.com>>
Date: Monday, April 10, 2017 at 4:28 PM
To: Lefty Leverenz <le...@hortonworks.com>>
Cc: "dev@hive.apache.org<ma...@hive.apache.org>" <de...@hive.apache.org>>
Subject: Hive WebHcat Usage
Hi Lefty,
I was using the documentation (https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Hive) created by you to execute Hive queries using WebHcat REST API.
Below is the CURL call which I am using to execute the query:
curl -s -d execute="desc + tpcds_bin_partitioned_orc_100 + . + catalog_page" -d statusdir=“output" 'ctr-e129-1487033772569-69920-01-000002.hwx.site:50111/templeton/v1/hive?user.name=root’
I get the JOB ID in the request result
{"id":"job_1491300039844_0137”}
I tried other simple queries(like select * from tableName) as well. But unlike the example described in the documentation, I am not getting any results in the HDFS directory
hadoop fs –cat output/stdout
hadoop fs –cat output/stderr
doesn’t contain anything.
Do you have any comments on what might be the issue.
Thanks in advance
Vimal