Repository: drill-site Updated Branches: refs/heads/asf-site 9da9b8822 -> d2e91ed6f
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/d2e91ed6 Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/d2e91ed6 Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/d2e91ed6 Branch: refs/heads/asf-site Commit: d2e91ed6f523e03d06cfa136aa8403ccd5778d4a Parents: 9da9b88 Author: Kris Hahn <[email protected]> Authored: Thu Dec 17 16:33:03 2015 -0800 Committer: Kris Hahn <[email protected]> Committed: Thu Dec 17 16:33:03 2015 -0800 ---------------------------------------------------------------------- docs/functions-for-handling-nulls/index.html | 4 ++-- docs/hive-to-drill-data-type-mapping/index.html | 13 ++++++++++++- docs/storage-plugin-registration/index.html | 2 +- index.html | 2 +- 4 files changed, 16 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill-site/blob/d2e91ed6/docs/functions-for-handling-nulls/index.html ---------------------------------------------------------------------- diff --git a/docs/functions-for-handling-nulls/index.html b/docs/functions-for-handling-nulls/index.html index e1cbb8b..0cb1c42 100644 --- a/docs/functions-for-handling-nulls/index.html +++ b/docs/functions-for-handling-nulls/index.html @@ -1074,9 +1074,9 @@ returns a null value of the type of the first expression if the two expressions are equal.</p> <h3 id="nullif-syntax">NULLIF Syntax</h3> -<div class="highlight"><pre><code class="language-text" data-lang="text">NULLIF ( expr1[, expr2, ... expr_n] ) +<div class="highlight"><pre><code class="language-text" data-lang="text">NULLIF ( expr1, expr2 ) </code></pre></div> -<p><em>expr1</em> to <em>expr_n</em> are any valid scalar expressions.</p> +<p><em>expr1</em> to <em>expr2</em> are any valid scalar expressions.</p> <p>This function returns the same type as the first expression.</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/d2e91ed6/docs/hive-to-drill-data-type-mapping/index.html ---------------------------------------------------------------------- diff --git a/docs/hive-to-drill-data-type-mapping/index.html b/docs/hive-to-drill-data-type-mapping/index.html index 964b7fa..dc3c703 100644 --- a/docs/hive-to-drill-data-type-mapping/index.html +++ b/docs/hive-to-drill-data-type-mapping/index.html @@ -1046,7 +1046,18 @@ <div class="int_text" align="left"> - <p>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:</p> + <p>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:</p> + +<ul> +<li>CHAR<br> +Cast the Hive CHAR type to VARCHAR.<br></li> +<li>TINYINT and SMALLINT<br> +Cast these types to INTEGER.<br></li> +<li>BINARY<br> +Cast the Hive BINARY type to VARCHAR.</li> +</ul> + +<h2 id="map-of-sql-and-hive-types">Map of SQL and Hive Types</h2> <!-- See DRILL-1570 --> http://git-wip-us.apache.org/repos/asf/drill-site/blob/d2e91ed6/docs/storage-plugin-registration/index.html ---------------------------------------------------------------------- diff --git a/docs/storage-plugin-registration/index.html b/docs/storage-plugin-registration/index.html index 0573f3f..6f8fd80 100644 --- a/docs/storage-plugin-registration/index.html +++ b/docs/storage-plugin-registration/index.html @@ -1074,7 +1074,7 @@ Provides a connection to MongoDB data.</li> <!-- In Drill 1.2 and later, updating a storage plugin configuration and other storage plugin tasks require [authorization](/docs/configuring-web-console-and-rest-api-security/) if security is enabled. --> -<h2 id="storage-plugin-configuration-persistance">Storage Plugin Configuration Persistance</h2> +<h2 id="storage-plugin-configuration-persistence">Storage Plugin Configuration Persistence</h2> <p>Drill saves storage plugin configurations in a temporary directory (embedded mode) or in ZooKeeper (distributed mode). For example, on Mac OS X, Drill uses <code>/tmp/drill/sys.storage_plugins</code> 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.</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/d2e91ed6/index.html ---------------------------------------------------------------------- diff --git a/index.html b/index.html index a11fd62..5f3d134 100644 --- a/index.html +++ b/index.html @@ -258,7 +258,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="/images/home-coffee.jpg" style="width:300px" /></div>
