This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new 6f4079f edits
6f4079f is described below
commit 6f4079fd363eebd476a3a5e3f2b6af41c0530178
Author: Bridget Bevens <bbev...@maprtech.com>
AuthorDate: Wed Dec 19 16:46:54 2018 -0800
edits
---
.../develop-drill/010-compiling-drill-from-source.md | 4 ++--
.../sql-functions/020-data-type-conversion.md | 16 ++++++++++++++--
2 files changed, 16 insertions(+), 4 deletions(-)
diff --git
a/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
b/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
index 10e5372..287e6c9 100644
---
a/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
+++
b/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
@@ -1,6 +1,6 @@
---
title: "Compiling Drill from Source"
-date: 2018-06-08 02:01:23 UTC
+date: 2018-12-20
parent: "Develop Drill"
---
To develop Drill, you compile Drill from source code and then set up a project
@@ -21,7 +21,7 @@ Maven and JDK installed:
## 1\. Clone the Repository
- git clone https://git-wip-us.apache.org/repos/asf/drill.git
+ git clone https://github.com/apache/drill.git
## 2\. Compile the Code
diff --git a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
index 97b0bcc..f88c824 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -1,6 +1,6 @@
---
title: "Data Type Conversion"
-date: 2018-12-18
+date: 2018-12-20
parent: "SQL Functions"
---
Drill supports the following functions for casting and converting data types:
@@ -8,7 +8,19 @@ Drill supports the following functions for casting and
converting data types:
* [CAST]({{ site.baseurl }}/docs/data-type-conversion/#cast)
* [CONVERT_TO and CONVERT_FROM]({{ site.baseurl
}}/docs/data-type-conversion/#convert_to-and-convert_from)
* [STRING_BINARY]({{ site.baseurl
}}/docs/data-type-conversion/#string_binary-function) and [BINARY_STRING]({{
site.baseurl }}/docs/data-type-conversion/#binary_string-function)
-* [Other Data Type Conversions]({{ site.baseurl
}}/docs/data-type-conversion/#other-data-type-conversions)
+* [Other Data Type Conversions]({{ site.baseurl
}}/docs/data-type-conversion/#other-data-type-conversions)
+
+**Note:** Starting in Drill 1.15, all cast and data type conversion functions
return an empty string ('') as null when the
`drill.exec.functions.cast_empty_string_to_null` option is enabled, for
example:
+
+ SELECT CAST('' AS DATE) FROM (VALUES(1));
+ +---------+
+ | EXPR$0 |
+ +---------+
+ | null |
+ +---------+
+
+Prior to 1.15, casting an empty string to null worked only for numeric types;
in Drill 1.15 and later casting an empty string to null also works for DATE,
TIME, TIMESTAMP, INTERVAL YEAR, INTERVAL MONTH, and INTERVAL DAY data types.
You do not have to use the CASE statement to cast empty strings to null.
+
## CAST
