http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/core-modules/index.html ---------------------------------------------------------------------- diff --git a/docs/core-modules/index.html b/docs/core-modules/index.html index 4e1415f..964976e 100644 --- a/docs/core-modules/index.html +++ b/docs/core-modules/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/create-table-as-ctas/index.html ---------------------------------------------------------------------- diff --git a/docs/create-table-as-ctas/index.html b/docs/create-table-as-ctas/index.html index 2e0a830..a8c4861 100644 --- a/docs/create-table-as-ctas/index.html +++ b/docs/create-table-as-ctas/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/create-view/index.html ---------------------------------------------------------------------- diff --git a/docs/create-view/index.html b/docs/create-view/index.html index a7b27a3..8de3bab 100644 --- a/docs/create-view/index.html +++ b/docs/create-view/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/custom-function-interfaces/index.html ---------------------------------------------------------------------- diff --git a/docs/custom-function-interfaces/index.html b/docs/custom-function-interfaces/index.html index b1db2be..95f9110 100644 --- a/docs/custom-function-interfaces/index.html +++ b/docs/custom-function-interfaces/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/data-sources-and-file-formats-introduction/index.html ---------------------------------------------------------------------- diff --git a/docs/data-sources-and-file-formats-introduction/index.html b/docs/data-sources-and-file-formats-introduction/index.html index 2f0e9af..cffa01e 100644 --- a/docs/data-sources-and-file-formats-introduction/index.html +++ b/docs/data-sources-and-file-formats-introduction/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/data-sources-and-file-formats/index.html ---------------------------------------------------------------------- diff --git a/docs/data-sources-and-file-formats/index.html b/docs/data-sources-and-file-formats/index.html index 6791901..626f7c0 100644 --- a/docs/data-sources-and-file-formats/index.html +++ b/docs/data-sources-and-file-formats/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/data-type-conversion/index.html ---------------------------------------------------------------------- diff --git a/docs/data-type-conversion/index.html b/docs/data-type-conversion/index.html index ae73dcc..83b8839 100644 --- a/docs/data-type-conversion/index.html +++ b/docs/data-type-conversion/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/data-types/index.html ---------------------------------------------------------------------- diff --git a/docs/data-types/index.html b/docs/data-types/index.html index f6a0ef5..995b55c 100644 --- a/docs/data-types/index.html +++ b/docs/data-types/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/date-time-and-timestamp/index.html ---------------------------------------------------------------------- diff --git a/docs/date-time-and-timestamp/index.html b/docs/date-time-and-timestamp/index.html index a22ad17..74223f1 100644 --- a/docs/date-time-and-timestamp/index.html +++ b/docs/date-time-and-timestamp/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/date-time-functions-and-arithmetic/index.html ---------------------------------------------------------------------- diff --git a/docs/date-time-functions-and-arithmetic/index.html b/docs/date-time-functions-and-arithmetic/index.html index 1f771c5..1e84d22 100644 --- a/docs/date-time-functions-and-arithmetic/index.html +++ b/docs/date-time-functions-and-arithmetic/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> @@ -1083,21 +1085,27 @@ <p>Returns the sum of a date/time and a number of days/hours, or of a date/time and date/time interval.</p> <h3 id="date_add-syntax">DATE_ADD Syntax</h3> -<div class="highlight"><pre><code class="language-text" data-lang="text">DATE_ADD(keyword literal_date, integer) +<div class="highlight"><pre><code class="language-text" data-lang="text">DATE_ADD(keyword literal, integer) DATE_ADD(keyword literal, interval expr) DATE_ADD(column, integer) + +DATE_ADD(column, interval expr) </code></pre></div> <p><em>keyword</em> is the word date, time, or timestamp.<br> <em>literal</em> is a date, time, or timestamp literal. For example, a date in yyyy-mm-dd format enclosed in single quotation marks.<br> <em>integer</em> is a number of days to add to the date/time.<br> <em>column</em> is date, time, or timestamp data in a data source column.<br> <em>interval</em> is the keyword interval.<br> -<em>expr</em> is an interval expression. </p> +<em>expr</em> is an interval expression, such as the name of a data source column containing interval data. </p> <h3 id="date_add-examples">DATE_ADD Examples</h3> +<p>The following examples show how to use the syntax variations.</p> + +<p><strong><code>DATE_ADD(keyword literal, integer)</code> Syntax Example</strong></p> + <p>Add two days to today's date May 15, 2015.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(date '2015-05-15', 2) FROM sys.version; +------------+ @@ -1107,7 +1115,9 @@ DATE_ADD(column, integer) +------------+ 1 row selected (0.07 seconds) </code></pre></div> -<p>Using the example data from the <a href="/docs/data-type-conversion/#casting-intervals">"Casting Intervals"</a> section, add intervals from the <code>intervals.json</code> file to a literal timestamp using an interval expression. Create an interval expression that casts the interval data in the intervals.json file to a timestamp.</p> +<p><strong><code>DATE_ADD(keyword literal, interval expr)</code> Syntax Example</strong></p> + +<p>Using the example data from the <a href="/docs/data-type-conversion/#casting-intervals">"Casting Intervals"</a> section, add intervals from the <code>intervals.json</code> file to a literal timestamp. Create an interval expression that casts the INTERVALDAY_col column, which contains P1D, P2D, and P3D, to a timestamp.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(timestamp '2015-04-15 22:55:55', CAST(INTERVALDAY_col as interval second)) FROM dfs.`/Users/drilluser/apache-drill-1.0.0/intervals.json`; +------------------------+ | EXPR$0 | @@ -1118,9 +1128,25 @@ DATE_ADD(column, integer) +------------------------+ 3 rows selected (0.105 seconds) </code></pre></div> -<p>The query returns the sum of the timestamp plus 1, 2, and 3 days becuase the INTERVALDAY_col contains P1D, P2D, and P3D, </p> +<p>The query output is the sum of the timestamp and 1, 2, and 3 days corresponding to P1D, P2D, and P3D.</p> + +<p><strong>DATE_ADD(column, integer) Syntax Example</strong></p> + +<p>Add two days to the value in the birth_date column.</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(CAST(birth_date AS date), 2) FROM cp.`employee.json` LIMIT 1; ++-------------+ +| EXPR$0 | ++-------------+ +| 1961-08-28 | ++-------------+ +1 row selected (0.209 seconds) +</code></pre></div> +<p><strong><code>DATE_ADD(column, interval expr)</code> Syntax Example</strong></p> + +<p>Add a 10 hour interval to the hire dates of employees listed in the <code>employee.json</code> file, which Drill includes in the installation.</p> -<p>The Drill installation includes the <code>employee.json</code> file that has records of employee hire dates:</p> +<ol> +<li><p>Take a look at the employee data:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM cp.`employee.json` LIMIT 1; +--------------+---------------+-------------+------------+--------------+-----------------+-----------+----------------+-------------+------------------------+----------+----------------+------------------+-----------------+---------+--------------------+ | employee_id | full_name | first_name | last_name | position_id | position_title | store_id | department_id | birth_date | hire_date | salary | supervisor_id | education_level | marital_status | gender | management_role | @@ -1128,8 +1154,8 @@ DATE_ADD(column, integer) | 1 | Sheri Nowmer | Sheri | Nowmer | 1 | President | 0 | 1 | 1961-08-26 | 1994-12-01 00:00:00.0 | 80000.0 | 0 | Graduate Degree | S | F | Senior Management | +--------------+---------------+-------------+------------+--------------+-----------------+-----------+----------------+-------------+------------------------+----------+----------------+------------------+-----------------+---------+--------------------+ 1 row selected (0.137 seconds) -</code></pre></div> -<p>Look at the hire_dates for the employee 578 and 761 in <code>employee.json</code>.</p> +</code></pre></div></li> +<li><p>Look at the hire_dates for the employee 578 and 761 in <code>employee.json</code>.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT hire_date FROM cp.`employee.json` where employee_id IN( '578','761'); +------------------------+ | hire_date | @@ -1138,8 +1164,8 @@ DATE_ADD(column, integer) | 1998-01-01 00:00:00.0 | +------------------------+ 2 rows selected (0.135 seconds) -</code></pre></div> -<p>Cast the hire_dates of the employees 578 and 761 to a timestamp, and add 10 hours to the hire_date timestamp. Because Drill reads data from JSON as VARCHAR, you need to cast the hire_date to the TIMESTAMP type. </p> +</code></pre></div></li> +<li><p>Cast the hire_dates of the employees 578 and 761 to a timestamp, and add 10 hours to the hire_date timestamp. Because Drill reads data from JSON as VARCHAR, you need to cast the hire_date to the TIMESTAMP type. </p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(CAST(hire_date AS TIMESTAMP), interval '10' hour) FROM cp.`employee.json` where employee_id IN( '578','761'); +------------------------+ | EXPR$0 | @@ -1148,7 +1174,11 @@ DATE_ADD(column, integer) | 1998-01-01 10:00:00.0 | +------------------------+ 2 rows selected (0.172 seconds) -</code></pre></div> +</code></pre></div></li> +</ol> + +<p><strong><code>DATE_ADD(keyword literal, integer)</code> Syntax Example</strong></p> + <p>Add 1 year and 1 month to the timestamp 2015-04-15 22:55:55.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(timestamp '2015-04-15 22:55:55', interval '1-2' year to month) FROM sys.version; +------------------------+ @@ -1217,27 +1247,23 @@ SELECT DATE_PART('hour', '23:14:30.076') FROM sys.version; DATE_SUB(keyword literal, interval expr) DATE_ADD(column, integer) + +DATE_SUB(column, interval expr) </code></pre></div> <p><em>keyword</em> is the word date, time, or timestamp.<br> <em>literal</em> is a date, time, or timestamp literal. For example, a date in yyyy-mm-dd format enclosed in single quotation marks.<br> -<em>integer</em> is a number of days to subtract from the date, time, or timestamp.<br> +<em>integer</em> is a number of days to subtract from the date, time, or timestamp. <em>column</em> is date, time, or timestamp data in the data source.<br> <em>interval</em> is the keyword interval.<br> -<em>expr</em> is an interval expression.</p> +<em>expr</em> is an interval expression, such as the name of a data source column containing interval data.</p> <h3 id="date_sub-examples">DATE_SUB Examples</h3> -<p>Cast the hire_dates of the employees 578 and 761 to a timestamp, and add 10 hours to the hire_date timestamp. Because Drill reads data from JSON as VARCHAR, you need to cast the hire_date to the TIMESTAMP type. </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(CAST(hire_date AS TIMESTAMP), interval '10' hour) FROM cp.`employee.json` WHERE employee_id IN( '578','761'); -+------------------------+ -| EXPR$0 | -+------------------------+ -| 1995-12-31 14:00:00.0 | -| 1997-12-31 14:00:00.0 | -+------------------------+ -2 rows selected (0.161 seconds) -</code></pre></div> -<p>Subtract two days to today's date May 15, 2015.</p> +<p>The following examples show how to apply the syntax variations.</p> + +<p><strong><code>DATE_SUB(keyword literal, integer)</code> Syntax Example</strong></p> + +<p>Subtract two days from today's date May 15, 2015.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(date '2015-05-15', 2) FROM sys.version; +------------+ | EXPR$0 | @@ -1255,6 +1281,8 @@ DATE_ADD(column, integer) +------------+ 1 row selected (0.088 seconds) </code></pre></div> +<p><strong><code>DATE_SUB(keyword literal, interval expr)</code> Syntax Example</strong></p> + <p>Subtract 10 hours from the timestamp 2015-04-15 22:55:55.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(timestamp '2015-04-15 22:55:55', interval '10' hour) FROM sys.version; +------------------------+ @@ -1291,6 +1319,27 @@ DATE_ADD(column, integer) +---------------+ 1 row selected (0.095 seconds) </code></pre></div> +<p><strong><code>DATE_SUB(column, integer)</code> Syntax Example</strong></p> +<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(CAST(birth_date AS date), 2) FROM cp.`employee.json` LIMIT 1; ++-------------+ +| EXPR$0 | ++-------------+ +| 1961-08-24 | ++-------------+ +1 row selected (0.158 seconds) +</code></pre></div> +<p><strong><code>DATE_SUB(column, interval expr)</code> Syntax Example</strong></p> + +<p>The <code>employee.json</code> file, which Drill includes in the installation, lists the hire dates of employees. Cast the hire_dates of the employees 578 and 761 to a timestamp, and add 10 hours to the hire_date timestamp. Because Drill reads data from JSON as VARCHAR, you need to cast the hire_date to the TIMESTAMP type. </p> +<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(CAST(hire_date AS TIMESTAMP), interval '10' hour) FROM cp.`employee.json` WHERE employee_id IN( '578','761'); ++------------------------+ +| EXPR$0 | ++------------------------+ +| 1995-12-31 14:00:00.0 | +| 1997-12-31 14:00:00.0 | ++------------------------+ +2 rows selected (0.161 seconds) +</code></pre></div> <h2 id="other-date-and-time-functions">Other Date and Time Functions</h2> <p>The following examples show how to use these functions:</p> @@ -1377,7 +1426,7 @@ SELECT NOW() FROM sys.version; <p>Returns a component of a timestamp, time, date, or interval.</p> -<h4 id="extract-syntax">EXTRACT Syntax</h4> +<h3 id="extract-syntax">EXTRACT Syntax</h3> <div class="highlight"><pre><code class="language-text" data-lang="text">EXTRACT (extract_expression) </code></pre></div> <p><em>extract_expression</em> is:</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/deploying-and-using-a-hive-udf/index.html ---------------------------------------------------------------------- diff --git a/docs/deploying-and-using-a-hive-udf/index.html b/docs/deploying-and-using-a-hive-udf/index.html index 7c1e0ce..9445b8d 100644 --- a/docs/deploying-and-using-a-hive-udf/index.html +++ b/docs/deploying-and-using-a-hive-udf/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/describe/index.html ---------------------------------------------------------------------- diff --git a/docs/describe/index.html b/docs/describe/index.html index a72fa70..b1553b4 100644 --- a/docs/describe/index.html +++ b/docs/describe/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/design-docs/index.html ---------------------------------------------------------------------- diff --git a/docs/design-docs/index.html b/docs/design-docs/index.html index 08fa580..929a25a 100644 --- a/docs/design-docs/index.html +++ b/docs/design-docs/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/develop-a-simple-function/index.html ---------------------------------------------------------------------- diff --git a/docs/develop-a-simple-function/index.html b/docs/develop-a-simple-function/index.html index 847ffcb..1036459 100644 --- a/docs/develop-a-simple-function/index.html +++ b/docs/develop-a-simple-function/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/develop-custom-functions-introduction/index.html ---------------------------------------------------------------------- diff --git a/docs/develop-custom-functions-introduction/index.html b/docs/develop-custom-functions-introduction/index.html index 0d56cc5..f797caa 100644 --- a/docs/develop-custom-functions-introduction/index.html +++ b/docs/develop-custom-functions-introduction/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/develop-custom-functions/index.html ---------------------------------------------------------------------- diff --git a/docs/develop-custom-functions/index.html b/docs/develop-custom-functions/index.html index 0eb7dd2..ee9e1ec 100644 --- a/docs/develop-custom-functions/index.html +++ b/docs/develop-custom-functions/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/develop-drill/index.html ---------------------------------------------------------------------- diff --git a/docs/develop-drill/index.html b/docs/develop-drill/index.html index a90856e..c9d76a2 100644 --- a/docs/develop-drill/index.html +++ b/docs/develop-drill/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/developer-information/index.html ---------------------------------------------------------------------- diff --git a/docs/developer-information/index.html b/docs/developer-information/index.html index 3c4ddee..5892b7b 100644 --- a/docs/developer-information/index.html +++ b/docs/developer-information/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/developing-an-aggregate-function/index.html ---------------------------------------------------------------------- diff --git a/docs/developing-an-aggregate-function/index.html b/docs/developing-an-aggregate-function/index.html index 4632a28..3453162 100644 --- a/docs/developing-an-aggregate-function/index.html +++ b/docs/developing-an-aggregate-function/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/distributed-mode-prerequisites/index.html ---------------------------------------------------------------------- diff --git a/docs/distributed-mode-prerequisites/index.html b/docs/distributed-mode-prerequisites/index.html index ae7d86b..f89714e 100644 --- a/docs/distributed-mode-prerequisites/index.html +++ b/docs/distributed-mode-prerequisites/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/drill-default-input-format/index.html ---------------------------------------------------------------------- diff --git a/docs/drill-default-input-format/index.html b/docs/drill-default-input-format/index.html index 3a7f1f6..533f53e 100644 --- a/docs/drill-default-input-format/index.html +++ b/docs/drill-default-input-format/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/drill-in-10-minutes/index.html ---------------------------------------------------------------------- diff --git a/docs/drill-in-10-minutes/index.html b/docs/drill-in-10-minutes/index.html index c15bbb3..2967cc5 100644 --- a/docs/drill-in-10-minutes/index.html +++ b/docs/drill-in-10-minutes/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/drill-introduction/index.html ---------------------------------------------------------------------- diff --git a/docs/drill-introduction/index.html b/docs/drill-introduction/index.html index 30a9328..f7fea44 100644 --- a/docs/drill-introduction/index.html +++ b/docs/drill-introduction/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/drill-patch-review-tool/index.html ---------------------------------------------------------------------- diff --git a/docs/drill-patch-review-tool/index.html b/docs/drill-patch-review-tool/index.html index 3caa335..fdfa38a 100644 --- a/docs/drill-patch-review-tool/index.html +++ b/docs/drill-patch-review-tool/index.html @@ -686,23 +686,25 @@ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
