You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ja...@apache.org on 2015/12/16 05:16:19 UTC

drill git commit: Blog post for Drill 1.4 release

Repository: drill
Updated Branches:
  refs/heads/gh-pages 7aa38e042 -> ba928919c


Blog post for Drill 1.4 release


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

Branch: refs/heads/gh-pages
Commit: ba928919c08d87f5269a52946ced5f837e39e05b
Parents: 7aa38e0
Author: Jacques Nadeau <ja...@apache.org>
Authored: Tue Dec 15 14:35:30 2015 -0800
Committer: Jacques Nadeau <ja...@apache.org>
Committed: Tue Dec 15 20:14:46 2015 -0800

----------------------------------------------------------------------
 blog/_posts/2015-12-14-drill-1.4-released.md | 53 +++++++++++++++++++++++
 1 file changed, 53 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/ba928919/blog/_posts/2015-12-14-drill-1.4-released.md
----------------------------------------------------------------------
diff --git a/blog/_posts/2015-12-14-drill-1.4-released.md b/blog/_posts/2015-12-14-drill-1.4-released.md
new file mode 100644
index 0000000..15696b4
--- /dev/null
+++ b/blog/_posts/2015-12-14-drill-1.4-released.md
@@ -0,0 +1,53 @@
+---
+layout: post
+title: "Drill 1.4 Released"
+code: drill-1.4-released
+excerpt: Apache Drill 1.4's highlights are&#58; "select with options" queries that can change storage plugin settings, improved behavior when parsing CSV file header names, a variable to set non-pretty (e.g. compact) printing of JSON, and better drillbit.log files that include query text.
+authors: ["jnadeau"]
+---
+
+Apache Drill 1.4 ([available here](https://drill.apache.org/download/)) includes bug fixes and enhancements from [32 
+JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12332947&projectId=12313820).
+
+Here's a list of highlights from this newest version of Drill:
+
+## Select With Options
+Queries that change storage plugin configuration options can now be written. For instance to query the file `CO.dat`, the following can be used:
+
+```
+SELECT * FROM TABLE(dfs.`/path/to/CO.dat`(type => 'text'));
+```
+
+If a version of `CO.dat` with a header is available, the first entries of the file can be parsed as column names by 
+passing an `extractHeader => true` argument. We can also use a pipe symbol, '|', as the delimiter by passing 
+`fieldDelimiter`:
+
+```
+SELECT * FROM TABLE(dfs.`/path/to/CO.dat`(type => 'text', fieldDelimiter => '|', extractHeader => true));
+```
+
+Additionally, `lineDelimiter' can be used to indicate a deliminter for new lines, such as the double pipe, '||', symbol 
+in this example:
+
+```
+SELECT * FROM TABLE(dfs.`/path/to/CO.dat`(type => 'text', lineDelimiter => '||', fieldDelimiter => '|'));
+```
+
+## Improved Behavior For CSV Header Parsing
+When header parsing is enabled, queries to CSV files no longer raise an exception if the indicated column does not 
+exist. Instead, Drill now returns 'null' values for that column.
+
+## JSON Formatting
+For more compact results, Drill's default behavior of pretty-printing JSON can now be changed by setting the variable 
+`store.json.writer.uglify` to 'true.' As in:
+
+```
+ALTER SESSION SET store.json.writer.uglify = true;
+```
+
+## Better Logging
+SQL query text is now logged to the drillbit.log file.
+
+## Other Improvements
+This version also features: schema change compatible sorting, better Apache Hive support, and more efficient caching 
+for Parquet file metadata.