hive rest api : cannot query tables ?

[#1]

Unable to query hive tables... was able to retrive the schema of tables, couldn't get the data of the table?

[#2]

@Krishna Srinivas

See this https://cwiki.apache.org/confluence/display/Hive/HiveWebInterface

What command are you running?

[#3]

@Neeraj Sabharwal We have configured webhcat and is working fine to retrieve the schema http://<IP Address>:50111/templeton/v1/version/hive?user.name=hive result : {"module":"hive","version":"1.2.1.2.3.4.0-3485"} but while running a query to retrieve the data of a hive table , its throwing {

error: null;

}

[#4]

@Krishna Srinivas Can you try this? https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference+Hive#WebHCatReferenceHive-CurlCom...

and please take a look on this link ...It has lot of information on query

https://cwiki.apache.org/confluence/display/Hive/WebHCat+Reference

[#5]

@Krishna Srinivas Please see this...it's in my vm

Job is still running.

[hive@sandbox ~]$ curl -s -d execute="select+*+from+nstest;” \

> -d statusdir=“nstest.output" \

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

{"id":"job_1454999065989_0008"}[hive@sandbox ~]$

[#6]

@Krishna Srinivas See this article "Published it based on your question"

https://community.hortonworks.com/articles/15992/hivewebinterface-example.html

[#7]

@Neeraj Sabharwal Thanq for the detailed description and yes the jobs are getting initiated the same way, but am afraid couldn't get it from the google rest api client. How can we execute a query from rest api client, whenever am initiating its throwing

error:null

[#8]

@Krishna Srinivas Do you have connectivity to cluster from google rest api? If connectivity is there then you are all set and if not then its bigger problem.

[#9]

@Neeraj Sabharwal hiveexecutequery.png Please find the document, I am able to do the query but can't see the results from the API. My interest is an application using this api to pull the data

[#10]

@Krishna Srinivas Your job got submitted and now , you need to access output from HDFS. Not possible to display data on screen yet...WIP