http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/repeated-contains/index.html ---------------------------------------------------------------------- diff --git a/docs/repeated-contains/index.html b/docs/repeated-contains/index.html index 38808fa..30e1199 100644 --- a/docs/repeated-contains/index.html +++ b/docs/repeated-contains/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/repeated-count/index.html ---------------------------------------------------------------------- diff --git a/docs/repeated-count/index.html b/docs/repeated-count/index.html index f536fda..470099d 100644 --- a/docs/repeated-count/index.html +++ b/docs/repeated-count/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/reserved-keywords/index.html ---------------------------------------------------------------------- diff --git a/docs/reserved-keywords/index.html b/docs/reserved-keywords/index.html index c87bec4..8849a08 100644 --- a/docs/reserved-keywords/index.html +++ b/docs/reserved-keywords/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/review-the-java-stack-trace/index.html ---------------------------------------------------------------------- diff --git a/docs/review-the-java-stack-trace/index.html b/docs/review-the-java-stack-trace/index.html index cec6b70..6610902 100644 --- a/docs/review-the-java-stack-trace/index.html +++ b/docs/review-the-java-stack-trace/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/rpc-overview/index.html ---------------------------------------------------------------------- diff --git a/docs/rpc-overview/index.html b/docs/rpc-overview/index.html index e684b06..2914e6c 100644 --- a/docs/rpc-overview/index.html +++ b/docs/rpc-overview/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sample-data-donuts/index.html ---------------------------------------------------------------------- diff --git a/docs/sample-data-donuts/index.html b/docs/sample-data-donuts/index.html index 059034e..9174ee3 100644 --- a/docs/sample-data-donuts/index.html +++ b/docs/sample-data-donuts/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sample-datasets/index.html ---------------------------------------------------------------------- diff --git a/docs/sample-datasets/index.html b/docs/sample-datasets/index.html index df7f616..2ea99ab 100644 --- a/docs/sample-datasets/index.html +++ b/docs/sample-datasets/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-from/index.html ---------------------------------------------------------------------- diff --git a/docs/select-from/index.html b/docs/select-from/index.html index ede39a7..9763165 100644 --- a/docs/select-from/index.html +++ b/docs/select-from/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-group-by/index.html ---------------------------------------------------------------------- diff --git a/docs/select-group-by/index.html b/docs/select-group-by/index.html index f7c80a6..32c1db7 100644 --- a/docs/select-group-by/index.html +++ b/docs/select-group-by/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-having/index.html ---------------------------------------------------------------------- diff --git a/docs/select-having/index.html b/docs/select-having/index.html index c8ce4c0..7aa6087 100644 --- a/docs/select-having/index.html +++ b/docs/select-having/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-limit/index.html ---------------------------------------------------------------------- diff --git a/docs/select-limit/index.html b/docs/select-limit/index.html index 8ea46f7..e575862 100644 --- a/docs/select-limit/index.html +++ b/docs/select-limit/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-offset/index.html ---------------------------------------------------------------------- diff --git a/docs/select-offset/index.html b/docs/select-offset/index.html index b5114b6..324a0e8 100644 --- a/docs/select-offset/index.html +++ b/docs/select-offset/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-order-by/index.html ---------------------------------------------------------------------- diff --git a/docs/select-order-by/index.html b/docs/select-order-by/index.html index 1216be1..466ade8 100644 --- a/docs/select-order-by/index.html +++ b/docs/select-order-by/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-union/index.html ---------------------------------------------------------------------- diff --git a/docs/select-union/index.html b/docs/select-union/index.html index abe2229..7e81b97 100644 --- a/docs/select-union/index.html +++ b/docs/select-union/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-where/index.html ---------------------------------------------------------------------- diff --git a/docs/select-where/index.html b/docs/select-where/index.html index cfc1502..dfb6f1e 100644 --- a/docs/select-where/index.html +++ b/docs/select-where/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select-with/index.html ---------------------------------------------------------------------- diff --git a/docs/select-with/index.html b/docs/select-with/index.html index 36bbd65..eb59cb2 100644 --- a/docs/select-with/index.html +++ b/docs/select-with/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/select/index.html ---------------------------------------------------------------------- diff --git a/docs/select/index.html b/docs/select/index.html index a7874fc..3fb0086 100644 --- a/docs/select/index.html +++ b/docs/select/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/selecting-flat-data/index.html ---------------------------------------------------------------------- diff --git a/docs/selecting-flat-data/index.html b/docs/selecting-flat-data/index.html index 2b9df06..cb9d604 100644 --- a/docs/selecting-flat-data/index.html +++ b/docs/selecting-flat-data/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/selecting-multiple-columns-within-nested-data/index.html ---------------------------------------------------------------------- diff --git a/docs/selecting-multiple-columns-within-nested-data/index.html b/docs/selecting-multiple-columns-within-nested-data/index.html index 220e3c8..b3999fa 100644 --- a/docs/selecting-multiple-columns-within-nested-data/index.html +++ b/docs/selecting-multiple-columns-within-nested-data/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/selecting-nested-data-for-a-column/index.html ---------------------------------------------------------------------- diff --git a/docs/selecting-nested-data-for-a-column/index.html b/docs/selecting-nested-data-for-a-column/index.html index cf414b1..51fc847 100644 --- a/docs/selecting-nested-data-for-a-column/index.html +++ b/docs/selecting-nested-data-for-a-column/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/show-databases-and-show-schemas/index.html ---------------------------------------------------------------------- diff --git a/docs/show-databases-and-show-schemas/index.html b/docs/show-databases-and-show-schemas/index.html index cca84ee..8cdc003 100644 --- a/docs/show-databases-and-show-schemas/index.html +++ b/docs/show-databases-and-show-schemas/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/show-files/index.html ---------------------------------------------------------------------- diff --git a/docs/show-files/index.html b/docs/show-files/index.html index 033073a..a721527 100644 --- a/docs/show-files/index.html +++ b/docs/show-files/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/show-tables/index.html ---------------------------------------------------------------------- diff --git a/docs/show-tables/index.html b/docs/show-tables/index.html index 3763158..69042f2 100644 --- a/docs/show-tables/index.html +++ b/docs/show-tables/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sort-based-and-hash-based-memory-constrained-operators/index.html ---------------------------------------------------------------------- diff --git a/docs/sort-based-and-hash-based-memory-constrained-operators/index.html b/docs/sort-based-and-hash-based-memory-constrained-operators/index.html index b999100..372c900 100644 --- a/docs/sort-based-and-hash-based-memory-constrained-operators/index.html +++ b/docs/sort-based-and-hash-based-memory-constrained-operators/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sql-commands/index.html ---------------------------------------------------------------------- diff --git a/docs/sql-commands/index.html b/docs/sql-commands/index.html index 4a97e7c..042211c 100644 --- a/docs/sql-commands/index.html +++ b/docs/sql-commands/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sql-conditional-expressions/index.html ---------------------------------------------------------------------- diff --git a/docs/sql-conditional-expressions/index.html b/docs/sql-conditional-expressions/index.html index cef87f1..d9f981e 100644 --- a/docs/sql-conditional-expressions/index.html +++ b/docs/sql-conditional-expressions/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sql-extensions/index.html ---------------------------------------------------------------------- diff --git a/docs/sql-extensions/index.html b/docs/sql-extensions/index.html index 58dff91..4c829ad 100644 --- a/docs/sql-extensions/index.html +++ b/docs/sql-extensions/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sql-functions/index.html ---------------------------------------------------------------------- diff --git a/docs/sql-functions/index.html b/docs/sql-functions/index.html index c44ce46..deed532 100644 --- a/docs/sql-functions/index.html +++ b/docs/sql-functions/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sql-reference-introduction/index.html ---------------------------------------------------------------------- diff --git a/docs/sql-reference-introduction/index.html b/docs/sql-reference-introduction/index.html index 05f46db..e97c0e6 100644 --- a/docs/sql-reference-introduction/index.html +++ b/docs/sql-reference-introduction/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/sql-reference/index.html ---------------------------------------------------------------------- diff --git a/docs/sql-reference/index.html b/docs/sql-reference/index.html index dbf1ba9..54bcb2d 100644 --- a/docs/sql-reference/index.html +++ b/docs/sql-reference/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/start-up-options/index.html ---------------------------------------------------------------------- diff --git a/docs/start-up-options/index.html b/docs/start-up-options/index.html index 624eca4..f336fbb 100644 --- a/docs/start-up-options/index.html +++ b/docs/start-up-options/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/starting-drill-in-distributed-mode/index.html ---------------------------------------------------------------------- diff --git a/docs/starting-drill-in-distributed-mode/index.html b/docs/starting-drill-in-distributed-mode/index.html index d28220b..6333bb9 100644 --- a/docs/starting-drill-in-distributed-mode/index.html +++ b/docs/starting-drill-in-distributed-mode/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/starting-drill-on-linux-and-mac-os-x/index.html ---------------------------------------------------------------------- diff --git a/docs/starting-drill-on-linux-and-mac-os-x/index.html b/docs/starting-drill-on-linux-and-mac-os-x/index.html index eab32f3..f913b8d 100644 --- a/docs/starting-drill-on-linux-and-mac-os-x/index.html +++ b/docs/starting-drill-on-linux-and-mac-os-x/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -988,7 +988,7 @@ <p>At this point, you can <a href="/docs/query-data">run queries</a>.</p> -<p>You can also use the <strong>sqlline</strong> command to start Drill using a custom connection string, as described in <a href="/docs/starting-drill-in-distributed-mode/#using-an-ad-hoc-connection-to-drill">"Using an Ad-Hoc Connection to Drill"</a>. For example, you can specify the storage plugin when you start the shell. Doing so eliminates the need to specify the storage plugin in the query: For example, this command specifies the <code>dfs</code> storage plugin.</p> +<p>To start Drill, you can also use the <strong>sqlline</strong> command and a custom connection string, as described in detail in <a href="/docs/starting-drill-in-distributed-mode/#using-an-ad-hoc-connection-to-drill">"Using an Ad-Hoc Connection to Drill"</a>. For example, you can specify the storage plugin when you start the shell. Doing so eliminates the need to specify the storage plugin in the query. For example, this command specifies the <code>dfs</code> storage plugin:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline âu jdbc:drill:schema=dfs;zk=local </code></pre></div> <h2 id="exiting-the-drill-shell">Exiting the Drill Shell</h2> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/starting-drill-on-windows/index.html ---------------------------------------------------------------------- diff --git a/docs/starting-drill-on-windows/index.html b/docs/starting-drill-on-windows/index.html index 82a0491..d55af7d 100644 --- a/docs/starting-drill-on-windows/index.html +++ b/docs/starting-drill-on-windows/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -988,7 +988,7 @@ <p>At this point, you can <a href="/docs/drill-in-10-minutes#query-sample-data">submit queries</a> to Drill.</p> -<p>You can use the schema option in the <strong>sqlline</strong> command to specify a storage plugin. Specifying the storage plugin when you start up eliminates the need to specify the storage plugin in the query: For example, this command specifies the <code>dfs</code> storage plugin.</p> +<p>You can use the schema option in the <strong>sqlline</strong> command to specify a storage plugin. Specifying the storage plugin when you start up eliminates the need to specify the storage plugin in the query. For example, this command specifies the <code>dfs</code> storage plugin:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">C:\bin\sqlline sqlline.bat âu "jdbc:drill:schema=dfs;zk=local" </code></pre></div> <h2 id="exiting-the-drill-shell">Exiting the Drill Shell</h2> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/storage-plugin-configuration/index.html ---------------------------------------------------------------------- diff --git a/docs/storage-plugin-configuration/index.html b/docs/storage-plugin-configuration/index.html index f0b19bb..d0639e1 100644 --- a/docs/storage-plugin-configuration/index.html +++ b/docs/storage-plugin-configuration/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2 current"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style=""> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -973,7 +973,7 @@ <ul> - <li><a href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li><a href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li><a href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -996,7 +996,7 @@ <div class="doc-nav"> - <span class="previous-toc"><a href="/docs/storage-plugin-registration/">â Storage Plugin Registration</a></span><span class="next-toc"><a href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction â</a></span> + <span class="previous-toc"><a href="/docs/storage-plugin-registration/">â Storage Plugin Registration</a></span><span class="next-toc"><a href="/docs/plugin-configuration-basics/">Plugin Configuration Basics â</a></span> </div> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/storage-plugin-registration/index.html ---------------------------------------------------------------------- diff --git a/docs/storage-plugin-registration/index.html b/docs/storage-plugin-registration/index.html index 86a9b99..7087031 100644 --- a/docs/storage-plugin-registration/index.html +++ b/docs/storage-plugin-registration/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -978,16 +978,16 @@ <p>The Drill installation registers the <code>cp</code>, <code>dfs</code>, <code>hbase</code>, <code>hive</code>, and <code>mongo</code> storage plugins instances by default.</p> <ul> -<li><code>cp</code> +<li><code>cp</code><br> Points to a JAR file in the Drill classpath that contains the Transaction Processing Performance Council (TPC) benchmark schema TPC-H that you can query. </li> -<li><code>dfs</code> +<li><code>dfs</code><br> Points to the local file system on your machine, but you can configure this instance to point to any distributed file system, such as a Hadoop or S3 file system. </li> -<li><code>hbase</code> +<li><code>hbase</code><br> Provides a connection to HBase/M7.</li> -<li><code>hive</code> +<li><code>hive</code><br> Integrates Drill with the Hive metadata abstraction of files, HBase/M7, and libraries to read data and operate on SerDes and UDFs.</li> -<li><code>mongo</code> +<li><code>mongo</code><br> Provides a connection to MongoDB data.</li> </ul> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/string-manipulation/index.html ---------------------------------------------------------------------- diff --git a/docs/string-manipulation/index.html b/docs/string-manipulation/index.html index dd0f9f7..b7d5a9d 100644 --- a/docs/string-manipulation/index.html +++ b/docs/string-manipulation/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/summary/index.html ---------------------------------------------------------------------- diff --git a/docs/summary/index.html b/docs/summary/index.html index a746ea2..f5ba0d3 100644 --- a/docs/summary/index.html +++ b/docs/summary/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/supported-data-types/index.html ---------------------------------------------------------------------- diff --git a/docs/supported-data-types/index.html b/docs/supported-data-types/index.html index c02232d..f10c2c6 100644 --- a/docs/supported-data-types/index.html +++ b/docs/supported-data-types/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -1054,7 +1054,7 @@ </tr> </tbody></table> -<p>* In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. The NUMERIC data type is an alias for the DECIMAL data type.<br> +<p>* In this release, Drill disables the DECIMAL data type (an alpha feature), including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. The NUMERIC data type is an alias for the DECIMAL data type.<br> ** Not currently supported.<br> *** Currently, Drill supports only variable-length strings. </p> @@ -1133,12 +1133,12 @@ Implicitly casts Parquet data to the SQL types shown in <a href="/docs/parquet-f Implicitly casts all textual data to VARCHAR.</li> </ul> -<h2 id="explicit-casting-precedence-of-data-types">Explicit Casting Precedence of Data Types</h2> +<h2 id="implicit-casting-precedence-of-data-types">Implicit Casting Precedence of Data Types</h2> <p>The following list includes data types Drill uses in descending order of precedence. Casting precedence shown in the following table applies to the implicit casting that Drill performs. For example, Drill might implicitly cast data when a query includes a function or filter on mismatched data types:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT myBigInt FROM mytable WHERE myBigInt = 2.5; </code></pre></div> -<p>As shown in the table, you can cast a NULL value, which has the lowest precedence, to any other type; you can cast a SMALLINT (not supported in this release) value to INT. Drill might deviate from these precedence rules for performance reasons. Under certain circumstances, such as queries involving SUBSTR and CONCAT functions, Drill reverses the order of precedence and allows a cast to VARCHAR from a type of higher precedence than VARCHAR, such as BIGINT.</p> +<p>As shown in the table, Drill can cast a NULL value, which has the lowest precedence, to any other type; you can cast a SMALLINT (not supported in this release) value to INT. Drill might deviate from these precedence rules for performance reasons. Under certain circumstances, such as queries involving SUBSTR and CONCAT functions, Drill reverses the order of precedence and allows a cast to VARCHAR from a type of higher precedence than VARCHAR, such as BIGINT.</p> <h3 id="casting-precedence">Casting Precedence</h3> @@ -1211,8 +1211,8 @@ Implicitly casts all textual data to VARCHAR.</li> <td>FIXEDBINARY</td> </tr> <tr> -<td>21</td> -<td>NULL (lowest)</td> +<td></td> +<td></td> <td>21</td> <td>NULL (lowest)</td> </tr> @@ -1352,7 +1352,7 @@ Converts a string to TIMESTAMP.</li> <td>yes</td> <td>yes</td> <td>yes</td> -<td>char</td> +<td>no</td> <td>yes</td> <td>yes</td> <td>yes</td> @@ -1379,7 +1379,7 @@ Converts a string to TIMESTAMP.</li> <td>yes</td> <td>yes</td> <td>no</td> -<td>no</td> +<td>yes</td> </tr> <tr> <td>VARBINARY**</td> @@ -1401,7 +1401,7 @@ Converts a string to TIMESTAMP.</li> <div class="admonition note"> <p class="first admonition-title">Note</p> - <p class="last">The CAST function does not support all representations of FIXEDBINARY. Only the UTF-8 format is supported. </p> + <p class="last">The CAST function does not support all representations of FIXEDBINARY and VARBINARY. Only the UTF-8 format is supported. </p> </div> <p>If your FIXEDBINARY or VARBINARY data is in a format other than UTF-8, such as big endian, use the CONVERT_TO/FROM functions instead of CAST.</p> @@ -1511,9 +1511,9 @@ Converts a string to TIMESTAMP.</li> </tr> </tbody></table> -<p>* Used to cast binary UTF-8 data coming to/from sources such as MapR-DB/HBase. </p> +<p>* Used to cast binary UTF-8 data coming to/from sources such as MapR-DB/HBase. The CAST function does not support all representations of FIXEDBINARY and VARBINARY. Only the UTF-8 format is supported. </p> -<h2 id="convert_to-and-convert_from-data-types">CONVERT_TO and CONVERT_FROM Data Types</h2> +<h2 id="convert_to-and-convert_from">CONVERT_TO and CONVERT_FROM</h2> <p>CONVERT_TO converts data to binary from the input type. CONVERT_FROM converts data from binary to the input type. For example, the following CONVERT_TO function converts an integer in big endian format to VARBINARY:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">CONVERT_TO(mycolumn, 'INT_BE') http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/supported-sql-commands/index.html ---------------------------------------------------------------------- diff --git a/docs/supported-sql-commands/index.html b/docs/supported-sql-commands/index.html index 8394a1e..0c5c3b6 100644 --- a/docs/supported-sql-commands/index.html +++ b/docs/supported-sql-commands/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/tableau-examples/index.html ---------------------------------------------------------------------- diff --git a/docs/tableau-examples/index.html b/docs/tableau-examples/index.html index c811068..7ba7028 100644 --- a/docs/tableau-examples/index.html +++ b/docs/tableau-examples/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/testing-the-odbc-connection/index.html ---------------------------------------------------------------------- diff --git a/docs/testing-the-odbc-connection/index.html b/docs/testing-the-odbc-connection/index.html index 6a0b27c..4124193 100644 --- a/docs/testing-the-odbc-connection/index.html +++ b/docs/testing-the-odbc-connection/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/troubleshooting/index.html ---------------------------------------------------------------------- diff --git a/docs/troubleshooting/index.html b/docs/troubleshooting/index.html index 584f725..98a7392 100644 --- a/docs/troubleshooting/index.html +++ b/docs/troubleshooting/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -998,16 +998,18 @@ SELECT commit_id FROM sys.version;</p> <p>If you have any issues in Drill, search the following list for your issue and apply the suggested solution:</p> -<p><strong>Query Parsing Errors</strong><br> -Symptom: </p> +<h3 id="query-parsing-errors">Query Parsing Errors</h3> + +<p>Symptom: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> PARSE ERROR: At line x, column x: ... </code></pre></div> <p>Solution: Verify that you are using valid syntax. See <a href="/docs/sql-reference-introduction/">SQL Reference</a>. If you are using common words, they may be reserved words. Make sure to use back ticks Confirm that you are using back ticks to quote identifiers when using special characters such as back slashes or periods from a file path.</p> -<p><strong>Reserved Words</strong><br> -Symptom: </p> +<h3 id="reserved-words">Reserved Words</h3> + +<p>Symptom: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> select count from dfs.drill.`test2.json`; Query failed: SYSTEM ERROR: Failure parsing SQL. Encountered "count from" at line 1, column 8. Was expecting one of: @@ -1017,8 +1019,9 @@ Symptom: </p> <p>Solution: Fix with correct syntax. See <a href="/docs/reserved-keywords/">Reserved Keywords</a>.</p> <div class="highlight"><pre><code class="language-text" data-lang="text"> select `count` from dfs.drill.`test2.json`; </code></pre></div> -<p><strong>Tables not found</strong><br> -Symptom:</p> +<h3 id="tables-not-found">Tables not found</h3> + +<p>Symptom:</p> <div class="highlight"><pre><code class="language-text" data-lang="text"> select * from dfs.drill.test2.json; Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 17: Table 'dfs.drill.test2.json' not found </code></pre></div> @@ -1041,21 +1044,23 @@ Symptom:</p> </ul></li> </ol> -<p><strong>Access nested fields without table name/alias</strong><br> -Symptom: </p> +<h3 id="access-nested-fields-without-table-name/alias">Access nested fields without table name/alias</h3> + +<p>Symptom: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> select x.y ⦠PARSE ERROR: At line 1, column 8: Table 'x' not found </code></pre></div> <p>Solution: Add table name or alias to the field reference: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> select t.x.y from t </code></pre></div> -<p><strong>Unexpected null values for columns in results</strong><br> -Symptom: The following type of query returns NULL values: </p> +<h3 id="unexpected-null-values-for-columns-in-results">Unexpected null values for columns in results</h3> + +<p>Symptom: The following type of query returns NULL values: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> select t.price from t </code></pre></div> <p>Solution: Drill is schema-less system. Verify that column names are typed correctly.</p> -<p><strong>Using functions with incorrect data types</strong> </p> +<h3 id="using-functions-with-incorrect-data-types">Using functions with incorrect data types</h3> <p>Symptom: Example </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> select trunc(c3) from t3; @@ -1072,7 +1077,7 @@ Symptom: The following type of query returns NULL values: </p> </code></pre></div> <p>Solution: Ensure that the function is invoked with the correct data type parameters. In the example above, c3 is an unsupported date type. </p> -<p><strong>Query takes a long time to return</strong> </p> +<h3 id="query-takes-a-long-time-to-return">Query takes a long time to return</h3> <p>Symptom: Query takes longer to return than expected.</p> @@ -1084,7 +1089,7 @@ Symptom: The following type of query returns NULL values: </p> <li>Confirm that Drill is taking advantage of the nature of your data, including things like partition pruning and projection pushdown.</li> </ul> -<p><strong>Schema changes</strong> </p> +<h3 id="schema-changes**">Schema changes**</h3> <p>Symptom: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> DATA_READ ERROR: Error parsing JSON - You tried to write a XXXX type when you are using a ValueWriter of type XXXX. @@ -1094,7 +1099,7 @@ Symptom: The following type of query returns NULL values: </p> </code></pre></div> <p>Solution: Drill does not fully support schema changes. In this case, you will need to either ensure that your schemas are the same or only select columns that share schema.</p> -<p><strong>Timestamps and Timezones other than UTC</strong> </p> +<h3 id="timestamps-and-timezones-other-than-utc">Timestamps and Timezones other than UTC</h3> <p>Symptoms: Issues with timestamp and timezone. Illegal instant due to time zone offset transition (America/New_York)</p> @@ -1103,68 +1108,68 @@ Symptom: The following type of query returns NULL values: </p> </code></pre></div> <p><code>http://www.openkb.info/2015/05/understanding-drills-timestamp-and.html</code> </p> -<p><strong>Unexpected ODBC issues</strong> </p> +<h3 id="unexpected-odbc-issues">Unexpected ODBC issues</h3> <p>Symptom: ODBC errors.</p> <p>Solution: Make sure that the ODBC driver version is compatible with the server version. Turn on ODBC driver debug logging to better understand failure. </p> -<p><strong>Connectivity issues when connecting via ZooKeeper for JDBC/ODBC</strong> </p> +<h3 id="connectivity-issues-when-connecting-via-zookeeper-for-jdbc/odbc">Connectivity issues when connecting via ZooKeeper for JDBC/ODBC</h3> <p>Symptom: Client cannot resolve ZooKeeper host names for JDBC/ODBC.</p> <p>Solution: Ensure that Zookeeper is up and running. Verify that Drill has the correct drill-override.conf settings for the Zookeeper quorum.</p> -<p><strong>Metadata queries take a long time to return</strong> </p> +<h3 id="metadata-queries-take-a-long-time-to-return">Metadata queries take a long time to return</h3> <p>Symptom: Running SHOW databases/schemas/tables hangs (in general any information_schema queries hang).</p> <p>Solution: Disable incorrectly configured storage plugins or start appropriate services. Check compatibility matrix for the appropriate versions. </p> -<p><strong>Unexpected results due to implicit casting</strong> </p> +<h3 id="unexpected-results-due-to-implicit-casting">Unexpected results due to implicit casting</h3> <p>Symptom: rill implicitly casts based on order of precedence.</p> <p>Solution: Review Drill casting behaviors and explicitly cast for the expected results. See <a href="/docs/handling-different-data-types/">Data Types</a>.</p> -<p><strong>Column alias causes an error</strong> </p> +<h3 id="column-alias-causes-an-error">Column alias causes an error</h3> <p>Symptom: Drill is not case sensitive, and you can provide any alias for a column name. However, if the storage type is case sensitive, the alias name may conflict and cause errors.</p> <p>Solution: Verify that the column alias does not conflict with the storage type. See <a href="/docs/lexical-structure/#case-sensitivity">Lexical Structures</a>. </p> -<p><strong>List (arrays) contains null</strong> </p> +<h3 id="list-(arrays)-contains-null">List (arrays) contains null</h3> <p>Symptom: UNSUPPORTED_OPERATION ERROR: Null values are not supported in lists by default. Please set store.json.all_text_mode to true to read lists containing nulls. Be advised that this will treat JSON null values as a string containing the word 'null'.</p> <p>Solution: Change Drill session settings to enable all_text_mode per message.<br> Avoid selecting fields that are arrays containing nulls.</p> -<p><strong>SELECT COUNT (*) takes a long time to run</strong> </p> +<h3 id="select-count-(*)-takes-a-long-time-to-run">SELECT COUNT (*) takes a long time to run</h3> <p>Solution: In come cases, the underlying storage format does not have a built-in capability to return a count of records in a table. In these cases, Drill will do a full scan of the data to verify the number of records.</p> -<p><strong>Tableau issues</strong> </p> +<h3 id="tableau-issues">Tableau issues</h3> <p>Symptom: You see a lot of error messages in ODBC trace files or the performance is slow.</p> <p>Solution: Verify that you have installed the TDC file shipped with the ODBC driver. </p> -<p><strong>Group by using alias</strong> </p> +<h3 id="group-by-using-alias">Group by using alias</h3> <p>Symptom: Invalid column.</p> <p>Solution: Not supported. Use column name and/or expression directly. </p> -<p><strong>Casting a Varchar string to an integer results in an error</strong> </p> +<h3 id="casting-a-varchar-string-to-an-integer-results-in-an-error">Casting a Varchar string to an integer results in an error</h3> <p>Symptom: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> SYSTEM ERROR: java.lang.NumberFormatException </code></pre></div> <p>Solution: Per the ANSI SQL specification CAST to INT does not support empty strings. If you want to change this behavior, you can set Drill to use the cast empty string to null behavior. This can be done using the drill.exec.functions.cast_empty_string_to_null SESSION/SYSTEM option. </p> -<p><strong>Unexpected exception during fragment initialization</strong> </p> +<h3 id="unexpected-exception-during-fragment-initialization">Unexpected exception during fragment initialization</h3> <p>Symptom: The error occurred during the Foreman phase of the query. The error typically occurs due to the following common causes: </p> @@ -1175,7 +1180,7 @@ Avoid selecting fields that are arrays containing nulls.</p> <p>Solution: Enable the verbose errors option and run the query again to see if further insight is provided. </p> -<p><strong>Queries running out of memory</strong> </p> +<h3 id="queries-running-out-of-memory">Queries running out of memory</h3> <p>Symptom: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> RESOURCE ERROR: One or more nodes ran out of memory while executing the query. @@ -1190,7 +1195,7 @@ Avoid selecting fields that are arrays containing nulls.</p> <li>See <a href="/docs/configuration-options-introduction/">Configuration Options</a><br></li> </ul> -<p><strong>Unclear Error Message</strong> </p> +<h3 id="unclear-error-message">Unclear Error Message</h3> <p>Symptom: Cannot determine issue from error message.</p> @@ -1199,7 +1204,7 @@ Avoid selecting fields that are arrays containing nulls.</p> </code></pre></div> <p>Determine your currently connected drillbit using select * from sys.drillbits. Then review logs Drill logs from that drillbit.</p> -<p><strong>SQLLine error starting Drill in embedded mode</strong> </p> +<h3 id="sqlline-error-starting-drill-in-embedded-mode">SQLLine error starting Drill in embedded mode</h3> <p>Symptom: </p> <div class="highlight"><pre><code class="language-text" data-lang="text"> java.net.BindException: Address already in use http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/tutorials-introduction/index.html ---------------------------------------------------------------------- diff --git a/docs/tutorials-introduction/index.html b/docs/tutorials-introduction/index.html index 1102b08..a1c6f2b 100644 --- a/docs/tutorials-introduction/index.html +++ b/docs/tutorials-introduction/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/tutorials/index.html ---------------------------------------------------------------------- diff --git a/docs/tutorials/index.html b/docs/tutorials/index.html index b73db3e..3052189 100644 --- a/docs/tutorials/index.html +++ b/docs/tutorials/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/use/index.html ---------------------------------------------------------------------- diff --git a/docs/use/index.html b/docs/use/index.html index 6378bf5..6c6e40d 100644 --- a/docs/use/index.html +++ b/docs/use/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/useful-research/index.html ---------------------------------------------------------------------- diff --git a/docs/useful-research/index.html b/docs/useful-research/index.html index 8867a02..98038c4 100644 --- a/docs/useful-research/index.html +++ b/docs/useful-research/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-a-connection-string/index.html ---------------------------------------------------------------------- diff --git a/docs/using-a-connection-string/index.html b/docs/using-a-connection-string/index.html index 9c4df14..9665ff2 100644 --- a/docs/using-a-connection-string/index.html +++ b/docs/using-a-connection-string/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-apache-drill-with-tableau-9-desktop/index.html ---------------------------------------------------------------------- diff --git a/docs/using-apache-drill-with-tableau-9-desktop/index.html b/docs/using-apache-drill-with-tableau-9-desktop/index.html index cff9038..3894e75 100644 --- a/docs/using-apache-drill-with-tableau-9-desktop/index.html +++ b/docs/using-apache-drill-with-tableau-9-desktop/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-apache-drill-with-tableau-9-server/index.html ---------------------------------------------------------------------- diff --git a/docs/using-apache-drill-with-tableau-9-server/index.html b/docs/using-apache-drill-with-tableau-9-server/index.html index 7dbbb4b..2db6f74 100644 --- a/docs/using-apache-drill-with-tableau-9-server/index.html +++ b/docs/using-apache-drill-with-tableau-9-server/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-custom-functions-in-queries/index.html ---------------------------------------------------------------------- diff --git a/docs/using-custom-functions-in-queries/index.html b/docs/using-custom-functions-in-queries/index.html index dc87e37..ee177bf 100644 --- a/docs/using-custom-functions-in-queries/index.html +++ b/docs/using-custom-functions-in-queries/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-drill-explorer-on-windows/index.html ---------------------------------------------------------------------- diff --git a/docs/using-drill-explorer-on-windows/index.html b/docs/using-drill-explorer-on-windows/index.html index ae403b2..ea46390 100644 --- a/docs/using-drill-explorer-on-windows/index.html +++ b/docs/using-drill-explorer-on-windows/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-jdbc-with-squirrel-on-windows/index.html ---------------------------------------------------------------------- diff --git a/docs/using-jdbc-with-squirrel-on-windows/index.html b/docs/using-jdbc-with-squirrel-on-windows/index.html index 1b69815..c16efa1 100644 --- a/docs/using-jdbc-with-squirrel-on-windows/index.html +++ b/docs/using-jdbc-with-squirrel-on-windows/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> @@ -973,7 +973,7 @@ <p>To use the JDBC Driver to access Drill through SQuirreL, ensure that you meet the prerequisites and follow the steps in this section.</p> -<h3 id="prerequisites">Prerequisites</h3> +<h2 id="prerequisites">Prerequisites</h2> <ul> <li>SQuirreL requires JRE 7</li> @@ -990,7 +990,7 @@ <hr> -<h3 id="step-1:-getting-the-drill-jdbc-driver">Step 1: Getting the Drill JDBC Driver</h3> +<h2 id="step-1:-getting-the-drill-jdbc-driver">Step 1: Getting the Drill JDBC Driver</h2> <p>The Drill JDBC Driver <code>JAR</code> file must exist in a directory on your Windows machine in order to configure the driver in the SQuirreL client.</p> @@ -1009,7 +1009,7 @@ you can locate the driver in the following directory:</p> </code></pre></div> <hr> -<h3 id="step-2:-installing-and-starting-squirrel">Step 2: Installing and Starting SQuirreL</h3> +<h2 id="step-2:-installing-and-starting-squirrel">Step 2: Installing and Starting SQuirreL</h2> <p>To install and start SQuirreL, complete the following steps:</p> @@ -1022,14 +1022,14 @@ you can locate the driver in the following directory:</p> <hr> -<h3 id="step-3:-adding-the-drill-jdbc-driver-to-squirrel">Step 3: Adding the Drill JDBC Driver to SQuirreL</h3> +<h2 id="step-3:-adding-the-drill-jdbc-driver-to-squirrel">Step 3: Adding the Drill JDBC Driver to SQuirreL</h2> <p>To add the Drill JDBC Driver to SQuirreL, define the driver and create a database alias. The alias is a specific instance of the driver configuration. SQuirreL uses the driver definition and alias to connect to Drill so you can access data sources that you have registered with Drill.</p> -<h4 id="a.-define-the-driver">A. Define the Driver</h4> +<h3 id="a.-define-the-driver">A. Define the Driver</h3> <p>To define the Drill JDBC Driver, complete the following steps:</p> @@ -1071,7 +1071,7 @@ access data sources that you have registered with Drill.</p> <p><img src="/docs/img/52.png" alt="drill query flow"></p> -<h4 id="b.-create-an-alias">B. Create an Alias</h4> +<h3 id="b.-create-an-alias">B. Create an Alias</h3> <p>To create an alias, complete the following steps:</p> @@ -1080,43 +1080,18 @@ access data sources that you have registered with Drill.</p> <li><p>In the SQuirreL toolbar, select <strong>Aliases ></strong><strong>New Alias</strong>. The Add Alias dialog box appears.</p> <p><img src="/docs/img/19.png" alt="drill query flow"></p></li> -<li><p>Enter the following information:</p> +<li><p>Enter the following information: </p></li> +</ol> -<p><table style='table-layout:fixed;width:100%'><tbody><tr> - <td valign="top" width="10%"><strong>Option</strong></td> - <td valign="top" style='width: 500px;'><strong>Description</strong></td> - </tr> - <tr> - <td valign="top">Alias Name</td> - <td valign="top">A unique name for the Drill JDBC Driver alias.</td> - </tr> - <tr> - <td valign="top">Driver</td> - <td valign="top">Select the Drill JDBC Driver.</td> - </tr> - <tr> - <td valign="top">URL</td> - <td valign="top">Enter the connection URL with the name of the Drill directory stored in ZooKeeper and the cluster ID: - <code>jdbc:drill:zk=<<em>zookeeper_quorum</em>>/<drill_directory_in_zookeeper>/<cluster_ID>;schema=<<em>schema_to_use_as_default</em>></code> - <em>The following examples show URLs for Drill installed on a single node:</em><br /> - <span style="font-family: monospace;font-size: 14.0px;line-height: 1.4285715;background-color: transparent;">jdbc:drill:zk=10.10.100.56:5181/drill/demo_mapr_com-drillbits;schema=hive<br /></span> - <span style="font-family: monospace;font-size: 14.0px;line-height: 1.4285715;background-color: transparent;">jdbc:drill:zk=10.10.100.24:2181/drill/drillbits1;schema=hive<br /> </span> - <em>The following example shows a URL for Drill installed in distributed mode with a connection to a ZooKeeper quorum:</em> - <span style="font-family: monospace;font-size: 14.0px;line-height: 1.4285715;background-color: transparent;">jdbc:drill:zk=10.10.100.30:5181,10.10.100.31:5181,10.10.100.32:5181/drill/drillbits1;schema=hive</span> - <ul> - <li>Including a default schema is optional.</li> - <li>The ZooKeeper port is 2181. In a MapR cluster, the ZooKeeper port is 5181.</li> - <li>The Drill directory stored in ZooKeeper is <code>/drill</code>.</li> - <li>The Drill default cluster ID is<code> drillbits1</code>.</li> - </ul> - </td></tr><tr> - <td valign="top">User Name</td> - <td valign="top">admin</td> - </tr> - <tr> - <td valign="top">Password</td> - <td valign="top">admin</td> - </tr></tbody></table></p></li> +<ul> +<li>Alias Name: A unique name for the Drill JDBC Driver alias<br></li> +<li>Driver: Select the Drill JDBC Driver<br></li> +<li>URL: Enter the connection URL with the name of the Drill directory stored in ZooKeeper and the cluster ID, as shown in the <a href="/docs/using-jdbc-with-squirrel-on-windows/#entering-the-connection-url">next section</a>.<br></li> +<li>User Name: admin<br></li> +<li>Password: admin<br></li> +</ul> + +<ol> <li><p>Click <strong>Ok</strong>. The Connect to: dialog box appears. </p> <p><img src="/docs/img/30.png" alt="drill query flow"></p></li> @@ -1126,9 +1101,28 @@ access data sources that you have registered with Drill.</p> <li><p>Click <strong>OK</strong>. SQuirreL displays a series of tabs.</p></li> </ol> +<h3 id="entering-the-connection-url">Entering the Connection URL</h3> + +<p>In step 3 of the procedure to create an alias, use the following syntax to enter the connection URL that includes the name of the Drill directory stored in ZooKeeper and the cluster ID: </p> +<div class="highlight"><pre><code class="language-text" data-lang="text"> jdbc:drill:zk=<zookeeper_quorum>/<drill_directory_in_zookeeper>/<cluster_ID>;schema=<schema_to_use_as_default> +</code></pre></div> +<p>The following examples show URLs for Drill installed on a single node:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text"> jdbc:drill:zk=10.10.100.56:5181/drill/demo_mapr_com-drillbits;schema=hive + jdbc:drill:zk=10.10.100.24:2181/drill/drillbits1;schema=hive +</code></pre></div> +<p>The following example shows a URL for Drill installed in distributed mode with a connection to a ZooKeeper quorum:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text"> jdbc:drill:zk=10.10.100.30:5181,10.10.100.31:5181,10.10.100.32:5181/drill/drillbits1;schema=hive +</code></pre></div> +<ul> +<li>Including a default schema is optional.</li> +<li>The ZooKeeper port is 2181. In a MapR cluster, the ZooKeeper port is 5181.</li> +<li>The Drill directory stored in ZooKeeper is <code>/drill</code>.</li> +<li>The Drill default cluster ID is drillbits1.</li> +</ul> + <hr> -<h3 id="step-4:-running-a-drill-query-from-squirrel">Step 4: Running a Drill Query from SQuirreL</h3> +<h2 id="step-4:-running-a-drill-query-from-squirrel">Step 4: Running a Drill Query from SQuirreL</h2> <p>Once you have SQuirreL successfully connected to your cluster through the Drill JDBC Driver, you can issue queries from the SQuirreL client. You can run http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-microstrategy-analytics-with-apache-drill/index.html ---------------------------------------------------------------------- diff --git a/docs/using-microstrategy-analytics-with-apache-drill/index.html b/docs/using-microstrategy-analytics-with-apache-drill/index.html index 0551803..99c2514 100644 --- a/docs/using-microstrategy-analytics-with-apache-drill/index.html +++ b/docs/using-microstrategy-analytics-with-apache-drill/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-odbc-on-linux-and-mac-os-x/index.html ---------------------------------------------------------------------- diff --git a/docs/using-odbc-on-linux-and-mac-os-x/index.html b/docs/using-odbc-on-linux-and-mac-os-x/index.html index 00c6814..43103ca 100644 --- a/docs/using-odbc-on-linux-and-mac-os-x/index.html +++ b/docs/using-odbc-on-linux-and-mac-os-x/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-odbc-on-windows/index.html ---------------------------------------------------------------------- diff --git a/docs/using-odbc-on-windows/index.html b/docs/using-odbc-on-windows/index.html index 15af6bf..c7f1ca5 100644 --- a/docs/using-odbc-on-windows/index.html +++ b/docs/using-odbc-on-windows/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-sql-functions-clauses-and-joins/index.html ---------------------------------------------------------------------- diff --git a/docs/using-sql-functions-clauses-and-joins/index.html b/docs/using-sql-functions-clauses-and-joins/index.html index 1f81022..d4bf812 100644 --- a/docs/using-sql-functions-clauses-and-joins/index.html +++ b/docs/using-sql-functions-clauses-and-joins/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/using-tibco-spotfire-with-drill/index.html ---------------------------------------------------------------------- diff --git a/docs/using-tibco-spotfire-with-drill/index.html b/docs/using-tibco-spotfire-with-drill/index.html index 8bbc62c..46f93e3 100644 --- a/docs/using-tibco-spotfire-with-drill/index.html +++ b/docs/using-tibco-spotfire-with-drill/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/3e15e65d/docs/value-vectors/index.html ---------------------------------------------------------------------- diff --git a/docs/value-vectors/index.html b/docs/value-vectors/index.html index 9b587e9..99b7300 100644 --- a/docs/value-vectors/index.html +++ b/docs/value-vectors/index.html @@ -329,7 +329,7 @@ <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> - <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
