GET Hadoop SQL

Description

GET Hadoop SQL operation of QueryIO server will fetch given Hadoop SQL query from the database.

Requests

Syntax

• GET /queryio/hadoopsql/ HTTP/1.1
  Host: QueryIO.com
  authorization: <Token>

• authorization: Token for authorization.

Request Headers

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

Header Name	Description	Type	Default	Required
hadoopsql-id	Id for Hadoop SQL query to fetch	String	None	Yes

Examples

Sample Request

The following request will fetch Hadoop SQL according to provided id.

• GET /queryio/hadoopsql/ HTTP/1.1
  Host: QueryIO
  authorization: iffo6l9hel2hfmbj2384joljgh9mqga58gb9if9593ucli9ke5s2e3854shhcmmm
  hadoopsql-id : Query1
  

Sample Response

• <xml version="1.0" encoding="UTF-8">
  <HadoopSQLQueries>
  	<HadoopSQLList>![CDATA[
  			{
  			    "queries": [
  			        {
  			            "id": "Query1", 
  			            "description": "", 
  			            "properties": {
  			                "sqlQuery": "SELECT *  FROM TAGS_NAMENODE1", 
  			                "chartDetail": {
  			                	"chartPreferences": {}
  			                 }, 
  			                "selectedHaving": { },
  			                "selectedOrderBy": [ ], 
  			                "selectedTable": [
  			                    "TAGS_NAMENODE1"
  			                ], 
  			                "queryHeader": {
  			                    "header": {
  			                        "title": ""
  			                    }
  			                }, 
  			                "selectedWhere": { }, 
  			                "queryFooter": {
  			                    "footer": {
  			                        "title": ""
  			                    }
  			                }, 
  			                "groupHeader": { }, 
  			                "queryDesc": "", 
  			                "groupFooter": { }, 
  			                "colDetail": { }, 
  			                "colHeaderDetail": { }, 
  			                "selectedGroupBy": [ ], 
  			                "selectedColumn": {
  			                    "*": { }
  			                },
  			                "persistResults": true, 
  						    "colspanDetail": { }, 
  			                "queryId": "myquery"
  			            }
  			        }
  			    ]
  			}
  			]]
  	<HadoopSQLList>
  </HadoopSQLQueries>