drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From krish...@apache.org
Subject drill git commit: Rahul's change
Date Thu, 14 Jan 2016 22:54:31 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages 528a1fc9f -> 84fe034e2


Rahul's change

john omernik's change


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/84fe034e
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/84fe034e
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/84fe034e

Branch: refs/heads/gh-pages
Commit: 84fe034e2644ce9164e1cee93843edd196f1c68b
Parents: 528a1fc
Author: Kris Hahn <krishahn@apache.org>
Authored: Thu Jan 14 14:50:39 2016 -0800
Committer: Kris Hahn <krishahn@apache.org>
Committed: Thu Jan 14 14:54:30 2016 -0800

----------------------------------------------------------------------
 ...010-develop-custom-functions-introduction.md | 21 ++++++++++---
 _docs/sql-reference/040-operators.md            | 11 ++-----
 .../sql-functions/040-string-manipulation.md    | 33 +++++++++++++++++++-
 3 files changed, 51 insertions(+), 14 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/84fe034e/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md b/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
index 3a7f652..7bb6cf5 100644
--- a/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
+++ b/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
@@ -1,6 +1,6 @@
 ---
 title: "Develop Custom Functions Introduction"
-date:  
+date: 2016-01-14
 parent: "Develop Custom Functions"
 ---
 Drill provides a high performance Java API with interfaces that you can
@@ -35,6 +35,19 @@ clause.
 To develop custom functions that you can use in your Drill queries, you must
 complete the following tasks:
 
-  1. Create a Java program that implements Drill’s simple or aggregate interface, and compile
a sources and a classes JAR file.
-  2. Add the sources and classes JAR files to Drill’s classpath.
-  3. Add the name of the package that contains the classes to Drill’s main configuration
file, drill-override.conf. 
+  1. Create a Java program that implements Drill’s simple or aggregate interface.
+  2. 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.  
+
+           drill {
+             classpath.scanning {
+               packages : ${?drill.classpath.scanning.packages} [
+                 com.yourgroupidentifier.udf
+               ]
+             }
+           }   
+
+  3. Compile the UDF and place both jar files (source + binary) in the Drill classpath on
all the Drillbits.  
+  4. Ensure that DRILL_HOME/conf/drill-override.conf does not contain any information regarding
UDF packages.  
+  5. Restart drill on all the Drillbits.  
+
+The following example shows an alternative process that is simpler short-term, but involves
maintainence.

http://git-wip-us.apache.org/repos/asf/drill/blob/84fe034e/_docs/sql-reference/040-operators.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/040-operators.md b/_docs/sql-reference/040-operators.md
index 3770da4..a6c26d7 100644
--- a/_docs/sql-reference/040-operators.md
+++ b/_docs/sql-reference/040-operators.md
@@ -1,6 +1,6 @@
 ---
 title: "Operators"
-date:  
+date: 2016-01-14
 parent: "SQL Reference"
 ---
 You can use various types of operators in your Drill queries to perform
@@ -14,7 +14,6 @@ You can use the following logical operators in your Drill queries:
   * BETWEEN
   * IN
   * LIKE
-  * ILIKE
   * NOT
   * OR 
 
@@ -37,13 +36,7 @@ You can use the following comparison operators in your Drill queries:
 
 ## Pattern Matching Operators
 
-You can use the following pattern matching operators in your Drill queries:
-
-  * LIKE
-  * ILIKE
-  * NOT LIKE
-  * SIMILAR TO
-  * NOT SIMILAR TO
+You can use the LIKE pattern matching operator in your Drill queries.
 
 ## Math Operators
 

http://git-wip-us.apache.org/repos/asf/drill/blob/84fe034e/_docs/sql-reference/sql-functions/040-string-manipulation.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/040-string-manipulation.md b/_docs/sql-reference/sql-functions/040-string-manipulation.md
index 62912a5..a4cf192 100644
--- a/_docs/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/sql-reference/sql-functions/040-string-manipulation.md
@@ -1,6 +1,6 @@
 ---
 title: "String Manipulation"
-date:  
+date: 2016-01-14
 parent: "SQL Functions"
 ---
 
@@ -11,6 +11,7 @@ Function| Return Type
 [BYTE_SUBSTR]({{ site.baseurl }}/docs/string-manipulation/#byte_substr)|BINARY or VARCHAR
 [CHAR_LENGTH]({{ site.baseurl }}/docs/string-manipulation/#char_length)| INTEGER  
 [CONCAT]({{ site.baseurl }}/docs/string-manipulation/#concat)| VARCHAR
+[ILIKE]({{ site.baseurl }}/docs/string-manipulation/#ilike)| BOOLEAN
 [INITCAP]({{ site.baseurl }}/docs/string-manipulation/#initcap)| VARCHAR
 [LENGTH]({{ site.baseurl }}/docs/string-manipulation/#length)| INTEGER
 [LOWER]({{ site.baseurl }}/docs/string-manipulation/#lower)| VARCHAR
@@ -102,6 +103,36 @@ Concatenates arguments.
 
 Alternatively, you can use the [string concatenation operation]({{ site.baseurl }}/docs/operators/#string-concatenate-operator)
to concatenate strings.
 
+## ILIKE
+Compares argument one and two and returns true if values match.
+
+### ILIKE Syntax
+
+ILIKE( string, string )
+
+### ILIKE Examples
+
+```
+SELECT ILIKE('abc', 'abc') FROM (VALUES(1));
++---------+
+| EXPR$0  |
++---------+
+| true    |
++---------+
+1 row selected (0.185 seconds)
+```
+```
+SELECT ILIKE(last_name, 'Spence') FROM cp.`employee.json` limit 3;
++---------+
+| EXPR$0  |
++---------+
+| false   |
+| false   |
+| true    |
++---------+
+3 rows selected (0.17 seconds)
+```
+
 ## INITCAP
 Returns the string using initial caps.
 


Mime
View raw message