GET Hadoop SQL operation of QueryIO server will fetch given Hadoop SQL query from the database.
GET/queryio/hadoopsql/
HTTP/1.1 Host: QueryIO.com authorization:<Token>
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 |
The following request will fetch Hadoop SQL according to provided id.
GET /queryio/hadoopsql/ HTTP/1.1 Host: QueryIO authorization: iffo6l9hel2hfmbj2384joljgh9mqga58gb9if9593ucli9ke5s2e3854shhcmmm hadoopsql-id : Query1
<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>