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