drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From krish...@apache.org
Subject drill-site git commit: Website update
Date Thu, 14 Jan 2016 22:56:08 GMT
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 <krishahn@apache.org>
Authored: Thu Jan 14 14:56:11 2016 -0800
Committer: Kris Hahn <krishahn@apache.org>
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)),&#39;UTF8&#39;)
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(&#39;abc&#39;, &#39;abc&#39;) 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, &#39;Spence&#39;) 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>


Mime
View raw message