POST Hadoop SQL

Description

POST Hadoop SQL operation of QueryIO server will execute given Hadoop SQL query.

Requests

Syntax

Request Headers

The POST Hadoop SQL operation in QueryIO Server uses following request headers:

Header Name Description Type Default Required
sqlquery

Standard SQL Query on BigData

String None Yes (Not to be used with "queryid" header)
queryid

Id of the Hadoop SQL query to be executed. Specify the report format in the hadoopsql-report-format header in which result will be generated.

String None Yes (Not to be used with "sqlquery" header)
hadoopsql-report-format

Report format: PDF/HTML/XLS
It should not be used with "sqlquery" header.

String None Yes (To be used only with "queryid" header)
startindex

Start index

String None No
maxresults

Max results

String None No
timeout

Query timeout in ms

String None No

Examples

Sample Request

The following request will execute a Hadoop SQL query and returns a JSON response.

Sample Response



Copyright 2017 QueryIO Corporation. All Rights Reserved.

QueryIO, "Big Data Intelligence" and the QueryIO Logo are trademarks of QueryIO Corporation. Apache, Hadoop and HDFS are trademarks of The Apache Software Foundation.