To develop a simple function, you need to create a class within a Java package that implements Drill’s simple interface into the program, and include the required information for the function type. -Your function must use data types that Drill supports.

Complete the following steps to develop a simple function using Drill’s simple function interface:

The API for developing aggregate custom functions is at the alpha stage and intended for experimental use only. To experiment with this API, create a class within a Java package that implements Drill’s aggregate interface into the program. Include the required information for the function. Your function must include data types that Drill supports, such as INTEGER or -BIGINT. For a list of supported data types, refer to the SQL Reference.

Handling HBase Data

To query HBase data in Drill, convert every column of an HBase table to/from byte arrays from/to an SQL data type using CONVERT_TO or CONVERT_FROM with one exception: When converting data represented as a string to an INT or BIGINT number, use CAST. Use CAST to convert integers to/from HBase.

To query HBase data using Drill, convert every column of an HBase table to/from byte arrays from/to an SQL data type as described in the section "Querying HBase". Use CONVERT_TO or CONVERT_FROM functions to perform conversions of HBase data.

Handling Textual Data

Install the MapR Drill ODBC Driver on a system that meets the system requirements. Complete the following steps, described in detail in this document:

System Requirements

Operator Precedence

The following table shows the precedence of operators in decreasing order:

Operator/Element	Associativity	Description
.	left	dot notation used, for example, to drill down in a JSON map
[ ]	left	array-style notation to drill down into a JSON array
-	right	unary minus
E	left	exponentiation
* / %	left	multiplication, division, modulo
+ -	left	addition, subtraction
IS		IS TRUE, IS FALSE, IS UNKNOWN, IS NULL
IS NULL		test for null
IS NOT NULL		test for not null
(any other)	left	all other native and user-defined operators
IN		set membership
BETWEEN		range containment
OVERLAPS		time interval overlap
LIKE ILIKE SIMILAR TO NOT SIMILAR TO		string pattern matching
< >		less than, greater than
=	right	equality, assignment
NOT	right	logical negation
AND	left	logical conjunction
OR	left	logical disjunction

Operator/Element

Associativity

Description

left

dot notation used, for example, to drill down in a JSON map

[ ]

left

array-style notation to drill down into a JSON array

right

unary minus

left

exponentiation

* / %

left

multiplication, division, modulo

+ -

left

addition, subtraction

IS TRUE, IS FALSE, IS UNKNOWN, IS NULL

IS NULL

test for null

IS NOT NULL

test for not null

(any other)

left

all other native and user-defined operators

set membership

BETWEEN

range containment

OVERLAPS

time interval overlap

LIKE ILIKE SIMILAR TO NOT SIMILAR TO

string pattern matching

< >

less than, greater than

right

equality, assignment

NOT

right

logical negation

AND

left

logical conjunction

left

logical disjunction

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/order-by-clause/index.html ---------------------------------------------------------------------- diff --git a/docs/order-by-clause/index.html b/docs/order-by-clause/index.html index 535f1fa..9fae48a 100644 --- a/docs/order-by-clause/index.html +++ b/docs/order-by-clause/index.html @@ -436,6 +436,8 @@

Using Apache Drill with Tableau 9 Server

Configuring JReport with Drill

The PARTITION BY clause in the CTAS command partitions data, which Drill prunes to improve performance when you query the data. (Drill 1.1.0)

Syntax

 [ PARTITION_BY ( column_name[, . . .] ) ]
+ [ PARTITION BY ( column_name[, . . .] ) ]
 
 The PARTITION BY clause partitions the data by the first column_name, and then subpartitions the data by the next column_name, if there is one, and so on. 
 
@@ -1016,12 +1018,12 @@
 
 When the base table in the SELECT statement is schema-less, include columns in the PARTITION BY clause in the table's column list, or use a select all (SELECT *) statement:  
 CREATE TABLE dest_name [ (column, . . .) ]
-[ PARTITION_BY (column, . . .) ] 
+[ PARTITION BY (column, . . .) ] 
 AS SELECT column_list FROM <source_name>;
 
 When columns in the source table have ambiguous names, such as COLUMNS[0], define one or more column aliases in the SELECT statement. Use the alias name or names in the CREATE TABLE list. List aliases in the same order as the corresponding columns in the SELECT statement. Matching order is important because Drill performs an overwrite operation.  
 CREATE TABLE dest_name (alias1, alias2, . . .) 
-[ PARTITION_BY (alias1, . . . ) ] 
+[ PARTITION BY (alias1, . . . ) ] 
 AS SELECT column1 alias1, column2 alias2, . . .;
 
 For example:

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/partition-pruning/index.html
----------------------------------------------------------------------
diff --git a/docs/partition-pruning/index.html b/docs/partition-pruning/index.html
index 0a206b1..b1b3a6c 100644
--- a/docs/partition-pruning/index.html
+++ b/docs/partition-pruning/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/performance-tuning-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning-introduction/index.html b/docs/performance-tuning-introduction/index.html
index 6a61fd3..2331d11 100644
--- a/docs/performance-tuning-introduction/index.html
+++ b/docs/performance-tuning-introduction/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/performance-tuning-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning-reference/index.html b/docs/performance-tuning-reference/index.html
index e7f93aa..b2bfa04 100644
--- a/docs/performance-tuning-reference/index.html
+++ b/docs/performance-tuning-reference/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/performance-tuning/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning/index.html b/docs/performance-tuning/index.html
index fe94ccf..584499b 100644
--- a/docs/performance-tuning/index.html
+++ b/docs/performance-tuning/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/performance/index.html
----------------------------------------------------------------------
diff --git a/docs/performance/index.html b/docs/performance/index.html
index 337f73f..4f610f9 100644
--- a/docs/performance/index.html
+++ b/docs/performance/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/persistent-configuration-storage/index.html
----------------------------------------------------------------------
diff --git a/docs/persistent-configuration-storage/index.html b/docs/persistent-configuration-storage/index.html
index f0ecf13..119a0c0 100644
--- a/docs/persistent-configuration-storage/index.html
+++ b/docs/persistent-configuration-storage/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/physical-operators/index.html
----------------------------------------------------------------------
diff --git a/docs/physical-operators/index.html b/docs/physical-operators/index.html
index 5e6c7a7..b8d293f 100644
--- a/docs/physical-operators/index.html
+++ b/docs/physical-operators/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/planning-and-execution-options/index.html
----------------------------------------------------------------------
diff --git a/docs/planning-and-execution-options/index.html b/docs/planning-and-execution-options/index.html
index 0c1f2ab..caa6c41 100644
--- a/docs/planning-and-execution-options/index.html
+++ b/docs/planning-and-execution-options/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/plugin-configuration-basics/index.html
----------------------------------------------------------------------
diff --git a/docs/plugin-configuration-basics/index.html b/docs/plugin-configuration-basics/index.html
index 46880b4..4747886 100644
--- a/docs/plugin-configuration-basics/index.html
+++ b/docs/plugin-configuration-basics/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/ports-used-by-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/ports-used-by-drill/index.html b/docs/ports-used-by-drill/index.html
index 0f5d0ec..f1216a7 100644
--- a/docs/ports-used-by-drill/index.html
+++ b/docs/ports-used-by-drill/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/progress-reports/index.html
----------------------------------------------------------------------
diff --git a/docs/progress-reports/index.html b/docs/progress-reports/index.html
index 78b33cf..84617a7 100644
--- a/docs/progress-reports/index.html
+++ b/docs/progress-reports/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/project-bylaws/index.html
----------------------------------------------------------------------
diff --git a/docs/project-bylaws/index.html b/docs/project-bylaws/index.html
index ee54f45..f239391 100644
--- a/docs/project-bylaws/index.html
+++ b/docs/project-bylaws/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/query-audit-logging/index.html
----------------------------------------------------------------------
diff --git a/docs/query-audit-logging/index.html b/docs/query-audit-logging/index.html
index 2e12b2a..a683c49 100644
--- a/docs/query-audit-logging/index.html
+++ b/docs/query-audit-logging/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/query-data-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/query-data-introduction/index.html b/docs/query-data-introduction/index.html
index 49add6b..93b0396 100644
--- a/docs/query-data-introduction/index.html
+++ b/docs/query-data-introduction/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           
@@ -1005,7 +1007,7 @@
       
         You can query local and distributed file systems, Hive, HBase data, complex data, INFORMATION SCHEMA, and system tables as described in the subtopics of this section. 
 
-The query specifies the data source location and include data casting. 
+The query specifies the data source location and includes data casting. 
 
 Specifying the Data Source Location
 
@@ -1020,7 +1022,7 @@
 For example, you have to cast a string "100" in a JSON file to an integer in order to apply a math function
 or an aggregate function.
 
-Use CONVERT_TO and CONVERT_FROM instead of the CAST function for converting binary data types, as described in section "CONVERT_TO and CONVERT_FROM Usage Notes".
+To query HBase data using Drill, convert every column of an HBase table to/from byte arrays from/to an SQL data type as described in the section "Querying HBase". Use CONVERT_TO or CONVERT_FROM functions to perform conversions of HBase data.
 
 Troubleshooting Queries
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/query-data/index.html
----------------------------------------------------------------------
diff --git a/docs/query-data/index.html b/docs/query-data/index.html
index 1139c14..9256843 100644
--- a/docs/query-data/index.html
+++ b/docs/query-data/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           
@@ -1062,7 +1064,7 @@
       
         
   
-  ← Using Apache Drill with Tableau 9 ServerQuery Data Introduction →
+  ← Configuring JReport with DrillQuery Data Introduction →
 
 
     

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/query-directory-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/query-directory-functions/index.html b/docs/query-directory-functions/index.html
index 6698d44..9ec47c1 100644
--- a/docs/query-directory-functions/index.html
+++ b/docs/query-directory-functions/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+              
             
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/31fb6486/docs/query-plans-and-tuning-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/query-plans-and-tuning-introduction/index.html b/docs/query-plans-and-tuning-introduction/index.html
index a777694..8853b87 100644
--- a/docs/query-plans-and-tuning-introduction/index.html
+++ b/docs/query-plans-and-tuning-introduction/index.html
@@ -436,6 +436,8 @@
               
                 Using Apache Drill with Tableau 9 Server
               
+                Configuring JReport with Drill
+