drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [30/30] drill git commit: Drill 1.3
Date Mon, 23 Nov 2015 21:54:13 GMT
Drill 1.3


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

Branch: refs/heads/gh-pages
Commit: 434de0bf31ba07a497fff5443ba85dffa9cde25f
Parents: 471762c
Author: Tomer Shiran <tshiran@gmail.com>
Authored: Mon Nov 23 13:49:32 2015 -0800
Committer: Tomer Shiran <tshiran@gmail.com>
Committed: Mon Nov 23 13:49:32 2015 -0800

----------------------------------------------------------------------
 _data/version.json                           | 10 +++++-----
 blog/_posts/2015-11-23-drill-1.3-released.md | 10 +++++++---
 2 files changed, 12 insertions(+), 8 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/434de0bf/_data/version.json
----------------------------------------------------------------------
diff --git a/_data/version.json b/_data/version.json
index 04ec6ea..6880ebc 100644
--- a/_data/version.json
+++ b/_data/version.json
@@ -1,7 +1,7 @@
 {
-  "display_version": "1.2",
-  "full_version": "1.2.0",
-  "release_date": "October 16, 2015",
-  "blog_post": "/blog/2015/10/16/drill-1.2-released/",
-  "release_notes": "https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689"
+  "display_version": "1.3",
+  "full_version": "1.3.0",
+  "release_date": "November 23, 2015",
+  "blog_post": "/blog/2015/11/23/drill-1.3-released/",
+  "release_notes": "https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12332946"
 }

http://git-wip-us.apache.org/repos/asf/drill/blob/434de0bf/blog/_posts/2015-11-23-drill-1.3-released.md
----------------------------------------------------------------------
diff --git a/blog/_posts/2015-11-23-drill-1.3-released.md b/blog/_posts/2015-11-23-drill-1.3-released.md
index f299320..53cb356 100644
--- a/blog/_posts/2015-11-23-drill-1.3-released.md
+++ b/blog/_posts/2015-11-23-drill-1.3-released.md
@@ -11,15 +11,19 @@ Today I'm happy to announce the availability of the Drill 1.3 release.
This rele
 
 Drill 1.3 utilizes a new library, called s3a, for reading data from S3. The s3a library includes
improvements over the previous s3n library, such as higher performance and the ability to
read large files (over 5GB).
 
-In addition to the new s3a library, Drill 1.3 makes it easier to set up your AWS credentials.
Simply edit the file `conf/core-site.xml` in your Drill install directory. Check out the [step-by-step
instructions in the documentation](/docs/s3-storage-plugin/).
+In addition to the new s3a library, Drill 1.3 makes it easier to set up your AWS credentials.
Simply edit the file `conf/core-site.xml` in the Drill install directory. For more information,
check out the [step-by-step instructions](/docs/s3-storage-plugin/) in the documentation.
 
 ## Heterogeneous Types
 
+Drill 1.3 includes support for mixed-type columns, often found in systems like MongoDB and
file formats like JSON. For example, Drill can now columns that evolve from one data type
to another over time.
 
+Drill 1.3 provides a collection of functions that enable you to test the data type of a value.
For example, if you have a column that has both lists (arrays) and numbers, you can use the
following query to extract the first element from the array values:
+
+`SELECT 1 + CASE WHEN is_list(a) THEN a[0] ELSE a END FROM table;`
 
 ## Text File Headers
 
-Drill is now able to parse the header row in text files (CSV, TSV, etc.). Prior to Drill
1.3, data had to be accessed through the `columns` array:
+Drill is now able to parse the header row in a text file (CSV, TSV, etc.). Prior to Drill
1.3, data had to be accessed through the `columns` array:
 
     SELECT columns[0], columns[1] FROM dfs.`/path/to/users.csv`
     
@@ -27,7 +31,7 @@ With Drill 1.3, you can use the actual column names in the CSV file:
 
     SELECT name, address FROM dfs.`/path/to/users.csv`
 
-Follow the [steps in the documentation](/docs/text-files-csv-tsv-psv/) to enable header parsing.
You'll need to set the `extractHeader` parameter in the storage plugin configuration for the
desired file extensions.
+Enabling header parsing is as simple as setting the `extractHeader` parameter in the storage
plugin configuration for the desired file extensions. For more information, check out [the
documentation](/docs/text-files-csv-tsv-psv/).
 
 ## Sequence Files
 


Mime
View raw message