You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2016/06/29 01:38:20 UTC
drill git commit: Updates for Drill 1.7 Release
Repository: drill
Updated Branches:
refs/heads/gh-pages 85659b348 -> 03c2d84fa
Updates for Drill 1.7 Release
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/03c2d84f
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/03c2d84f
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/03c2d84f
Branch: refs/heads/gh-pages
Commit: 03c2d84fa0568e71557a8206d1fd27a66ec446d5
Parents: 85659b3
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Tue Jun 28 18:29:04 2016 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Tue Jun 28 18:29:04 2016 -0700
----------------------------------------------------------------------
_data/version.json | 10 +-
.../020-hive-to-drill-data-type-mapping.md | 6 +-
.../001-log-and-debug-introduction.md | 24 ++-
_docs/log-and-debug/005-query-audit-logging.md | 14 +-
.../070-monitoring-metrics.md | 42 +++++
_docs/rn/004-1.7.0-rn.md | 159 +++++++++++++++++++
.../065-query-directory-functions.md | 9 +-
blog/_posts/2016-06-28-drill-1.7-released.md | 25 +++
8 files changed, 266 insertions(+), 23 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/_data/version.json
----------------------------------------------------------------------
diff --git a/_data/version.json b/_data/version.json
index 71fd327..90a8474 100644
--- a/_data/version.json
+++ b/_data/version.json
@@ -1,7 +1,7 @@
{
- "display_version": "1.6",
- "full_version": "1.6.0",
- "release_date": "March 16, 2016",
- "blog_post":"/blog/2016/03/16/drill-1.6-released",
- "release_notes": "https://drill.apache.org/docs/apache-drill-1-6-0-release-notes/"
+ "display_version": "1.7",
+ "full_version": "1.7.0",
+ "release_date": "June 28, 2016",
+ "blog_post":"/blog/2016/06/28/drill-1.7-released",
+ "release_notes": "https://drill.apache.org/docs/apache-drill-1-7-0-release-notes/"
}
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/_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 43eef78..fe196f6 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
@@ -1,12 +1,10 @@
---
title: "Hive-to-Drill Data Type Mapping"
-date:
+date: 2016-06-29 01:29:05 UTC
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. 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
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/_docs/log-and-debug/001-log-and-debug-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/log-and-debug/001-log-and-debug-introduction.md b/_docs/log-and-debug/001-log-and-debug-introduction.md
index 692574f..321e466 100644
--- a/_docs/log-and-debug/001-log-and-debug-introduction.md
+++ b/_docs/log-and-debug/001-log-and-debug-introduction.md
@@ -1,18 +1,28 @@
---
title: "Log and Debug Introduction"
-date: 2016-04-12 21:54:25 UTC
+date: 2016-06-29 01:29:06 UTC
parent: "Log and Debug"
---
You can use the Drill logs in conjunction with query profiles to troubleshoot issues that you encounter. Drill uses Logback as its default logging system. Logback behavior is defined by configurations set in `<drill_installation_directory>/conf/logback.xml`.
-You can configure Logback to enable specific loggers for particular components. You can also enable Logback to output log messages to Lilith, a desktop application that you can use for socket logging. By default, Drill outputs log files to `/var/log/drill`.
+You can configure Logback to enable specific loggers for particular components. You can also enable Logback to output log messages to Lilith, a desktop application that you can use for socket logging. By default, Drill outputs log files to `$DRILL_HOME/logs`. You can edit the `DRILL_LOG_DIR` variable in `drill-env.sh` to change the location of the log directory, if needed.
-Drill provides two standard output files:
+Drill outputs two standard log files:
+
+* `drillbit.out`
+* `drill.log`
+
+Drill provides a special file, `drillbit_queries.json`, on each Drill node. This log provides the QueryID and profile for every query run on a Drillbit. The Profile view in the Drill Web Console lists the last one-hundred queries that Drill ran. To see information for queries beyond the last one-hundred, you can view the `drillbit_queries.json` file on each Drill node.
+
+Drill provides [audit logging]({{site.baseurl}}/docs/query-audit-logging/) of queries executed by various drillbits in the cluster.
+
+As of Drill 1.7, you can access the log files generated by the Drillbit process running on a particular node from the Logs page in the Drill Web Console. Currently, you can only see the logs for the Drillbit process running on the node used to access the Web Console.
+
+In a web browser, navigate to the Drill Web Console at `http://<host_ip_address>:8047` and click on **Logs** to access the Logs page. The Logs page provides a list of links that correlate with the log files stored in `$DRILL_HOME/logs`.
+
+
+
-* drillbit.out
-* drill.log
-Drill also provides a special file, drillbit_queries.json, on each Drill node. This log provides the QueryID and profile for every query run on a Drillbit. The Profile view in the Drill Web Console lists the last one-hundred queries that Drill ran. To see information for queries beyond the last one-hundred, you can view the drillbit_queries.json file on each Drill node.
-Drill also provides [audit logging]({{site.baseurl}}/docs/query-audit-logging/) of queries executed by various drillbits in the cluster.
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/_docs/log-and-debug/005-query-audit-logging.md
----------------------------------------------------------------------
diff --git a/_docs/log-and-debug/005-query-audit-logging.md b/_docs/log-and-debug/005-query-audit-logging.md
index 933b473..cdba503 100644
--- a/_docs/log-and-debug/005-query-audit-logging.md
+++ b/_docs/log-and-debug/005-query-audit-logging.md
@@ -1,9 +1,19 @@
---
title: "Query Audit Logging"
-date:
+date: 2016-06-29 01:29:06 UTC
parent: "Log and Debug"
---
-The query log provides audit log functionality for the queries executed by various drillbits in the cluster. The log records important information about queries executed on the Drillbit where Drill runs. The log includes query text, start time, end time, user, status, schema, and the query id. You can query one of the following log files, depending on whether you run Drill in embedded or distributed mode, to get audit logging information:
+The query log provides audit log functionality for the queries executed by various drillbits in the cluster. The log records important information about queries executed on the Drillbit where Drill runs. The log includes the following information:
+
+* query text
+* start/end time
+* status
+* schema
+* query id
+* name of the user that launched the query
+* client IP address from which the query was launched
+
+You can query the following log files to get audit logging information:
* `sqlline_queries.json` (embedded mode)
* `drillbit_queries.json` (distributed mode)
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/_docs/performance-tuning/070-monitoring-metrics.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/070-monitoring-metrics.md b/_docs/performance-tuning/070-monitoring-metrics.md
new file mode 100644
index 0000000..8d91750
--- /dev/null
+++ b/_docs/performance-tuning/070-monitoring-metrics.md
@@ -0,0 +1,42 @@
+---
+title: "Monitoring Metrics"
+date:
+parent: "Performance Tuning"
+---
+
+As of Drill 1.7, Drill uses JMX ([Java Management Extensions](https://docs.oracle.com/javase/tutorial/jmx/)) to monitor queries at runtime. JMX provides the architecture to dynamically manage and monitor applications. JMX collects Drill system-level metrics that you can access through the Metrics tab in the Drill Web Console or a remote JMX monitoring tool, such as JConsole or the VisualVM + MBeans plugin. The Web Console Metrics tab contains the collected metrics as tables, counters, histograms, and gauges via JMX.
+
+## Remote Monitoring
+You can enable the remote JMX Java feature to monitor a specific JVM from a remote location. You can enable remote JMX with or without authentication. See the [Java documentation](http://docs.oracle.com/javase/7/docs/technotes/guides/management/agent.html).
+
+In `$DRILL_HOME/conf/drill-env.sh`, use the `DRILLBIT_JAVA_OPTS` variable to pass the relevant parameters. For example, to add remote monitoring on port 8048 without authentication:
+
+ export DRILLBIT_JAVA_OPTS=\u201d$DRILLBIT_JAVA_OPTS -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.port=8048\u201d
+
+## Disabling Drill Metrics
+JMX metric collection is enabled, by default. You can disable the metrics option if needed.
+
+In `$DRILL_HOME/conf/drill-env.sh`, set the `drill.metrics.jmx.enabled` option to false through the `DRILLBIT_JAVA_OPTS` variable. Add the variable in `drill-env.sh` if it does not exist:
+
+ export DRILLBIT_JAVA_OPTS="$DRILLBIT_JAVA_OPTS -Ddrill.metrics.jmx.enabled=false"
+
+The following table lists the predefined Drill system-level metrics that you can view through a JMX monitoring tool or the Drill Web Console:
+
+| Metric | Description |
+|---------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|
+| drill.queries.running | The number of queries running for which the Drillbit is the Foreman. |
+| drill.queries.completed | The number of queries completed, canceled, or failed for which the Drillbit was the Foreman. |
+| drill.fragments.running | The number of query fragments currently running in the Drillbit. |
+| drill.allocator.root.used | The amount of memory (in bytes) used by the internal memory allocator. |
+| drill.allocator.root.peak | The peak amount of memory (in bytes) used by the internal memory allocator. |
+| heap.used | The amount of heap memory (in bytes) used by the JVM. |
+| non-heap.used | The amount of non-heap memory (in bytes) used by the JVM. |
+| count | The number of live threads, including daemon and non-daemon threads. |
+| fd.usage | The ratio of used file descriptors to total file descriptors on *nix systems. |
+| direct.used | The amount of direct memory (in bytes) used by the JVM. This metric is useful for debugging Drill issues. |
+| runnable.count | The number of threads executing an action in the JVM. This metric is useful for debugging Drill issues. |
+| waiting.count | The number of threads waiting to execute. Typically, threads waiting on other threads to perform an action. This metric is useful for debugging Drill issues. |
+| blocked.count | The number of threads that are blocked because they are waiting on a monitor lock. This metric is useful for debugging Drill issues. |
+
+
+
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/_docs/rn/004-1.7.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/004-1.7.0-rn.md b/_docs/rn/004-1.7.0-rn.md
new file mode 100644
index 0000000..454ca28
--- /dev/null
+++ b/_docs/rn/004-1.7.0-rn.md
@@ -0,0 +1,159 @@
+---
+title: "Apache Drill 1.7.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:** June 28, 2016
+
+Today, we're happy to announce the availability of Drill 1.7.0. You can download it [here](https://drill.apache.org/download/).
+
+This release provides Monitoring via JMX, Hive CHAR data type support, HBase 1.x support, and the following bug fixes and improvements:
+
+<h2> Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4372'>DRILL-4372</a>] - Drill Operators and Functions should correctly expose their types within Calcite
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4487'>DRILL-4487</a>] - add unit test for DRILL-4449
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4725'>DRILL-4725</a>] - Improvements to InfoSchema RecordGenerator needed for DRILL-4714
+</li>
+</ul>
+
+<h2> Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2100'>DRILL-2100</a>] - Drill not deleting spooling files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2385'>DRILL-2385</a>] - count on complex objects failed with missing function implementation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2593'>DRILL-2593</a>] - 500 error when crc for a query profile is out of sync
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3705'>DRILL-3705</a>] - Query runs out of memory, reported as FAILED and leaves thread running
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3714'>DRILL-3714</a>] - Query runs out of memory and remains in CANCELLATION_REQUESTED state until drillbit is restarted
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3743'>DRILL-3743</a>] - query hangs on sqlline once Drillbit on foreman node is killed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3745'>DRILL-3745</a>] - Hive CHAR not supported
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3763'>DRILL-3763</a>] - Cancel (Ctrl-C) one of concurrent queries results in ChannelClosedException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3826'>DRILL-3826</a>] - Concurrent Query Submission leads to Channel Closed Exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3833'>DRILL-3833</a>] - Concurrent Queries Failed Unexpectedly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4143'>DRILL-4143</a>] - REFRESH TABLE METADATA - Permission Issues with metadata files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4237'>DRILL-4237</a>] - Skew in hash distribution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4298'>DRILL-4298</a>] - SYSTEM ERROR: ChannelClosedException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4317'>DRILL-4317</a>] - Exceptions on SELECT and CTAS with large CSV files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4376'>DRILL-4376</a>] - Wrong results when doing a count(*) on part of directories with metadata cache
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4459'>DRILL-4459</a>] - SchemaChangeException while querying hive json table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4472'>DRILL-4472</a>] - Pushing Filter past Union All fails: DRILL-3257 regressed DRILL-2746 but unit test update break test goal
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4476'>DRILL-4476</a>] - Enhance Union-All operator for dealing with empty left input or empty both inputs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4478'>DRILL-4478</a>] - binary_string cannot convert buffer that were not start from 0 correctly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4479'>DRILL-4479</a>] - JsonReader should pick a less restrictive type when creating the default column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4484'>DRILL-4484</a>] - NPE when querying empty directory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4490'>DRILL-4490</a>] - Count(*) function returns as optional instead of required
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4494'>DRILL-4494</a>] - Window sum over integer column returns incorrect results.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4529'>DRILL-4529</a>] - SUM() with windows function result in mismatch nullability
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4531'>DRILL-4531</a>] - Query with filter and aggregate hangs in planning phase
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4589'>DRILL-4589</a>] - Reduce planning time for file system partition pruning by reducing filter evaluation overhead
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4592'>DRILL-4592</a>] - Explain plan statement should show plan in WebUi
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4593'>DRILL-4593</a>] - Remove OldAssignmentCreator in FileSystemPlugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4614'>DRILL-4614</a>] - Drill must appoint one data type per one column for self-describing data while querying directories
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4657'>DRILL-4657</a>] - Rank() will return wrong results if a frame of data is too big (more than 2 batches)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4676'>DRILL-4676</a>] - Foreman.moveToState can block forever if called by the foreman thread while the query is still being setup
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4679'>DRILL-4679</a>] - CONVERT_FROM() json format fails if 0 rows are received from upstream operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4688'>DRILL-4688</a>] - String functions may produce incorrect result when input has multi-byte character
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4701'>DRILL-4701</a>] - Fix log name and missing lines in logs on Web UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4716'>DRILL-4716</a>] - status.json doesn't work in drill ui
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4727'>DRILL-4727</a>] - Exclude netty from HBase Client's transitive dependencies
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4733'>DRILL-4733</a>] - max(dir0) reading more columns than necessary
+</li>
+</ul>
+
+<h2> Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3559'>DRILL-3559</a>] - Make filename available to sql statments just like dirN
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3894'>DRILL-3894</a>] - Directory functions (MaxDir, MinDir ..) should have optional filename parameter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4501'>DRILL-4501</a>] - Complete MapOrListWriter for all supported data types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4523'>DRILL-4523</a>] - Disallow using loopback address in distributed mode
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4544'>DRILL-4544</a>] - Improve error messages for REFRESH TABLE METADATA command
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4549'>DRILL-4549</a>] - Add support for more truncation units in date_trunc function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4571'>DRILL-4571</a>] - Add link to local Drill logs from the web UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4573'>DRILL-4573</a>] - Zero copy LIKE, REGEXP_MATCHES, SUBSTR
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4577'>DRILL-4577</a>] - Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4584'>DRILL-4584</a>] - JDBC/ODBC Client IP in Drill audit logs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4654'>DRILL-4654</a>] - Expose New System Metrics
+</li>
+</ul>
+
+<h2> New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3474'>DRILL-3474</a>] - Add implicit file columns support
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4132'>DRILL-4132</a>] - Ability to submit simple type of physical plan directly to EndPoint DrillBit for execution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4199'>DRILL-4199</a>] - Add Support for HBase 1.X
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4446'>DRILL-4446</a>] - Improve current fragment parallelization module
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4607'>DRILL-4607</a>] - Add a split function that allows to separate string by a delimiter
+</li>
+</ul>
+
+<h2> Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4050'>DRILL-4050</a>] - Add zip archives to the list of artifacts in verify_release.sh
+</li>
+</ul>
+
+<h2> Test
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4170'>DRILL-4170</a>] - how many concurrent users can be supported
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4437'>DRILL-4437</a>] - Implement framework for testing operators in isolation
+</li>
+</ul>
+
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/_docs/sql-reference/065-query-directory-functions.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/065-query-directory-functions.md b/_docs/sql-reference/065-query-directory-functions.md
index 7076695..ce8bc00 100644
--- a/_docs/sql-reference/065-query-directory-functions.md
+++ b/_docs/sql-reference/065-query-directory-functions.md
@@ -1,6 +1,6 @@
---
title: "Query Directory Functions"
-date:
+date: 2016-06-29 01:29:06 UTC
parent: "SQL Reference"
---
You can use the following query directory functions when [querying multiple files or directories]({{site.baseurl}}/docs/querying-directories):
@@ -20,11 +20,10 @@ The query directory functions are recommended instead of the MAX or MIN aggregat
The following syntax shows how to construct a SELECT statement that using the MAXDIR function:
- SELECT * FROM <plugin>.<workspace>.`<filename>`
- WHERE dir<n> = MAXDIR('<plugin>.<workspace>', '<filename>');
+ SELECT * FROM <plugin>.<workspace>.`<filename>`
+ WHERE dir<n> = MAXDIR('<plugin>.<workspace>'[, '<filename>']);
-Enclose both arguments to the query directory function in single-quotation marks, not back ticks. The first argument to the function is the plugin and workspace names in dot notation, and the second argument is the directory name. The dir<n> variable, `dir0`, `dir1`, and so on, refers to
-subdirectories in your workspace path, as explained in section, ["Querying Directories"]({{site.baseurl}}/docs/querying-directories).
+Enclose query directory function arguments in single-quotation marks, not back ticks. The first argument to the function is the plugin and workspace names in dot notation. The second argument is the directory name. The directory name is an optional argument. The dir variable, dir0, dir1, and so on, refers to subdirectories in your workspace path, as explained in ["Querying Directories"]({{site.baseurl}}/docs/querying-directories).
## Query Directory Function Example
http://git-wip-us.apache.org/repos/asf/drill/blob/03c2d84f/blog/_posts/2016-06-28-drill-1.7-released.md
----------------------------------------------------------------------
diff --git a/blog/_posts/2016-06-28-drill-1.7-released.md b/blog/_posts/2016-06-28-drill-1.7-released.md
new file mode 100644
index 0000000..77c1fbf
--- /dev/null
+++ b/blog/_posts/2016-06-28-drill-1.7-released.md
@@ -0,0 +1,25 @@
+---
+layout: post
+title: "Drill 1.7 Released"
+code: drill-1.7-released
+excerpt: Apache Drill 1.7's highlights are: Monitoring via JMX, Hive CHAR data type support, and HBase 1.x support.
+authors: ["bbevens"]
+---
+
+Today, we're happy to announce the availability of Drill 1.7.0. You can download it [here](https://drill.apache.org/download/).
+
+The release provides the following bug fixes and improvements:
+
+## Monitoring via JMX
+You can access Drill system-level metrics, collected by JMX, through the Metrics page in the Drill Web Console or a remote JMX monitoring tool. See INSERT PAGE.
+
+## Hive CHAR Data Type
+Drill automatically converts the Hive CHAR data type to VARCHAR. You no longer need to cast the Hive CHAR data type to VARCHAR when you query Hive tables. See [Hive-to-Drill Data Type Mapping](https://drill.apache.org/docs/hive-to-drill-data-type-mapping/).
+
+## HBase
+Drill now supports HBase 1.x.
+
+
+
+A complete list of JIRAs resolved in the 1.7.0 release can be found [here](https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12334767&styleName=&projectId=12313820).
+