You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by kr...@apache.org on 2015/12/18 01:22:41 UTC
drill git commit: DRILL-4168
Repository: drill
Updated Branches:
refs/heads/gh-pages f8cdbcaca -> b9686e60a
DRILL-4168
DRILL-4209
DRILL-4210
MD-605, spelling of execution
formatting
minor edit
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/b9686e60
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/b9686e60
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/b9686e60
Branch: refs/heads/gh-pages
Commit: b9686e60a96d96f48abae2fcf1fb1f41b4eed005
Parents: f8cdbca
Author: Kris Hahn <kr...@apache.org>
Authored: Thu Dec 17 15:54:46 2015 -0800
Committer: Kris Hahn <kr...@apache.org>
Committed: Thu Dec 17 16:20:05 2015 -0800
----------------------------------------------------------------------
.../020-storage-plugin-registration.md | 2 +-
.../020-hive-to-drill-data-type-mapping.md | 10 +++++++++-
.../sql-functions/060-functions-for-handling-nulls.md | 6 +++---
index.html | 2 +-
4 files changed, 14 insertions(+), 6 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/b9686e60/_docs/connect-a-data-source/020-storage-plugin-registration.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/020-storage-plugin-registration.md b/_docs/connect-a-data-source/020-storage-plugin-registration.md
index fd4b0ea..d1cacc5 100644
--- a/_docs/connect-a-data-source/020-storage-plugin-registration.md
+++ b/_docs/connect-a-data-source/020-storage-plugin-registration.md
@@ -28,7 +28,7 @@ To register a new storage plugin configuration, enter a storage name, click **CR
<!-- In Drill 1.2 and later, updating a storage plugin configuration and other storage plugin tasks require [authorization]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/) if security is enabled. -->
-## Storage Plugin Configuration Persistance
+## Storage Plugin Configuration Persistence
Drill saves storage plugin configurations in a temporary directory (embedded mode) or in ZooKeeper (distributed mode). For example, on Mac OS X, Drill uses `/tmp/drill/sys.storage_plugins` to store storage plugin configurations. The temporary directory clears when you reboot. Copy storage plugin configurations to a secure location to save them when you run drill in embedded mode.
http://git-wip-us.apache.org/repos/asf/drill/blob/b9686e60/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md b/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
index 842b667..5e2693d 100644
--- a/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
+++ b/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
@@ -2,8 +2,16 @@
title: "Hive-to-Drill Data Type Mapping"
parent: "Data Sources and File Formats"
---
-Using Drill you can read tables created in Hive that use data types compatible with Drill. Drill currently does not support writing Hive tables. Drill supports the following Hive types for querying:
+Using Drill you can read tables created in Hive that use data types compatible with Drill. Drill currently does not support writing Hive tables. The map of SQL types and Hive types shows that several Hive types need to be cast to the supported SQL type in a Drill query:
+* CHAR
+ Cast the Hive CHAR type to VARCHAR.
+* TINYINT and SMALLINT
+ Cast these types to INTEGER.
+* BINARY
+ Cast the Hive BINARY type to VARCHAR.
+
+## Map of SQL and Hive Types
<!-- See DRILL-1570 -->
| Supported SQL Type | Hive Type | Description |
http://git-wip-us.apache.org/repos/asf/drill/blob/b9686e60/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md b/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
index 8479153..147b63c 100644
--- a/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
+++ b/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
@@ -26,13 +26,13 @@ returns a null value of the type of the first expression if the two expressions
### NULLIF Syntax
- NULLIF ( expr1[, expr2, ... expr_n] )
+ NULLIF ( expr1, expr2 )
-*expr1* to *expr_n* are any valid scalar expressions.
+*expr1* to *expr2* are any valid scalar expressions.
This function returns the same type as the first expression.
-### NULLIF Example
+### NULLIF Examples
SELECT d9, d18 FROM alltypes LIMIT 1;
+------------+------------+
http://git-wip-us.apache.org/repos/asf/drill/blob/b9686e60/index.html
----------------------------------------------------------------------
diff --git a/index.html b/index.html
index 8b167a9..7cba058 100755
--- a/index.html
+++ b/index.html
@@ -151,7 +151,7 @@ $ bin/drill-embedded</pre></div>
<li>Columnar execution engine (the first ever to support complex data!)</li>
<li>Data-driven compilation and recompilation at execution time</li>
<li>Specialized memory management that reduces memory footprint and eliminates garbage collections</li>
-<li>Locality-aware exeucution that reduces network traffic when Drill is co-located with the datastore</li>
+<li>Locality-aware execution that reduces network traffic when Drill is co-located with the datastore</li>
<li>Advanced cost-based optimizer that pushes processing into the datastore when possible</li></ul></p>
</div>
<div class="small big"><img src="{{ site.baseurl }}/images/home-coffee.jpg" style="width:300px" /></div>