I want to run a query against a hive api which returns results. right now webhcat return whether job was success or not and stores results on hdfs or local disk. Any API which return query results back to client?
WebHCat, as you probably know, is a web interface that can be used for Hive commands as a REST API (not GUI). With WebHCat, applications can make HTTP requests to access the Hive metastore (HCatalog DDL) or to create and queue Hive queries and commands, Pig jobs, and MapReduce or YARN jobs (either standard or streaming). WebHCat was formerly named Templeton. See these documents for more information:
The WebHCat link provide you with the sample of curl command to get the result. That is to work with NON-Kerberized env.
If you are Kerberized, the way to get this working is:
$ curl -u s:s --negotiate -d execute="select+*+from+table;" -d statusDir="/tmp/hive" 'http://hostname:50111/templeton/v1/hive'