Repository: drill-site Updated Branches: refs/heads/asf-site 9d49ad16a -> 22b0de1cf
Website update Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/22b0de1c Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/22b0de1c Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/22b0de1c Branch: refs/heads/asf-site Commit: 22b0de1cfe0da2997849f2c85fc6eb7c97ea9e50 Parents: 9d49ad1 Author: Kris Hahn <[email protected]> Authored: Thu Jan 14 14:56:11 2016 -0800 Committer: Kris Hahn <[email protected]> Committed: Thu Jan 14 14:56:11 2016 -0800 ---------------------------------------------------------------------- .../index.html | 18 ++++++++++-- docs/operators/index.html | 11 +------ docs/string-manipulation/index.html | 30 ++++++++++++++++++++ feed.xml | 4 +-- 4 files changed, 48 insertions(+), 15 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill-site/blob/22b0de1c/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 b0ce93c..57a3aec 100644 --- a/docs/develop-custom-functions-introduction/index.html +++ b/docs/develop-custom-functions-introduction/index.html @@ -1077,11 +1077,23 @@ clause.</p> complete the following tasks:</p> <ol> -<li>Create a Java program that implements Drillâs simple or aggregate interface, and compile a sources and a classes JAR file.</li> -<li>Add the sources and classes JAR files to Drillâs classpath.</li> -<li>Add the name of the package that contains the classes to Drillâs main configuration file, drill-override.conf. </li> +<li>Create a Java program that implements Drillâs simple or aggregate interface.</li> +<li><p>Add the following code to the drill-module.conf in your UDF project (src/main/resources/drill-module.conf). Replace com.yourgroupidentifier.udf with the package name(s) of your UDFs. </p> +<div class="highlight"><pre><code class="language-text" data-lang="text"> drill { + classpath.scanning { + packages : ${?drill.classpath.scanning.packages} [ + com.yourgroupidentifier.udf + ] + } + } +</code></pre></div></li> +<li><p>Compile the UDF and place both jar files (source + binary) in the Drill classpath on all the Drillbits. </p></li> +<li><p>Ensure that DRILL_HOME/conf/drill-override.conf does not contain any information regarding UDF packages. </p></li> +<li><p>Restart drill on all the Drillbits. </p></li> </ol> +<p>The following example shows an alternative process that is simpler short-term, but involves maintainence.</p> + <div class="doc-nav"> http://git-wip-us.apache.org/repos/asf/drill-site/blob/22b0de1c/docs/operators/index.html ---------------------------------------------------------------------- diff --git a/docs/operators/index.html b/docs/operators/index.html index 4ecc1f2..0a67674 100644 --- a/docs/operators/index.html +++ b/docs/operators/index.html @@ -1056,7 +1056,6 @@ operations on your data.</p> <li>BETWEEN</li> <li>IN</li> <li>LIKE</li> -<li>ILIKE</li> <li>NOT</li> <li>OR </li> </ul> @@ -1082,15 +1081,7 @@ operations on your data.</p> <h2 id="pattern-matching-operators">Pattern Matching Operators</h2> -<p>You can use the following pattern matching operators in your Drill queries:</p> - -<ul> -<li>LIKE</li> -<li>ILIKE</li> -<li>NOT LIKE</li> -<li>SIMILAR TO</li> -<li>NOT SIMILAR TO</li> -</ul> +<p>You can use the LIKE pattern matching operator in your Drill queries.</p> <h2 id="math-operators">Math Operators</h2> http://git-wip-us.apache.org/repos/asf/drill-site/blob/22b0de1c/docs/string-manipulation/index.html ---------------------------------------------------------------------- diff --git a/docs/string-manipulation/index.html b/docs/string-manipulation/index.html index ecf3ce0..4deae96 100644 --- a/docs/string-manipulation/index.html +++ b/docs/string-manipulation/index.html @@ -1067,6 +1067,10 @@ <td>VARCHAR</td> </tr> <tr> +<td><a href="/docs/string-manipulation/#ilike">ILIKE</a></td> +<td>BOOLEAN</td> +</tr> +<tr> <td><a href="/docs/string-manipulation/#initcap">INITCAP</a></td> <td>VARCHAR</td> </tr> @@ -1196,6 +1200,32 @@ SELECT CONVERT_FROM(BYTE_SUBSTR(row_key,6,length(row_key)),'UTF8') FROM </code></pre></div> <p>Alternatively, you can use the <a href="/docs/operators/#string-concatenate-operator">string concatenation operation</a> to concatenate strings.</p> +<h2 id="ilike">ILIKE</h2> + +<p>Compares argument one and two and returns true if values match.</p> + +<h3 id="ilike-syntax">ILIKE Syntax</h3> + +<p>ILIKE( string, string )</p> + +<h3 id="ilike-examples">ILIKE Examples</h3> +<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT ILIKE('abc', 'abc') FROM (VALUES(1)); ++---------+ +| EXPR$0 | ++---------+ +| true | ++---------+ +1 row selected (0.185 seconds) +</code></pre></div><div class="highlight"><pre><code class="language-text" data-lang="text">SELECT ILIKE(last_name, 'Spence') FROM cp.`employee.json` limit 3; ++---------+ +| EXPR$0 | ++---------+ +| false | +| false | +| true | ++---------+ +3 rows selected (0.17 seconds) +</code></pre></div> <h2 id="initcap">INITCAP</h2> <p>Returns the string using initial caps.</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/22b0de1c/feed.xml ---------------------------------------------------------------------- diff --git a/feed.xml b/feed.xml index 231f65e..6918abf 100644 --- a/feed.xml +++ b/feed.xml @@ -6,8 +6,8 @@ </description> <link>/</link> <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/> - <pubDate>Wed, 13 Jan 2016 06:36:15 -0800</pubDate> - <lastBuildDate>Wed, 13 Jan 2016 06:36:15 -0800</lastBuildDate> + <pubDate>Thu, 14 Jan 2016 14:48:45 -0800</pubDate> + <lastBuildDate>Thu, 14 Jan 2016 14:48:45 -0800</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item>
