PUT Hadoop SQL

Description

PUT Hadoop SQL operation of QueryIO server will add given Hadoop SQL query to the database or perform and update operation if it already exists.

Requests

Syntax

Request Headers

The PUT Hadoop SQL operation in QueryIO Server uses following request header:

Header Name Description Type Default Required
hadoopsql-properties

Hadoop SQL properties JSON

String None Yes

Hadoop SQL JSON

KeyValueTypeRequired
namenode ID of the NameNode on which data will be queried.
Example: "namenode": "NameNode1",
String Yes
queryId Unique identifier for the Hadoop SQL.
Example: "queryId": "New Query 7"
String Yes
queryDesc (Optional)Brief description for the query. Value can be empty or null.
Example: "queryDesc": "Query to get all sales list",
String Yes
sqlQuery Standard SQL query.
Example: "sqlQuery": "SELECT * FROM HDFS_METADATA ",
String Yes
chartDetail (Optional) JSON object of the all the charts to be generated. JSONObject Yes
colHeaderDetail (Optional) Column header Formatting details. JSONObject for each coloumn header. JSONObject Yes
colDetail (Optional) Formatting for each selected columns. JSONObject for each coloumn. JSONObject Yes
dbName Database name in which queried table is present. String Yes
queryHeader (Optional) Header details for query result. JSONObject which contains header title and formatting details. JSONObject Yes
queryFooter (Optional) Footer details for query result. JSONObject which contains footer title and formatting details. JSONObject Yes
groupHeader (Optional) Header description for each group. JSONObject Yes
groupFooter (Optional) Footer description for each group. JSONObject Yes
selectedTable List of tables to be queried.
Example: ["HDFS_METADATA", "METADATA_PDF"]
JSONArray Yes
selectedWhere (Optional) Condition to be specified in query. JSONObject Yes
setHighFidelityOutput To get high or low quality output. Boolean Yes
setLimitResultRows Limit the number of rows to be included in result. Boolean Yes
limitResultRowsValue Specify number of rows to be included in result. String Yes
executionId Specifies the current execution ID. String Yes
username Current logged in user. String Yes
resultTableName Name of the result table which gets created while running an adhoc query. String Yes
persistResults Specifies whether user wants to create result table while running an adhoc query. Boolean Yes
selectedColumn (Optional)List of selected columns. JSONOBject Yes
selectedGroupBy Group columns with aggregate functions.
Example: [ "USERGROUP", "FILEPATH" ]
JSONArray Yes
selectedHaving (Optional)Condition to be specified on GROUP BY clause. JSONObject Yes
selectedOrderBy Sort the result-set by a specified column. JSONOBject Yes

chartDetail JSON Value

Format for chartDetail JSON:

KeyValueTypeRequired
titleJson Properties of the title of the chart.

KeyValue
color Color of the title.
text-align Text alignment of the title.
insets Offsets required from bottom, left, right, top
background Background color of the title.
font-size Font size of the title.
font-style Font style of the title as Lighter, Normal, Bold or Bolder
value Value of the title.
font-family Font family of the title.
outline Contains properties such as style, visibility, color and width of the outline.
anchor Decides the gravity of the title as top, middle or bottom.


JSONObject Yes
outLineJson Properties of the outline of the chart.

KeyValue
style Style of the outline as solid, dashed or dotted.
visible Visibility of the outline as true or false.
color Color code of the outline in hex.
width Width of the outline as 1, 2, 3 or 4.


JSONObject Yes
xAxisJson Properties of the x axis of the chart.

KeyValue
position Position of the x axis values as above or below.
visible Visibility of the x axis values as true or false.
text-align Text alignment of the x axis values.
font-style Font style of the x axis values as Lighter, Normal, Bold or Bolder.
gridline Contains properties such as style, visibility, color and width of the gridlines of the x axis values.
outline Contains properties such as style, visibility, color and width of the outline of x axis values.
color Color of the x axis values.
shadow Color of the shadow of the x axis values.
background Background color of the x axis values.
font-size Font size of the x axis values.
insets Offsets required from bottom, left, right, top
value Value of the x axis.
font-family Font family of the x axis values.


JSONObject Yes
leaderLineJson Properties of the leader lines of the chart (Applicable only for Pie charts).

KeyValue
style Style of the leader lines as fixed length or stretch to slide.
visible Visibility of the leader lines as true or false.
color Color code of the leader lines in hex.
lineStyle Style of the leader lines as solid, dashed or dotted.
width Width of the leader lines as 1, 2, 3 or 4.
lineLength Length of the leader lines as 1, 2, 3, 4 and so on.


JSONObject Yes
commonJson Common properties of the chart.

KeyValue
topColors Top 5 colors of the chart configurable by the users.
emptyChartMessage Message that appears when no chart is present.
background Background of the whole chart.
floorBackground Background color of the floor (Applicable only for 3D charts).
wallBackground Background color of the wall (Applicable only for 3D charts).
clientBackground Background color of the client area which contains just the chart area without any additional space such as X or Y legend.
plotBackground Background color of the plot area which contains the area around the client area but without the title space.


JSONObject Yes
lineChartJson Properties exclusively for the line chart.

KeyValue
curveColor Color of the curve so formed.
showCurve Whether or not to show the curve along with the lines passing through the points.


JSONObject Yes
legendJson Properties of the legend of the chart.

KeyValue
Stretch Orientation of the legend area as horizontal or vertical.
position Position of the legend as above, below, right or left.
visible Visibility of the legend as true or false.
title-font-color Color of the legend values.
insets Offsets required from bottom, left, right, top
background Background color of the legend values.
visibleTitle Whether or not to show the title of the legend area.
outline Contains properties such as style, visibility, color and width of the outline of legend area.
title-font-family Font family of the legend values.
title-font-style Font style of the legend values as Lighter, Normal, Bold or Bolder.
anchor Decides the gravity of the title as top, middle or bottom.
title-font-size Font size of the title values.


JSONObject Yes
labelJson Properties of the labels of the chart which forms the part of the actual data.

KeyValue
position Position of the labels as outside or inside.
visible Visibility of the labels as true or false.
text-align Text alignment of the labels as left, center, right or justify.
font-style Font style of the labels as Lighter, Normal, Bold or Bolder.
outline Contains properties such as style, visibility, color and width of the outline of labels.
suffix Text to be appended at the end of the label values.
values Value of the labels as Actual value or percentage values.
shadow Color of the shadow of the labels.
insets Offsets required from bottom, left, right, top
background Background color of the labels.
font-size Font size of the labels.
prefix Text to be appended at the beginning of the label values.
font-color Color of the labels.
font-family Font family of the labels.
separator Separates the actual value from the percentage values using it.


JSONObject Yes
yAxisJson Properties of the y axis of the chart.

KeyValue
position Position of the y axis values as above or below.
visible Visibility of the y axis values as true or false.
text-align Text alignment of the y axis values.
font-style Font style of the y axis values as Lighter, Normal, Bold or Bolder.
gridline Contains properties such as style, visibility, color and width of the gridlines of the y axis values.
outline Contains properties such as style, visibility, color and width of the outline of y axis values.
color Color of the y axis values.
shadow Color of the shadow of the y axis values.
background Background color of the y axis values.
font-size Font size of the y axis values.
insets Offsets required from bottom, left, right, top
value Value of the y axis.
font-family Font family of the y axis values.


JSONObject Yes
insetsJson Properties of the insets of the chart.

KeyValue
bottom Padding given at the bottom.
left Padding given at the left.
right Padding given at the right.
top Padding given at the top.


JSONObject Yes

See Sample JSON.

KeyValueTypeRequired
position Position of chart.
Valid Values: "queryHeader", "groupHeader", "groupFooter"
String Yes
yseriesArray List of Y-axis columns.It can be more than one selected column.
Example: [ "COUNT(USERGROUP)", "FILEPATH", "LEN" ]
JSONArray Yes
yseries Aggregate function on "yseriesArray" columns.
Key: Value = <ColumnName>:<Function>
  • <ColumnName> : Name of the selected column.
  • <Function> : Aggregate function to be executed on column name.
    Valid Value: "#", "Count","DistinctCount". '#' represents no aggregate function.
JSONObject
ylegend Y axis description String Yes
align center String
width Width of chart in pixels.
Example: "300"
String Yes
type Type of chart.
Valid Values: "line", "bar", "pie"
String Yes
chartPreferences Chart formatting details defined for each chart similar to the common chartPreferences explained above. JSONObject Yes
title Title of chart String Yes
dimension Dimensional representation of chart. 0 represents 2D, 1 represents 2D with depth, 2 represents 3D.
Valid Values: "0", "1", "2".
String Yes
height Height of chart in pixels.
Example: "300"
String Yes
colSpan Set position of chart according to column. String Yes
rowPosition Set position of chart according to row. String Yes
xlegend X-axis descritpion. String Yes
xseries X-axis column. It can be only one selected column. String Yes

colHeaderDetail JSON Value

Specify formatting for all column headers. Format for colHeaderDetail JSON:

See Sample JSON.

KeyValueType
title Title of the column header to be displayed. String
color Font color in RGB format.
Example: #000000
String
text-align Position of text.
Valid Values: "left", "center", "right", "justify"
String
font-size Font size in "pt" or "px".
Example: "12px"
String
width Width for the column in "pt" or "px"
Example: "100px".
String
font-style Font Styles.
Valid Values: "normal", "italic", "oblique"
String
background-color Specify background color in RGB format.
Example: "#cccccc"
String
font-family The font-family property specifies the font for an element.
Valid Values: "Times New Roman", "Verdana", "Courier"
String
font-weight The font-weight CSS property specifies the weight or boldness of the font.
Valid Values: "normal", "bold", "bolder", "lighter"
String

colDetail JSON Value

Specify formatting for all column data. Format for colDetail JSON:

See Sample JSON.

KeyValueType
color Font color in RGB format.
Example: #000000
String
text-align Position of text.
Valid Values: "left", "center", "right", "justify"
String
font-size Font size in "pt" or "px".
Example: "12px"
String
width Width for the column in "pt" or "px"
Example: "100px".
String
font-style Font Styles.
Valid Values: "normal", "italic", "oblique"
String
background-color Specify background color in RGB format.
Example: "#cccccc"
String
font-family The font-family property specifies the font for an element.
Valid Values: "Times New Roman", "Verdana", "Courier"
String
font-weight The font-weight CSS property specifies the weight or boldness of the font.
Valid Values: "normal", "bold", "bolder", "lighter"
String
format JSON object with extra formatting details. JSONOBject

Format JSONObject

Specify extra formatting for all column data.

See Sample JSON.

KeyValueType
category Valid Values for column type
  • string: "Unformatted", "uppercase", "lowercase", "Custom"
  • numeric: "Unformatted", "General Number", "Currency", "Fixed", "Percentage", "Scientific", "Custom"

String
pattern Details according to column type. JSONObject
type Column data type. Only for column data type as "string".
Valid Value: String
String
sample A sample data to show current formatting preview. String

pattern JSONObject

Specify extra formatting according to column data type.

See Sample JSON.

KeyValueString Column TypeNumeric Column Type
decimalPlace Number of decimal places to be displayed. -1 Any number greater that 0(zero).
commaSeparator Comma separator for larger numbers. "false" "true" or "false"
roundingMode Rules for round up number. "-" "Half_Up" , "Half_Down", "Half_Even", "Up", "Down", "Ceiling", "Floor", "Unnecessary"
symbolNumber Symbol to be displayed along with number. "-" "No Symbol", "$", "DKK"
negativeNumber define how to display negative numbers. "-" "useHyphen", "useBracket"
symbolPosition Specify to place symbol before or after number. "-" "before", "after"
useSymbolSpace To provide space between symbol and number or not. "false" "true" or "false"

queryHeader JSON Value

Specify formatting for query header. Format for queryHeader JSON:

See Sample JSON.

KeyValueType
title Title to be displayed in report or query header. String
color Font color in RGB format.
Example: #000000
String
text-align Position of text.
Valid Values: "left", "center", "right", "justify"
String
font-size Font size in "pt" or "px".
Example: "12px"
String
width Width for the column in "pt" or "px"
Example: "100px".
String
font-style Font Styles.
Valid Values: "normal", "italic", "oblique"
String
background-color Specify background color in RGB format.
Example: "#cccccc"
String
font-family The font-family property specifies the font for an element.
Valid Values: "Times New Roman", "Verdana", "Courier"
String
font-weight The font-weight CSS property specifies the weight or boldness of the font.
Valid Values: "normal", "bold", "bolder", "lighter"
String

queryFooter JSON Value

Specify formatting for query footer. Format for queryFooter JSON:

See Sample JSON.

KeyValueType
title Title to be displayed at end of report or query. String
color Font color in RGB format.
Example: #000000
String
text-align Position of text.
Valid Values: "left", "center", "right", "justify"
String
font-size Font size in "pt" or "px".
Example: "12px"
String
width Width for the column in "pt" or "px"
Example: "100px".
String
font-style Font Styles.
Valid Values: "normal", "italic", "oblique"
String
background-color Specify background color in RGB format.
Example: "#cccccc"
String
font-family The font-family property specifies the font for an element.
Valid Values: "Times New Roman", "Verdana", "Courier"
String
font-weight The font-weight CSS property specifies the weight or boldness of the font.
Valid Values: "normal", "bold", "bolder", "lighter"
String

groupHeader JSON Value

Specify formatting for all group headers. Format for groupHeader JSON:

See Sample JSON.

KeyValueType
style Formatting for group header. JSONObject
prefix Text to be displayed before column name String
suffix Text to be displayed after column name String

style JSONObject (groupHeader and groupFooter)

KeyValueType
color Font color in RGB format.
Example: #000000
String
text-align Position of text.
Valid Values: "left", "center", "right", "justify"
String
font-size Font size in "pt" or "px".
Example: "12px"
String
width Width for the column in "pt" or "px"
Example: "100px".
String
font-style Font Styles.
Valid Values: "normal", "italic", "oblique"
String
background-color Specify background color in RGB format.
Example: "#cccccc"
String
font-family The font-family property specifies the font for an element.
Valid Values: "Times New Roman", "Verdana", "Courier"
String
font-weight The font-weight CSS property specifies the weight or boldness of the font.
Valid Values: "normal", "bold", "bolder", "lighter"
String
format JSON object with extra formatting details. JSONOBject

groupFooter JSON Value

Specify formatting for all group footer. Format for groupFooter JSON:

See Sample JSON.

KeyValueType
style Formatting for group header. JSONObject
prefix Text to be displayed before column name String
suffix Text to be displayed after column name String
function Aggregate function to be applied on column
Valid Values: "COUNT", "DistinctCount"
String

selectedWhere JSON Value

Specify "where" condition for the columns provided in "sqlQuery".

See Sample JSON.

KeyValueType
roperator Relational operator used in the condition
Valid Values: "=", "!=", ">", "<", "<=", ">=", IN , NOT IN, IS NULL , NOT IS NULL, LIKE, NOT LIKE, BETWEEN, NOT BETWEEN
String
value Value to be provided in condition String
loperator Logical operator to join several conditions. String
"selectedWhere": {
            "USERGROUP": {
                  "roperator": " = ", 
                  "value": "queryio", 
                  "loperator": "AND"
            }, 
            "LEN": {
                  "roperator": " > ", 
                  "value": "10", 
                  "loperator": ""
            }
      }, 			
			

selectedColumn JSON Value

Specify selected columns which are included in sql query (if query is not in the format : SELECT * FROM <table>).
Format for JSONObject is

See Sample JSON.

KeyValueType
function Aggregate function to be applied on column.
Valid Values: "COUNT", "DistinctCount"
String

selectedHaving JSON Value

Specify condition for the columns provided in "GROUP BY" clause.

See Sample JSON.

KeyValueType
roperator Relational operator used in the condition
Valid Values: "=", "!=", ">", "<", "<=", ">=", IN , NOT IN, IS NULL , NOT IS NULL, LIKE, NOT LIKE, BETWEEN, NOT BETWEEN
String
value Value to be provided in condition String
loperator Logical operator to join several conditions. String
"selectedHaving": {
            "USERGROUP": {
                  "roperator": " LIKE ", 
                  "value": "query%", 
                  "loperator": "AND"
            }, 
            "LEN": {
                  "roperator": " > ", 
                  "value": "10", 
                  "loperator": ""
            }
      }, 			
			

selectedOrderBy JSON Value

See Sample JSON.

KeyValueType
<columnName> Specify sorting of Selected column name.
Valid Values: "ASC", "DESC"
Example: "selectedOrderBy": { "USERGROUP": "ASC" },
String

Sample Hadoop SQL properties JSON

{
      "resultTableName": "RESULT_8_HDFS_METADATA", 
      "namenode": "NameNode1", 
      "sqlQuery": "SELECT USERGROUP, FILEPATH, COUNT(LEN)  FROM HDFS_METADATA WHERE USERGROUP =   'queryio' AND LEN >   10   GROUP BY USERGROUP,FILEPATH  ORDER BY USERGROUP ASC ",
      "dbName": "QueryDB", 
      "chartDetail": {
            "chart0": {
                  "position": "groupHeader", 
                  "yseriesArray": [
                        "FILEPATH"
                  ], 
                  "yseries": {
                        "FILEPATH": "#"
                  }, 
                  "ylegend": "vcb", 
                  "align": "center", 
                  "width": "300", 
                  "type": "line",
                  "chartPreferences": {},
                  "title": "chart", 
                  "dimension": "0", 
                  "height": "300", 
                  "colSpan": "1", 
                  "rowPosition": "1", 
                  "xlegend": "cvb", 
                  "xseries": "USERGROUP"
            }, 
            "chart1": {
                  "position": "queryHeader", 
                  "yseriesArray": [
                        "Count(FILEPATH)"
                  ], 
                  "yseries": {
                        "FILEPATH": "Count"
                  }, 
                  "ylegend": "aa", 
                  "align": "center", 
                  "width": "300", 
                  "type": "pie",
                  "chartPreferences": {},
                  "title": "2", 
                  "dimension": "0", 
                  "height": "300", 
                  "colSpan": "1", 
                  "rowPosition": "1", 
                  "xlegend": "aa", 
                  "xseries": "USERGROUP"
            },
            "chartPreferences": {
	            "titleJson": {}, 
	            "outLineJson": {}, 
	            "xAxisJson": {}, 
	            "leaderLineJson": {}, 
	            "commonJson": {}, 
	            "lineChartJson": {}, 
	            "legendJson": {}, 
	            "labelJson": {}, 
	            "yAxisJson": {}, 
	            "insetsJson": {}
	        }
      },
      "selectedOrderBy": {
            "USERGROUP": "ASC"
      }, 
      "selectedTable": [
            "HDFS_METADATA"
      ], 
      "queryHeader": {
            "header": {
                  "title": "header", 
                  "color": "ffffff", 
                  "text-align": "center", 
                  "font-size": "16px", 
                  "width": "100%", 
                  "font-style": "italic", 
                  "background-color": "005fbf", 
                  "font-family": "Arial", 
                  "font-weight": "bold", 
                  "format": { }
            }
      }, 
      "selectedWhere": {
            "USERGROUP": {
                  "roperator": " = ", 
                  "value": "queryio", 
                  "loperator": "AND"
            }, 
            "LEN": {
                  "roperator": " > ", 
                  "value": "10", 
                  "loperator": ""
            }
      },
      "selectedHaving": {
            "USERGROUP": {
                  "roperator": " LIKE ", 
                  "value": "query%", 
                  "loperator": "AND"
            }, 
            "LEN": {
                  "roperator": " > ", 
                  "value": "10", 
                  "loperator": ""
            }
      },
      "username": "admin", 
      "executionId": 12, 
      "limitResultRowsValue": "5", 
      "setHighFidelityOutput": true, 
      "queryFooter": {
            "footer": {
                  "title": "footer", 
                  "color": "#7c7c7c", 
                  "text-align": "left", 
                  "font-size": "16px", 
                  "width": "100%", 
                  "font-style": "normal", 
                  "background-color": "", 
                  "font-family": "Arial", 
                  "font-weight": "normal", 
                  "format": { }
            }
      }, 
      "groupHeader": {
            "USERGROUP": {
                  "style": {
                        "color": "ffffff", 
                        "text-align": "center", 
                        "font-size": "10px", 
                        "width": "pt", 
                        "font-style": "italic", 
                        "background-color": "00bf5f", 
                        "font-family": "Times New Roman", 
                        "font-weight": "bold", 
                        "format": {
                              "category": "uppercase", 
                              "pattern": {
                                    "decimalPlace": "-1", 
                                    "commaSeparator": false, 
                                    "roundingMode": "-", 
                                    "symbolNumber": "-", 
                                    "negativeNumber": "-", 
                                    "symbolPosition": "-", 
                                    "useSymbolSpace": false
                              }, 
                              "type": "string", 
                              "sample": "USERGROUP"
                        }
                  }, 
                  "prefix": "prefix", 
                  "suffix": "suffix", 
                  "function": ""
            }
      }, 
      "setLimitResultRows": true, 
      "groupFooter": {
            "FILEPATH": {
                  "style": {
                        "color": "", 
                        "text-align": "left", 
                        "font-size": "10pt", 
                        "width": "pt", 
                        "font-style": "normal", 
                        "background-color": "", 
                        "font-family": "Times New Roman", 
                        "font-weight": "normal", 
                        "format": {
                              "category": "Unformatted", 
                              "pattern": {
                                    "decimalPlace": "-1", 
                                    "commaSeparator": false, 
                                    "roundingMode": "-", 
                                    "symbolNumber": "-", 
                                    "negativeNumber": "-", 
                                    "symbolPosition": "-", 
                                    "useSymbolSpace": false
                              }, 
                              "type": "string", 
                              "sample": "FILEPATH"
                        }
                  }, 
                  "prefix": "", 
                  "suffix": "", 
                  "function": ""
            }
      }, 
      "queryDesc": "aasassxz", 
      "colDetail": {
            "USERGROUP": {
                  "color": "#000000", 
                  "text-align": "left", 
                  "font-size": "10px", 
                  "width": "180px", 
                  "font-style": "normal", 
                  "background-color": "", 
                  "font-family": "Arial", 
                  "font-weight": "normal", 
                  "format": {
                        "category": "uppercase", 
                        "pattern": {
                              "decimalPlace": "-1", 
                              "commaSeparator": false, 
                              "roundingMode": "-", 
                              "symbolNumber": "-", 
                              "negativeNumber": "-", 
                              "symbolPosition": "-", 
                              "useSymbolSpace": false
                        }, 
                        "type": "string", 
                        "sample": "USERGROUP"
                  }
            }, 
            "FILEPATH": {
                  "color": "#000000", 
                  "text-align": "center", 
                  "font-size": "12px", 
                  "width": "180px", 
                  "font-style": "italic", 
                  "background-color": "aaffaa", 
                  "font-family": "Times New Roman", 
                  "font-weight": "bolder", 
                  "format": {
                        "category": "Unformatted", 
                        "pattern": {
                              "decimalPlace": "-1", 
                              "commaSeparator": false, 
                              "roundingMode": "-", 
                              "symbolNumber": "-", 
                              "negativeNumber": "-", 
                              "symbolPosition": "-", 
                              "useSymbolSpace": false
                        }, 
                        "type": "string", 
                        "sample": "FILEPATH"
                  }
            }, 
            "COUNT(LEN)": {
                  "format": {
                        "category": "Currency", 
                        "pattern": {
                              "decimalPlace": "3", 
                              "commaSeparator": false, 
                              "roundingMode": "Half_Up", 
                              "symbolNumber": "$", 
                              "negativeNumber": "useBracket", 
                              "symbolPosition": "before", 
                              "useSymbolSpace": false
                        }, 
                        "sample": "$123456123456.000"
                  }
            }, 
            "checkBookFlag": true
      }, 
      "colHeaderDetail": {
            "USERGROUP": {
                  "title": "USERGROUP", 
                  "color": "#000000", 
                  "text-align": "center", 
                  "font-size": "12px", 
                  "width": "100px", 
                  "font-style": "normal", 
                  "background-color": "#cccccc", 
                  "font-family": "Verdana", 
                  "font-weight": "normal", 
                  "format": { }
            }, 
            "FILEPATH": {
                  "title": "FILEPATH", 
                  "color": "#000000", 
                  "text-align": "center", 
                  "font-size": "12px", 
                  "width": "180px", 
                  "font-style": "normal", 
                  "background-color": "#cccccc", 
                  "font-family": "Arial", 
                  "font-weight": "normal", 
                  "format": { }
            }
      }, 
      "selectedGroupBy": [
            "USERGROUP", 
            "FILEPATH"
      ], 
      "selectedColumn": {
            "USERGROUP": {
                  "function": ""
            }, 
            "FILEPATH": {
                  "function": ""
            }, 
            "LEN": {
                  "function": "COUNT"
            }
      }, 
      "queryId": "New Query 7"
      "persistResults": true, 
      "colspanDetail": {
        "groupFooter": 1, 
        "queryHeader": 1, 
        "groupHeader": 1, 
        "queryFooter": 1
      }, 
}

Examples

Sample Request

The following request will add a new Hadoop SQL query.

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.