You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/19 14:01:29 UTC
[3/3] drill-site git commit: Website update
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/1e0ae343
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/1e0ae343
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/1e0ae343
Branch: refs/heads/asf-site
Commit: 1e0ae3431cd2520736dca8234d447e2448131aa4
Parents: 763d5b9
Author: Tomer Shiran <ts...@gmail.com>
Authored: Mon May 18 23:54:53 2015 -0700
Committer: Tomer Shiran <ts...@gmail.com>
Committed: Mon May 18 23:54:53 2015 -0700
----------------------------------------------------------------------
blog/2015/05/19/drill-1.0-released/index.html | 63 ++---
.../index.html | 213 ++++++++++++++++
blog/index.html | 10 +
css/site.css | 2 +-
docs/data-type-conversion/index.html | 6 +-
docs/date-time-and-timestamp/index.html | 74 +++---
.../index.html | 46 ++--
docs/img/loginSandBox.png | Bin 67090 -> 26594 bytes
docs/img/vbImport.png | Bin 85744 -> 95211 bytes
docs/img/vbMaprSetting.png | Bin 56436 -> 77126 bytes
docs/img/vbNetwork.png | Bin 30826 -> 61818 bytes
.../index.html | 51 +---
.../index.html | 250 ++++++++++---------
.../index.html | 223 ++++++++---------
.../index.html | 234 +++++++++--------
docs/supported-data-types/index.html | 42 ++--
download/index.html | 12 +-
feed.xml | 235 +++++++----------
index.html | 8 +-
19 files changed, 818 insertions(+), 651 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/blog/2015/05/19/drill-1.0-released/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/05/19/drill-1.0-released/index.html b/blog/2015/05/19/drill-1.0-released/index.html
index 18d1587..842ab64 100644
--- a/blog/2015/05/19/drill-1.0-released/index.html
+++ b/blog/2015/05/19/drill-1.0-released/index.html
@@ -146,59 +146,30 @@
<li>Unlock the data housed in non-relational datastores like NoSQL, Hadoop and cloud storage, making it available not only to developers, but also business users, analysts, data scientists and anyone else who can write a SQL query or use a BI tool. Non-relational datastores are capturing an increasing share of the world's data, and it's incredibly hard to explore and analyze this data.</li>
</ul>
-<p>Today we're happy to announce the availability of the production-ready Drill 1.0 release. This release addresses <a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12325568">228 JIRAs</a> on top of the 0.9 release earlier this month.</p>
+<p>Today we're happy to announce the availability of the production-ready Drill 1.0 release. This release addresses <a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12325568">228 JIRAs</a> on top of the 0.9 release earlier this month. Highlights include:</p>
+
+<ul>
+<li>Substantial improvements in stability, memory handling and performance</li>
+<li>Improvements in Drill CLI experience with addition of convenience shortcuts and improved colors/alignment</li>
+<li>Substantial additions to documentation including coverage of troubleshooting, performance tuning and many additions to the SQL reference</li>
+<li>Enhancements in join planning to facilitate high speed planning of large and complicated joins</li>
+<li>Add support for new context functions including <code>CURRENT_USER</code> and <code>CURRENT_SCHEMA</code></li>
+<li>Ability to treat all numbers as approximate decimals when reading JSON</li>
+<li>Enhancements in Drill's text and CSV handling to support first row skipping, configurable field/line delimiters and configurable quoting</li>
+<li>Improved JDBC compatibility (and tracing proxy for easy debugging).</li>
+<li>Ability to do JDBC connections with direct urls (avoiding ZooKeeper)</li>
+<li>Automatic selection of spooling or back-pressure exchange semantics to avoid distributed deadlocks in complex sort-heavy queries</li>
+<li>Improvements in query profile reporting</li>
+<li>Addition of <code>ILIKE(VARCHAR, PATTERN)</code> and <code>SUBSTR(VARCHAR, REGEX)</code> functions</li>
+</ul>
<p>We would not have been able to reach this milestone without the tremendous effort by all the <a href="/team/">committers</a> and contributors, and we would like to congratulate the entire community on achieving this milestone. While 1.0 is an exciting milestone, it's really just the beginning of the journey. We'll release 1.1 next month, and continue with our 4-6 week release cycle, so you can count on many additional enhancements over the coming months.</p>
-<p>We have included the press release issued by the Apache Software Foundation below.</p>
+<p>Also be sure to check out the <a href="/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/">Apache Software Foundation's press release</a>.</p>
<p>Happy Drilling!<br>
Tomer Shiran and Jacques Nadeau</p>
-<hr />
-
-<h1 id="the-apache-software-foundation-announces-apache™-drill™-1.0">The Apache Software Foundation Announces Apache™ Drill™ 1.0</h1>
-
-<h2 id="thousands-of-users-adopt-open-source,-enterprise-grade,-schema-free-sql-query-engine-for-apache-hadoop®,-nosql-and-cloud-storage.">Thousands of users adopt Open Source, enterprise-grade, schema-free SQL query engine for Apache Hadoop®, NoSQL and Cloud storage.</h2>
-
-<p>Forest Hill, MD --19 May 2015-- The Apache Software Foundation (ASF), the all-volunteer developers, stewards, and incubators of more than 350 Open Source projects and initiatives, announced today the availability of Apache™ Drill™ 1.0, the schema-free SQL query engine for Apache Hadoop®, NoSQL and Cloud storage.</p>
-
-<p>"The production-ready 1.0 release represents a significant milestone for the Drill project," said Tomer Shiran, member of the Apache Drill Project Management Committee. "It is the outcome of almost three years of development involving dozens of engineers from numerous companies. Apache Drill's flexibility and ease-of-use have attracted thousands of users, and the enterprise-grade reliability, security and performance in the 1.0 release will further accelerate adoption."</p>
-
-<p>With the exponential growth of data in recent years, and the shift towards rapid application development, new data is increasingly being stored in non-relational, schema-free datastores including Hadoop, NoSQL and Cloud storage. Apache Drill revolutionizes data exploration and analytics by enabling analysts, business users, data scientists and developers to explore and analyze this data without sacrificing the flexibility and agility offered by these datastores. Drill processes the data in-situ without requiring users to define schemas or transform data.</p>
-
-<p>"Drill introduces the JSON document model to the world of SQL-based analytics and BI" said Jacques Nadeau, Vice President of Apache Drill. "This enables users to query fixed-schema, evolving-schema and schema-free data stored in a variety of formats and datastores. The architecture of relational query engines and databases is built on the assumption that all data has a simple and static structure that’s known in advance, and this 40-year-old assumption is simply no longer valid. We designed Drill from the ground up to address the new reality.”</p>
-
-<p>Apache Drill's architecture is unique in many ways. It is the only columnar execution engine that supports complex and schema-free data, and the only execution engine that performs data-driven query compilation (and re-compilation, also known as schema discovery) during query execution. These unique capabilities enable Drill to achieve record-breaking performance with the flexibility offered by the JSON document model.</p>
-
-<p>The business intelligence (BI) partner ecosystem is embracing the power of Apache Drill. Organizations such as Information Builders, JReport (Jinfonet Software), MicroStrategy, Qlik®, Simba, Tableau, and TIBCO, are working closely with the Drill community to interoperate BI tools with Drill through standard ODBC and JDBC connectivity. This collaboration enables end users to explore data by leveraging sophisticated visualization tools and advanced analytics.</p>
-
-<p>"We've been using Apache Drill for the past six months," said Andrew Hamilton, CTO of Cardlytics. "Its ease of deployment and use along with its ability to quickly process trillions of records has made it an invaluable tool inside Cardlytics. Queries that were previously insurmountable are now common occurrence. Congratulations to the Drill community on this momentous occasion."</p>
-
-<p>"Drill's columnar execution engine and optimizer take full advantage of Apache Parquet's columnar storage to achieve maximum performance," said Julien Le Dem, Technical Lead of Data Processing at Twitter and Vice President of Apache Parquet. "The Drill team has been a key contributor to the Parquet project, including recent enhancements to Parquet types and vectorization. The Drill team’s involvement in the Parquet community is instrumental in driving the standard."</p>
-
-<p>"Apache Drill 1.0 raises the bar for secure, reliable and scalable SQL-on-Hadoop," said Piyush Bhargava, distinguished engineer, IT, Cisco Systems. "Because Drill integrates with existing data virtualization and visualization tools, we expect it will improve adoption of self-service data exploration and large-scale BI queries on our advanced Hadoop platform at Cisco."</p>
-
-<p>"MicroStrategy recognized early on the value of Apache Drill and is one of the first analytic platforms to certify Drill," said Tim Lang, senior executive vice president and chief technology officer at MicroStrategy Incorporated. "Because Drill is designed to be used with a minimal learning curve, it opens up more complex data sets to the end user who can immediately visualize and analyze new information using MicroStrategy’s advanced capabilities."</p>
-
-<p>"Apache Drill closes a gap around self-service SQL queries in Hadoop, especially on complex, dynamic NoSQL data types," said Mike Foster, Strategic Alliances Technology Officer at Qlik. "Drill's performance advantages for Hadoop data access, combined with the Qlik associative experience, enables our customers to continue discovering business value from a wide range of data. Congratulations to the Apache Drill community."</p>
-
-<p>"Apache Drill empowers people to access data that is traditionally difficult to work with," said Jeff Feng, product manager, Tableau. "Direct access within a centralized data repository and without pre-generating metadata definitions encourages data democracy which is essential for data-driven organizations. Additionally, Drill's instant and secure access to complex data formats, such as JSON, opens up extended analytical opportunities."</p>
-
-<p>"Congratulations to the Apache Drill community on the availability of 1.0," said Karl Van den Bergh, Vice President, Products and Cloud at TIBCO. "Drill promises to bring low-latency access to data stored in Hadoop and HBase via standard SQL semantics. This innovation is in line with the value of Fast Data analysis, which TIBCO customers welcome and appreciate."</p>
-
-<p>"The community's accomplishment is a testament to The Apache Software Foundation's ability to bring together diverse companies to work towards a common goal. None of this would have been possible without the contribution of engineers with advanced degrees and experience in relational databases, data warehousing, MPP, query optimization, Hadoop and NoSQL," added Nadeau. "Our community's strength is what will solidify Apache Drill as a key data technology for the next decade. We welcome interested individuals to learn more about Drill by joining the community's mailing lists, attending upcoming talks by Drill code committers at various conferences including Hadoop Summit, NoSQL Now, Hadoop World, or at a local Apache Drill MeetUp."</p>
-
-<p>Availability and Oversight
-Apache Drill 1.0 is available immediately as a free download from <a href="http://drill.apache.org/download/">http://drill.apache.org/download/</a>. Documentation is available at <a href="http://drill.apache.org/docs/">http://drill.apache.org/docs/</a>. As with all Apache products, Apache Drill software is released under the Apache License v2.0, and is overseen by a self-selected team of active contributors to the project. A Project Management Committee (PMC) guides the project's day-to-day operations, including community development and product releases. For ways to become involved with Apache Drill, visit <a href="http://drill.apache.org/">http://drill.apache.org/</a> and @ApacheDrill on Twitter.</p>
-
-<p>About The Apache Software Foundation (ASF)
-Established in 1999, the all-volunteer Foundation oversees more than 350 leading Open Source projects, including Apache HTTP Server --the world's most popular Web server software. Through the ASF's meritocratic process known as "The Apache Way," more than 500 individual Members and 4,500 Committers successfully collaborate to develop freely available enterprise-grade software, benefiting millions of users worldwide: thousands of software solutions are distributed under the Apache License; and the community actively participates in ASF mailing lists, mentoring initiatives, and ApacheCon, the Foundation's official user conference, trainings, and expo. The ASF is a US 501(c)(3) charitable organization, funded by individual donations and corporate sponsors including Bloomberg, Budget Direct, Cerner, Citrix, Cloudera, Comcast, Facebook, Google, Hortonworks, HP, IBM, InMotion Hosting, iSigma, Matt Mullenweg, Microsoft, Pivotal, Produban, WANdisco, and Yahoo. For more
information, visit <a href="http://www.apache.org/">http://www.apache.org/</a> or follow @TheASF on Twitter.</p>
-
-<p>© The Apache Software Foundation. "Apache", "Apache Drill", "Drill", "Apache Hadoop", "Hadoop", "Apache Parquet", "Parquet", and "ApacheCon", are registered trademarks or trademarks of The Apache Software Foundation. All other brands and trademarks are the property of their respective owners.</p>
-
-<h1 id="#">#</h1>
-
</article>
<div id="disqus_thread"></div>
<script type="text/javascript">
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html b/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html
new file mode 100644
index 0000000..37a9cb3
--- /dev/null
+++ b/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html
@@ -0,0 +1,213 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+<meta name=viewport content="width=device-width, initial-scale=1">
+
+
+<title>The Apache Software Foundation Announces Apache Drill 1.0 - Apache Drill</title>
+
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
+<link href="/css/site.css" rel="stylesheet" type="text/css"/>
+
+<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/>
+<link rel="icon" href="/favicon.ico" type="image/x-icon"/>
+
+<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></script>
+<script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript" src="/js/script.js"></script>
+<script language="javascript" type="text/javascript" src="/js/drill.js"></script>
+
+</head>
+
+
+<body onResize="resized();">
+ <div class="page-wrap">
+ <div class="bui"></div>
+
+<div id="menu" class="mw">
+<ul>
+ <li class='toc-categories'>
+ <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
+ </li>
+ <li class="logo"><a href="/"></a></li>
+ <li class='expand-menu'>
+ <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
+ </li>
+ <li class='clear-float'></li>
+ <li class="documentation-menu">
+ <a href="/docs/">Documentation</a>
+ <ul>
+
+ <li><a href="/docs/getting-started/">Getting Started</a></li>
+
+ <li><a href="/docs/architecture/">Architecture</a></li>
+
+ <li><a href="/docs/tutorials/">Tutorials</a></li>
+
+ <li><a href="/docs/install-drill/">Install Drill</a></li>
+
+ <li><a href="/docs/configure-drill/">Configure Drill</a></li>
+
+ <li><a href="/docs/connect-a-data-source/">Connect a Data Source</a></li>
+
+ <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
+
+ <li><a href="/docs/query-data/">Query Data</a></li>
+
+ <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
+ <li><a href="/docs/query-audit-logging/">Query Audit Logging</a></li>
+
+ <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+
+ <li><a href="/docs/data-sources-and-file-formats/">Data Sources and File Formats</a></li>
+
+ <li><a href="/docs/develop-custom-functions/">Develop Custom Functions</a></li>
+
+ <li><a href="/docs/developer-information/">Developer Information</a></li>
+
+ <li><a href="/docs/release-notes/">Release Notes</a></li>
+
+ <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
+
+ <li><a href="/docs/archived-pages/">Archived Pages</a></li>
+
+ <li><a href="/docs/progress-reports/">Progress Reports</a></li>
+
+ <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
+ </ul>
+ </li>
+ <li class='nav'>
+ <a href="/community-resources/">Community</a>
+ <ul>
+ <li><a href="/team/">Team</a></li>
+ <li><a href="/mailinglists/">Mailing Lists</a></li>
+ <li><a href="/community-resources/">Community Resources</a></li>
+ </ul>
+ </li>
+ <li class='nav'><a href="/faq/">FAQ</a></li>
+ <li class='nav'><a href="/blog/">Blog</a></li>
+ <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill" title="apachedrill on twitter" target="_blank"><img src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a> </li>
+ <li class='search-bar'>
+ <form id="drill-search-form">
+ <input type="text" placeholder="Search Apache Drill" id="drill-search-term" />
+ <button type="submit">
+ <i class="fa fa-search"></i>
+ </button>
+ </form>
+ </li>
+ <li class="d">
+ <a href="/download/">
+ <i class="fa fa-cloud-download"></i> Download
+ </a>
+ </li>
+</ul>
+</div>
+
+ <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+<div class="post int_text">
+ <header class="post-header">
+ <div class="int_title">
+ <h1 class="post-title">The Apache Software Foundation Announces Apache Drill 1.0</h1>
+ </div>
+ <p class="post-meta">
+
+
+
+ <strong>Author:</strong> Tomer Shiran (Founder, PMC Member and Committer, Apache Drill)<br />
+
+<strong>Date:</strong> May 19, 2015
+</p>
+ </header>
+ <div class="addthis_sharing_toolbox"></div>
+
+ <article class="post-content">
+ <p><strong>Thousands of users adopt Open Source, enterprise-grade, schema-free SQL query engine for Apache Hadoop®, NoSQL and Cloud storage</strong></p>
+
+<p>Forest Hill, MD --19 May 2015-- The Apache Software Foundation (ASF), the all-volunteer developers, stewards, and incubators of more than 350 Open Source projects and initiatives, announced today the availability of Apache™ Drill™ 1.0, the schema-free SQL query engine for Apache Hadoop®, NoSQL and Cloud storage.</p>
+
+<p>"The production-ready 1.0 release represents a significant milestone for the Drill project," said Tomer Shiran, member of the Apache Drill Project Management Committee. "It is the outcome of almost three years of development involving dozens of engineers from numerous companies. Apache Drill's flexibility and ease-of-use have attracted thousands of users, and the enterprise-grade reliability, security and performance in the 1.0 release will further accelerate adoption."</p>
+
+<p>With the exponential growth of data in recent years, and the shift towards rapid application development, new data is increasingly being stored in non-relational, schema-free datastores including Hadoop, NoSQL and Cloud storage. Apache Drill revolutionizes data exploration and analytics by enabling analysts, business users, data scientists and developers to explore and analyze this data without sacrificing the flexibility and agility offered by these datastores. Drill processes the data in-situ without requiring users to define schemas or transform data.</p>
+
+<p>"Drill introduces the JSON document model to the world of SQL-based analytics and BI" said Jacques Nadeau, Vice President of Apache Drill. "This enables users to query fixed-schema, evolving-schema and schema-free data stored in a variety of formats and datastores. The architecture of relational query engines and databases is built on the assumption that all data has a simple and static structure that’s known in advance, and this 40-year-old assumption is simply no longer valid. We designed Drill from the ground up to address the new reality.”</p>
+
+<p>Apache Drill's architecture is unique in many ways. It is the only columnar execution engine that supports complex and schema-free data, and the only execution engine that performs data-driven query compilation (and re-compilation, also known as schema discovery) during query execution. These unique capabilities enable Drill to achieve record-breaking performance with the flexibility offered by the JSON document model.</p>
+
+<p>The business intelligence (BI) partner ecosystem is embracing the power of Apache Drill. Organizations such as Information Builders, JReport (Jinfonet Software), MicroStrategy, Qlik®, Simba, Tableau, and TIBCO, are working closely with the Drill community to interoperate BI tools with Drill through standard ODBC and JDBC connectivity. This collaboration enables end users to explore data by leveraging sophisticated visualization tools and advanced analytics.</p>
+
+<p>"We've been using Apache Drill for the past six months," said Andrew Hamilton, CTO of Cardlytics. "Its ease of deployment and use along with its ability to quickly process trillions of records has made it an invaluable tool inside Cardlytics. Queries that were previously insurmountable are now common occurrence. Congratulations to the Drill community on this momentous occasion."</p>
+
+<p>"Drill's columnar execution engine and optimizer take full advantage of Apache Parquet's columnar storage to achieve maximum performance," said Julien Le Dem, Technical Lead of Data Processing at Twitter and Vice President of Apache Parquet. "The Drill team has been a key contributor to the Parquet project, including recent enhancements to Parquet types and vectorization. The Drill team’s involvement in the Parquet community is instrumental in driving the standard."</p>
+
+<p>"Apache Drill 1.0 raises the bar for secure, reliable and scalable SQL-on-Hadoop," said Piyush Bhargava, distinguished engineer, IT, Cisco Systems. "Because Drill integrates with existing data virtualization and visualization tools, we expect it will improve adoption of self-service data exploration and large-scale BI queries on our advanced Hadoop platform at Cisco."</p>
+
+<p>"MicroStrategy recognized early on the value of Apache Drill and is one of the first analytic platforms to certify Drill," said Tim Lang, senior executive vice president and chief technology officer at MicroStrategy Incorporated. "Because Drill is designed to be used with a minimal learning curve, it opens up more complex data sets to the end user who can immediately visualize and analyze new information using MicroStrategy’s advanced capabilities."</p>
+
+<p>"Apache Drill closes a gap around self-service SQL queries in Hadoop, especially on complex, dynamic NoSQL data types," said Mike Foster, Strategic Alliances Technology Officer at Qlik. "Drill's performance advantages for Hadoop data access, combined with the Qlik associative experience, enables our customers to continue discovering business value from a wide range of data. Congratulations to the Apache Drill community."</p>
+
+<p>"Apache Drill empowers people to access data that is traditionally difficult to work with," said Jeff Feng, product manager, Tableau. "Direct access within a centralized data repository and without pre-generating metadata definitions encourages data democracy which is essential for data-driven organizations. Additionally, Drill's instant and secure access to complex data formats, such as JSON, opens up extended analytical opportunities."</p>
+
+<p>"Congratulations to the Apache Drill community on the availability of 1.0," said Karl Van den Bergh, Vice President, Products and Cloud at TIBCO. "Drill promises to bring low-latency access to data stored in Hadoop and HBase via standard SQL semantics. This innovation is in line with the value of Fast Data analysis, which TIBCO customers welcome and appreciate."</p>
+
+<p>"The community's accomplishment is a testament to The Apache Software Foundation's ability to bring together diverse companies to work towards a common goal. None of this would have been possible without the contribution of engineers with advanced degrees and experience in relational databases, data warehousing, MPP, query optimization, Hadoop and NoSQL," added Nadeau. "Our community's strength is what will solidify Apache Drill as a key data technology for the next decade. We welcome interested individuals to learn more about Drill by joining the community's mailing lists, attending upcoming talks by Drill code committers at various conferences including Hadoop Summit, NoSQL Now, Hadoop World, or at a local Apache Drill MeetUp."</p>
+
+<p>Availability and Oversight
+Apache Drill 1.0 is available immediately as a free download from <a href="http://drill.apache.org/download/">http://drill.apache.org/download/</a>. Documentation is available at <a href="http://drill.apache.org/docs/">http://drill.apache.org/docs/</a>. As with all Apache products, Apache Drill software is released under the Apache License v2.0, and is overseen by a self-selected team of active contributors to the project. A Project Management Committee (PMC) guides the project's day-to-day operations, including community development and product releases. For ways to become involved with Apache Drill, visit <a href="http://drill.apache.org/">http://drill.apache.org/</a> and @ApacheDrill on Twitter.</p>
+
+<p>About The Apache Software Foundation (ASF)
+Established in 1999, the all-volunteer Foundation oversees more than 350 leading Open Source projects, including Apache HTTP Server --the world's most popular Web server software. Through the ASF's meritocratic process known as "The Apache Way," more than 500 individual Members and 4,500 Committers successfully collaborate to develop freely available enterprise-grade software, benefiting millions of users worldwide: thousands of software solutions are distributed under the Apache License; and the community actively participates in ASF mailing lists, mentoring initiatives, and ApacheCon, the Foundation's official user conference, trainings, and expo. The ASF is a US 501(c)(3) charitable organization, funded by individual donations and corporate sponsors including Bloomberg, Budget Direct, Cerner, Citrix, Cloudera, Comcast, Facebook, Google, Hortonworks, HP, IBM, InMotion Hosting, iSigma, Matt Mullenweg, Microsoft, Pivotal, Produban, WANdisco, and Yahoo. For more
information, visit <a href="http://www.apache.org/">http://www.apache.org/</a> or follow @TheASF on Twitter.</p>
+
+<p>© The Apache Software Foundation. "Apache", "Apache Drill", "Drill", "Apache Hadoop", "Hadoop", "Apache Parquet", "Parquet", and "ApacheCon", are registered trademarks or trademarks of The Apache Software Foundation. All other brands and trademarks are the property of their respective owners.</p>
+
+<p># # #</p>
+
+ </article>
+ <div id="disqus_thread"></div>
+ <script type="text/javascript">
+ /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
+ var disqus_shortname = 'drill'; // required: replace example with your forum shortname
+
+ /* * * DON'T EDIT BELOW THIS LINE * * */
+ (function() {
+ var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
+ dsq.src = '//' + disqus_shortname + '.disqus.com/embed.js';
+ (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
+ })();
+ </script>
+ <noscript>Please enable JavaScript to view the <a href="http://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
+
+</div>
+<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-548b2caa33765e8d" async="async"></script>
+
+ </div>
+ <p class="push"></p>
+<div id="footer" class="mw">
+<div class="wrapper">
+Copyright © 2012-2014 The Apache Software Foundation, licensed under the Apache License, Version 2.0.<br>
+Apache and the Apache feather logo are trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.<br/><br/>
+</div>
+</div>
+
+ <script>
+(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+ga('create', 'UA-53379651-1', 'auto');
+ga('send', 'pageview');
+</script>
+
+</body>
+</html>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/blog/index.html
----------------------------------------------------------------------
diff --git a/blog/index.html b/blog/index.html
index 2bb1cbb..04294e1 100644
--- a/blog/index.html
+++ b/blog/index.html
@@ -119,6 +119,16 @@
</div>
<div class="int_text" align="left"><!-- previously: site.posts -->
+<p><a class="post-link" href="/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/">The Apache Software Foundation Announces Apache Drill 1.0</a><br/>
+<span class="post-date">Posted on May 19, 2015
+by Tomer Shiran</span>
+<br/>The Apache Software Foundation announced today the availability of Apache Drill 1.0, the schema-free SQL query engine for Apache Hadoop, NoSQL and cloud storage.</p>
+<!-- previously: site.posts -->
+<p><a class="post-link" href="/blog/2015/05/19/drill-1.0-released/">Drill 1.0 Released</a><br/>
+<span class="post-date">Posted on May 19, 2015
+by Tomer Shiran, Jacques Nadeau</span>
+<br/>Drill 1.0 has been released, representing a major milestone for the Drill community. Drill in now production-ready, making it easier than ever to explore and analyze data in non-relational datastores.</p>
+<!-- previously: site.posts -->
<p><a class="post-link" href="/blog/2015/05/04/drill-0.9-released/">Drill 0.9 Released</a><br/>
<span class="post-date">Posted on May 4, 2015
by Tomer Shiran, Jacques Nadeau</span>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/css/site.css
----------------------------------------------------------------------
diff --git a/css/site.css b/css/site.css
index 52b4519..6a0af9e 100644
--- a/css/site.css
+++ b/css/site.css
@@ -1 +1 @@
-*{outline:none}html{height:100%}body{font-family:'PT Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;padding:0;margin:0;height:100%}.page-wrap{min-height:100%;margin-bottom:-60px}.mw{min-width:999px;width:100%}.nw{white-space:nowrap}a.anchor{display:none;font-size:0px;position:absolute;margin-top:-50px}.home_txt a.anchor{margin-top:-90px}#menu{position:fixed;top:0;width:100%;z-index:5}#menu ul{background:#051221;display:block;font-size:0px;list-style:none;overflow:hidden;padding:0;text-align:right}#menu ul li{display:inline-block;font-size:14px;margin:0;padding:0}#menu ul li.logo{float:left;padding-left:30px}#menu ul li.logo:hover{background:none}#menu ul li.logo a{background:url(../images/apachedrill.png) no-repeat center;background-size:auto 27px;display:block;height:50px;padding:0;width:80px}#menu ul li a{color:#FFF;text-decoration:none;line-height:50px;padding:14px 20px}#menu ul li.d,#menu ul li.d:hover{background-color:#4aaf4c;font-size:12px;text-transform:uppercase}#menu
ul li.d a .fam{position:relative;right:8px;font-size:14px}#menu ul li.d:hover{background-color:#348436}#menu ul li.d *{cursor:pointer}#menu ul li.d a{padding:0px 30px 0 40px;display:block}#menu ul li.l{cursor:pointer}#menu ul li.l span{background:url(../images/len.png) no-repeat center;background-size:auto 16px;display:block;line-height:50px;padding:0 20px;width:16px}#menu ul li.l.open{background-color:#145aa8}#menu ul li#twitter-menu-item{width:30px;padding-left:2px;padding-right:10px}#menu ul li#twitter-menu-item a{padding:10px}#menu ul li#twitter-menu-item img{width:22px}#menu ul li ul{background:#1a6bc7;display:none;margin:0;padding:0;position:absolute;text-align:left}#menu ul li ul li{display:block}#menu ul li ul li a{display:block;line-height:30px;padding:3px 20px}#menu ul li ul li a:hover{background:#145aa8}#menu ul li:hover{background:#1a6bc7}#menu ul li:hover ul{display:block}#menu ul li.clear-float{display:none}#subhead{background:#145aa8;color:#FFF;font-size:12px;font-we
ight:bold;height:40px;line-height:40px;left:0px;letter-spacing:1px;right:0px;position:fixed;text-align:center;text-transform:uppercase;top:10px;z-index:4;-webkit-transition:all 0.3s;transition:all 0.3s}#subhead.show{top:50px}#subhead ul{list-style:none;margin:0;padding:0}#subhead ul li{display:inline-block;list-style:none;margin:0;padding:0 35px 0 35px}#subhead ul li a{background-size:16px auto;background-position:left center;background-repeat:no-repeat;color:#FFF;display:block;padding:0 0 0 25px;text-decoration:none}#subhead ul li.ag a{background-image:url(../images/agility-w.png)}#subhead ul li.fl a{background-image:url(../images/flexibility-w.png)}#subhead ul li.fam a{background-image:url(../images/familiarity-w.png)}#header{background:url(../images/reel-bg.png) no-repeat;background-size:cover;height:300px;overflow:hidden;position:relative}#header .scroller{margin-left:0px;overflow:hidden}#header .scroller .item{float:left;height:300px;position:relative;width:100%;z-index:1}#head
er .scroller .item p a{color:#FFF;font-weight:bold;overflow:hidden;text-decoration:none;position:relative;display:inline-block;outline:none;vertical-align:bottom;text-decoration:none;white-space:nowrap}#header .scroller .item p a::before{position:absolute;top:0;left:0;z-index:-1;width:100%;height:100%;background:rgba(149,165,166,0.4);content:'';-webkit-transition:-webkit-transform 0.3s;transition:transform 0.3s;-webkit-transform:scaleY(0.618) translateX(-100%);transform:scaleY(0.618) translateX(-100%)}#header .scroller .item p a:hover::before,#header .scroller .item p a:focus::before{-webkit-transform:scaleY(0.618) translateX(0);transform:scaleY(0.618) translateX(0)}#header .scroller .item .tc{color:#FFF;margin-left:80px;position:relative;width:900px;margin:0 auto}#header .scroller .item .tc h1,#header .scroller .item .tc h2{font-size:36px;font-weight:lighter;margin:0 0 8px 0;padding:0}#header .scroller .item .tc h2{font-size:18px}#header .scroller .item .tc p{font-size:14px;font-we
ight:lighter;line-height:24px;margin:0;padding:0}#header .scroller .item .btn{background:none;border:2px solid #fff;cursor:pointer;color:#FFF;display:inline-block;font-size:12px;font-weight:bold;outline:none;margin-top:18px;position:relative;padding:5px 30px;text-decoration:none;text-transform:uppercase;-webkit-transition:all 0.3s;-moz-transition:all 0.3s;transition:all 0.3s}#header .scroller .item .btn:after{content:'';position:absolute;z-index:-1;-webkit-transition:all 0.3s;-moz-transition:all 0.3s;transition:all 0.3s}#header .scroller .item .btn-1c:after{width:0%;height:100%;top:0;left:0;background:#fff}#header .scroller .item .btn-1c:hover,#header .scroller .item .btn-1c:active{color:#0e83cd}#header .scroller .item .btn-1c:hover:after,#header .scroller .item .btn-1c:active:after{width:100%}#header .aLeft{cursor:pointer;height:30px;left:20px;margin-top:-15px;position:absolute;top:50%;width:30px;z-index:2}#header .aRight{cursor:pointer;height:30px;right:20px;margin-top:-15px;posit
ion:absolute;top:50%;width:30px;z-index:2}.dots{bottom:30px;right:80px;position:absolute;z-index:2}.dots .dot{border-radius:50%;background-color:transparent;box-shadow:inset 0 0 0 2px white;-webkit-transition:box-shadow 0.3s ease;transition:box-shadow 0.3s ease;cursor:pointer;display:inline-block;height:10px;margin-left:10px;width:10px}.dots .dot:hover,.dots .dot:focus{box-shadow:inset 0 0 0 2px rgba(255,255,255,0.6)}.dots .dot.sel{box-shadow:inset 0 0 0 8px white}div.alertbar{background-color:#ffc;text-align:center;display:block;padding:10px;border-bottom:solid 1px #cc9}div.alertbar .hor-bar:after{content:"|"}span.strong{font-weight:bold}.introWrapper{border-bottom:1px solid #CCC}table.intro{background:url(../images/intro-bg.gif) no-repeat center;table-layout:fixed;text-align:center;width:940px}table.intro td{background-position:center 25px;background-repeat:no-repeat;background-size:25px auto;padding:65px 0 0 0;position:relative;vertical-align:top}table.intro td.ag{background-imag
e:url(../images/agility.png)}table.intro td.fl{background-image:url(../images/flexibility.png)}table.intro td.fam{background-image:url(../images/familiarity.png)}table.intro h1{font-size:36px;font-weight:normal;margin:0;padding:0}table.intro p{font-size:16px;font-weight:lighter;line-height:22px;margin:0;padding:2px 35px 30px 35px}table.intro span{bottom:30px;display:block;position:absolute;width:100%}table.intro a{color:#1a6bc7;font-size:12px;font-weight:bold}#blu{display:table;font-size:12px;font-weight:lighter;line-height:28px;table-layout:fixed}#blu a{color:#FFF;text-decoration:none}#blu .cell{color:#FFF;display:table-cell;padding:40px 0;overflow:hidden;vertical-align:middle}#blu .cell.left{background:#1b2b3e;padding-right:54px}#blu .cell.left .wrapper{float:right}#blu .cell.right{background:#184f8d;padding-left:54px}#blu .cell.right .wrapper{float:left}#blu .cell .wrapper{width:425px}#blu h2{font-size:24px;font-weight:lighter;margin:0 0 10px 0;padding:0}.page-wrap:after{display:
block;content:""}#footer{color:black;background-color:white;font-size:9px;font-weight:lighter;line-height:20px;padding:30px 0;text-align:center}#footer,.page-wrap:after{height:60px}#footer .wrapper{padding:0 80px}.bui{display:none;position:fixed;top:0;left:0;right:0;bottom:0;background:rgba(0,0,0,0.8);z-index:4}.disclaimer{background:#f6f5f5;font-size:12px;font-weight:lighter;line-height:24px;text-align:center}.disclaimer .wrapper{margin:auto;padding:50px 0 50px 0;width:780px}.disclaimer h2{font-size:24px;font-weight:lighter;margin:0 0 10px 0;padding:0}.int_text{margin:40px auto 30px auto;width:780px}div.post.int_text{margin:40px auto 60px auto}.int_text a,.int_title a{color:#1a6bc7}.int_text p,.int_text ul,.int_text ol{font-size:16px;line-height:28px}.int_text p.l1{padding-left:30px}.int_text h2{font-size:24px;font-weight:normal;margin:30px 0 0 0}.int_text img{display:block;margin:30px auto}ul.num{list-style:decimal}.int_title{font-size:16px;font-weight:lighter;margin:auto;margin-t
op:80px;padding:0 0 15px 0;position:relative;text-align:center;width:600px}.int_title.int_title_img{background-position:center top;background-repeat:no-repeat;background-size:25px auto;padding-top:40px}.int_title.int_title_img.architecture{background-image:url(../images/architecture.png)}.int_title.int_title_img.community{background-image:url(../images/community.png)}.int_title.int_title_img.download{background-image:url(../images/download.png)}.int_title p{line-height:30px;margin:10px 0 25px 0}.int_title h1{font-size:36px;margin:20px 0px 20px 0px}.int_title:after{background:#1a6bc7;bottom:24px;content:" ";height:5px;left:275px;position:absolute;width:50px}table.intro a:before,table.intro a:after{backface-visibility:hidden;pointer-events:none}table.intro a,.int_title a{display:inline-block;overflow:hidden;outline:medium none;position:relative;text-decoration:none;vertical-align:bottom;white-space:nowrap}#header .dots,.aLeft,.aRight{display:none}p.info{background-color:#ffc;border:so
lid 1px #cc9;padding:5px}li p{margin-top:0px}.hidden{display:none}#menu .search-bar{line-height:30px;margin:0 20px 0 20px}#menu .search-bar form{border-radius:6px;border:solid 1px black;background-color:#1A6BC7}#menu .search-bar input[type='text']{border:none;color:white;background-color:transparent !important;font-size:14px;font-weight:inherit;padding:0 0 0 8px;line-height:20px;width:50px}#menu .search-bar input[placeholder]{opacity:.7}#menu .search-bar:hover{background-color:black}#menu .search-bar button[type='submit']{display:inline;border:none;background:none;position:relative;color:white;font-size:14px;cursor:pointer;width:33px}#menu .search-bar ::-webkit-input-placeholder{color:white}#menu .search-bar :-moz-placeholder{color:white}#menu .search-bar ::-moz-placeholder{color:white}#menu .search-bar :-ms-input-placeholder{color:white}.int_text table{border-collapse:collapse;border-spacing:0;empty-cells:show;border:1px solid #cbcbcb}.int_text table caption{color:#000;font-style:i
talic;padding:1em 0;text-align:center}.int_text table td,.int_text table th{border-left:1px solid #cbcbcb;border-width:0 0 0 1px;font-size:inherit;margin:0;overflow:visible;padding:.5em 1em}.int_text table td:first-child,.int_text table th:first-child{border-left-width:0}.int_text table thead{background-color:#e0e0e0;color:#000;text-align:left;vertical-align:bottom}.int_text table td{background-color:transparent}.int_text table-odd td{background-color:#f2f2f2}.int_text table-striped tr:nth-child(2n-1) td{background-color:#f2f2f2}.int_text table-bordered td{border-bottom:1px solid #cbcbcb}.int_text table-bordered tbody>tr:last-child>td{border-bottom-width:0}.int_text table-horizontal td,.int_text table-horizontal th{border-width:0 0 1px;border-bottom:1px solid #cbcbcb}.int_text table-horizontal tbody>tr:last-child>td{border-bottom-width:0}div.alertbar{line-height:1;text-align:center}div.alertbar div{display:inline-block;vertical-align:middle;padding:0 10px}div.alertbar div:nth-child(
2){border-right:solid 1px #cc9}div.alertbar div.news{font-weight:bold}div.alertbar div span{font-size:65%;color:#aa7}div.home-row{border-bottom:solid 1px #ccc;margin:0 auto;text-align:center}div.home-row div{display:inline-block;vertical-align:middle;text-align:left}div.home-row:nth-child(odd) div.big{width:300px}div.home-row:nth-child(odd) div.description{margin-left:40px;width:580px}div.home-row:nth-child(even) div.description{width:580px}div.home-row:nth-child(even) div.big{margin-left:40px;width:300px}.home-row h1{font-size:24px;margin:24px 0;font-weight:bold}.home-row h2{font-size:20px;margin:20px 0;font-weight:bold}.home-row p{font-size:16px;line-height:22px}.home-row div.small{display:none}.home-row div.big{display:inline-block}div.home-row div pre{background:#f3f5f7;color:#2a333c;border:solid 1px #aaa;font-family:Monaco,Menlo,Consolas,"Courier New",monospace;font-size:12px;line-height:1.5}div.home-row div pre span.code-underline{font-weight:bold;color:#000;text-decoration:un
derline}.int_text p a.post-link{font-size:22px}.int_text p span.post-date{font-style:italic}#menu ul li.toc-categories{display:none}#menu ul li.menu-break{display:none}.mobile-break{display:none}@media (min-width: 1025px){#menu ul li.expand-menu{display:none}}@media (max-width: 1024px){table.intro{width:940px}.mw{min-width:0px}.breadcrumbs li:first-of-type{margin-left:8px}#menu ul li.logo{padding-left:30px}#menu ul li.expand-menu{display:none}#menu ul li,#menu ul li.d{display:none}.home_txt p{width:auto}.int_title{text-align:left;width:auto;margin:80px 20px 0px 20px}.int_title:after{left:0px}.int_text{width:auto;margin:20px 10px 100px 20px}#menu.force-expand ul li,#menu.force-expand ul li.d{display:inline-block}#menu.force-expand ul li.toc-categories{display:none}#menu.force-expand ul li ul li{display:block}#menu.force-expand ul li.nav,#menu.force-expand ul li#twitter-menu-item{clear:both;margin:0 auto}#menu ul li.logo{display:block}#menu ul li.expand-menu{display:inline-block;float
:right}#menu ul br.menu-break{display:block}#menu ul li.expand-menu,#menu ul li.expand-menu a{height:50px;width:110px}#menu ul li.expand-menu span.expand-icon{font-size:24px}#menu ul li.expand-menu span.menu-text{margin-right:7px;position:relative;bottom:3px}#menu ul li.pull-right{float:right;margin-right:10px}div.post.int_text{margin:40px 20px 20px 20px}div.post .post-header .int_title{margin-left:0px}div.home-row{width:100%}div.home-row:nth-child(odd) div.small{width:300px}div.home-row:nth-child(odd) div.description{margin-left:20px;width:auto}div.home-row:nth-child(even) div.description{margin-left:20px;width:auto}div.home-row:nth-child(even) div.small{margin:0 0 15px 0;width:300px}div.home-row div.big{display:none}div.home-row div.small{display:inline-block}table.intro{width:100%;background:none}}@media (max-width: 768px){#menu.force-expand ul li.nav{clear:both;margin:0 auto}#menu.force-expand ul li.search-bar{clear:both}div.headlines.tc{margin-left:35px}br.mobile-break{display:
block}img{max-width:100%}div.int_search{width:100%}}@media (max-width: 570px){#menu.force-expand ul li.nav,#menu.force-expand ul li#twitter-menu-item{clear:both;width:100%;margin:auto}#menu.force-expand ul li{display:block}#menu ul li.clear-float{clear:both;width:0px;display:block}#menu ul li.search-bar{margin:0 11px 0 20px;float:right}#menu ul li.d{margin:10px;clear:both;float:right}#menu.force-expand{position:relative}#header .scroller .item .tc h1{font-size:40px}#header .scroller .item .tc h2{font-size:24px;line-height:32px}#header .scroller .item div.headlines.tc{margin-left:30px}div.headlines a.download-headline{font-size:.7em}#header .scroller .item div.headlines .btn{font-size:16px}div.alertbar{text-align:left;padding:0 25px}div.alertbar div{display:block;padding:10px 0}div.alertbar div:nth-child(1){border-right:none;border-bottom:solid 1px #cc9}div.alertbar div:nth-child(2){border-right:none;border-bottom:solid 1px #cc9}table.intro{width:100%;background:none}table.intro td{d
isplay:block;padding:25px 0 5px 0}table.intro td h1{font-size:24px;text-align:left;padding-left:60px}table.intro td.ag,table.intro td.fl,table.intro td.fam{background-position:20px 23%}table.intro p{font-size:16px;line-height:24px;padding:2px 25px 15px 20px;text-align:left}table.intro span{position:relative;bottom:10px;padding-left:20px;text-align:left}}.int_search{margin:50px auto 0 auto;width:780px;font-family:'PT Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif}.int_search .gsc-control-cse,.int_search .gsc-control-cse .gsc-table-result{font-family:'PT Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif}.nav-circlepop a{width:50px;height:50px}.nav-circlepop a::before{position:absolute;top:0;left:0;width:100%;height:100%;border-radius:50%;background:#fff;content:'';opacity:0;-webkit-transition:-webkit-transform 0.3s, opacity 0.3s;transition:transform 0.3s, opacity 0.3s;-webkit-transform:scale(0.9);transform:scale(0.9)}.nav-circlepop .icon-wrap{position:relative;display:block
;margin:10% 0 0 10%;width:80%;height:80%}.nav-circlepop a.next .icon-wrap{-webkit-transform:rotate(180deg);transform:rotate(180deg)}.nav-circlepop .icon-wrap::before,.nav-circlepop .icon-wrap::after{position:absolute;left:25%;width:3px;height:50%;background:#fff;content:'';-webkit-transition:-webkit-transform 0.3s, background-color 0.3s;transition:transform 0.3s, background-color 0.3s;-webkit-backface-visibility:hidden;backface-visibility:hidden}.nav-circlepop .icon-wrap::before{-webkit-transform:translateX(-50%) rotate(30deg);transform:translateX(-50%) rotate(30deg);-webkit-transform-origin:0 100%;transform-origin:0 100%}.nav-circlepop .icon-wrap::after{top:50%;-webkit-transform:translateX(-50%) rotate(-30deg);transform:translateX(-50%) rotate(-30deg);-webkit-transform-origin:0 0;transform-origin:0 0}.nav-circlepop a:hover::before{opacity:1;-webkit-transform:scale(1);transform:scale(1)}.nav-circlepop a:hover .icon-wrap::before,.nav-circlepop a:hover .icon-wrap::after{background:#4a
af4c}.nav-circlepop a:hover .icon-wrap::before{-webkit-transform:translateX(-50%) rotate(45deg);transform:translateX(-50%) rotate(45deg)}.nav-circlepop a:hover .icon-wrap::after{-webkit-transform:translateX(-50%) rotate(-45deg);transform:translateX(-50%) rotate(-45deg)}
+*{outline:none}html{height:100%}body{font-family:'PT Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;padding:0;margin:0;height:100%}.page-wrap{min-height:100%;margin-bottom:-60px}.mw{min-width:999px;width:100%}.nw{white-space:nowrap}a.anchor{display:none;font-size:0px;position:absolute;margin-top:-50px}.home_txt a.anchor{margin-top:-90px}#menu{position:fixed;top:0;width:100%;z-index:5}#menu ul{background:#051221;display:block;font-size:0px;list-style:none;overflow:hidden;padding:0;text-align:right}#menu ul li{display:inline-block;font-size:14px;margin:0;padding:0}#menu ul li.logo{float:left;padding-left:30px}#menu ul li.logo:hover{background:none}#menu ul li.logo a{background:url(../images/apachedrill.png) no-repeat center;background-size:auto 27px;display:block;height:50px;padding:0;width:80px}#menu ul li a{color:#FFF;text-decoration:none;line-height:50px;padding:14px 20px}#menu ul li.d,#menu ul li.d:hover{background-color:#4aaf4c;font-size:12px;text-transform:uppercase}#menu
ul li.d a .fam{position:relative;right:8px;font-size:14px}#menu ul li.d:hover{background-color:#348436}#menu ul li.d *{cursor:pointer}#menu ul li.d a{padding:0px 30px 0 40px;display:block}#menu ul li.l{cursor:pointer}#menu ul li.l span{background:url(../images/len.png) no-repeat center;background-size:auto 16px;display:block;line-height:50px;padding:0 20px;width:16px}#menu ul li.l.open{background-color:#145aa8}#menu ul li#twitter-menu-item{width:30px;padding-left:2px;padding-right:10px}#menu ul li#twitter-menu-item a{padding:10px}#menu ul li#twitter-menu-item img{width:22px}#menu ul li ul{background:#1a6bc7;display:none;margin:0;padding:0;position:absolute;text-align:left}#menu ul li ul li{display:block}#menu ul li ul li a{display:block;line-height:30px;padding:3px 20px}#menu ul li ul li a:hover{background:#145aa8}#menu ul li:hover{background:#1a6bc7}#menu ul li:hover ul{display:block}#menu ul li.clear-float{display:none}#subhead{background:#145aa8;color:#FFF;font-size:12px;font-we
ight:bold;height:40px;line-height:40px;left:0px;letter-spacing:1px;right:0px;position:fixed;text-align:center;text-transform:uppercase;top:10px;z-index:4;-webkit-transition:all 0.3s;transition:all 0.3s}#subhead.show{top:50px}#subhead ul{list-style:none;margin:0;padding:0}#subhead ul li{display:inline-block;list-style:none;margin:0;padding:0 35px 0 35px}#subhead ul li a{background-size:16px auto;background-position:left center;background-repeat:no-repeat;color:#FFF;display:block;padding:0 0 0 25px;text-decoration:none}#subhead ul li.ag a{background-image:url(../images/agility-w.png)}#subhead ul li.fl a{background-image:url(../images/flexibility-w.png)}#subhead ul li.fam a{background-image:url(../images/familiarity-w.png)}#header{background:url(../images/reel-bg.png) no-repeat;background-size:cover;height:300px;overflow:hidden;position:relative}#header .scroller{margin-left:0px;overflow:hidden}#header .scroller .item{float:left;height:300px;position:relative;width:100%;z-index:1}#head
er .scroller .item p a{color:#FFF;font-weight:bold;overflow:hidden;text-decoration:none;position:relative;display:inline-block;outline:none;vertical-align:bottom;text-decoration:none;white-space:nowrap}#header .scroller .item p a::before{position:absolute;top:0;left:0;z-index:-1;width:100%;height:100%;background:rgba(149,165,166,0.4);content:'';-webkit-transition:-webkit-transform 0.3s;transition:transform 0.3s;-webkit-transform:scaleY(0.618) translateX(-100%);transform:scaleY(0.618) translateX(-100%)}#header .scroller .item p a:hover::before,#header .scroller .item p a:focus::before{-webkit-transform:scaleY(0.618) translateX(0);transform:scaleY(0.618) translateX(0)}#header .scroller .item .tc{color:#FFF;margin-left:80px;position:relative;width:900px;margin:0 auto}#header .scroller .item .tc h1,#header .scroller .item .tc h2{font-size:36px;font-weight:lighter;margin:0 0 8px 0;padding:0}#header .scroller .item .tc h2{font-size:16px}#header .scroller .item .tc p{font-size:14px;font-we
ight:lighter;line-height:24px;margin:0;padding:0}#header .scroller .item .btn{background:none;border:2px solid #fff;cursor:pointer;color:#FFF;display:inline-block;font-size:12px;font-weight:bold;outline:none;margin-top:18px;position:relative;padding:5px 30px;text-decoration:none;text-transform:uppercase;-webkit-transition:all 0.3s;-moz-transition:all 0.3s;transition:all 0.3s}#header .scroller .item .btn:after{content:'';position:absolute;z-index:-1;-webkit-transition:all 0.3s;-moz-transition:all 0.3s;transition:all 0.3s}#header .scroller .item .btn-1c:after{width:0%;height:100%;top:0;left:0;background:#fff}#header .scroller .item .btn-1c:hover,#header .scroller .item .btn-1c:active{color:#0e83cd}#header .scroller .item .btn-1c:hover:after,#header .scroller .item .btn-1c:active:after{width:100%}#header .aLeft{cursor:pointer;height:30px;left:20px;margin-top:-15px;position:absolute;top:50%;width:30px;z-index:2}#header .aRight{cursor:pointer;height:30px;right:20px;margin-top:-15px;posit
ion:absolute;top:50%;width:30px;z-index:2}.dots{bottom:30px;right:80px;position:absolute;z-index:2}.dots .dot{border-radius:50%;background-color:transparent;box-shadow:inset 0 0 0 2px white;-webkit-transition:box-shadow 0.3s ease;transition:box-shadow 0.3s ease;cursor:pointer;display:inline-block;height:10px;margin-left:10px;width:10px}.dots .dot:hover,.dots .dot:focus{box-shadow:inset 0 0 0 2px rgba(255,255,255,0.6)}.dots .dot.sel{box-shadow:inset 0 0 0 8px white}div.alertbar{background-color:#ffc;text-align:center;display:block;padding:10px;border-bottom:solid 1px #cc9}div.alertbar .hor-bar:after{content:"|"}span.strong{font-weight:bold}.introWrapper{border-bottom:1px solid #CCC}table.intro{background:url(../images/intro-bg.gif) no-repeat center;table-layout:fixed;text-align:center;width:940px}table.intro td{background-position:center 25px;background-repeat:no-repeat;background-size:25px auto;padding:65px 0 0 0;position:relative;vertical-align:top}table.intro td.ag{background-imag
e:url(../images/agility.png)}table.intro td.fl{background-image:url(../images/flexibility.png)}table.intro td.fam{background-image:url(../images/familiarity.png)}table.intro h1{font-size:36px;font-weight:normal;margin:0;padding:0}table.intro p{font-size:16px;font-weight:lighter;line-height:22px;margin:0;padding:2px 35px 30px 35px}table.intro span{bottom:30px;display:block;position:absolute;width:100%}table.intro a{color:#1a6bc7;font-size:12px;font-weight:bold}#blu{display:table;font-size:12px;font-weight:lighter;line-height:28px;table-layout:fixed}#blu a{color:#FFF;text-decoration:none}#blu .cell{color:#FFF;display:table-cell;padding:40px 0;overflow:hidden;vertical-align:middle}#blu .cell.left{background:#1b2b3e;padding-right:54px}#blu .cell.left .wrapper{float:right}#blu .cell.right{background:#184f8d;padding-left:54px}#blu .cell.right .wrapper{float:left}#blu .cell .wrapper{width:425px}#blu h2{font-size:24px;font-weight:lighter;margin:0 0 10px 0;padding:0}.page-wrap:after{display:
block;content:""}#footer{color:black;background-color:white;font-size:9px;font-weight:lighter;line-height:20px;padding:30px 0;text-align:center}#footer,.page-wrap:after{height:60px}#footer .wrapper{padding:0 80px}.bui{display:none;position:fixed;top:0;left:0;right:0;bottom:0;background:rgba(0,0,0,0.8);z-index:4}.disclaimer{background:#f6f5f5;font-size:12px;font-weight:lighter;line-height:24px;text-align:center}.disclaimer .wrapper{margin:auto;padding:50px 0 50px 0;width:780px}.disclaimer h2{font-size:24px;font-weight:lighter;margin:0 0 10px 0;padding:0}.int_text{margin:40px auto 30px auto;width:780px}div.post.int_text{margin:40px auto 60px auto}.int_text a,.int_title a{color:#1a6bc7}.int_text p,.int_text ul,.int_text ol{font-size:16px;line-height:28px}.int_text p.l1{padding-left:30px}.int_text h2{font-size:24px;font-weight:normal;margin:30px 0 0 0}.int_text img{display:block;margin:30px auto}ul.num{list-style:decimal}.int_title{font-size:16px;font-weight:lighter;margin:auto;margin-t
op:80px;padding:0 0 15px 0;position:relative;text-align:center;width:600px}.int_title.int_title_img{background-position:center top;background-repeat:no-repeat;background-size:25px auto;padding-top:40px}.int_title.int_title_img.architecture{background-image:url(../images/architecture.png)}.int_title.int_title_img.community{background-image:url(../images/community.png)}.int_title.int_title_img.download{background-image:url(../images/download.png)}.int_title p{line-height:30px;margin:10px 0 25px 0}.int_title h1{font-size:36px;margin:20px 0px 20px 0px}.int_title:after{background:#1a6bc7;bottom:24px;content:" ";height:5px;left:275px;position:absolute;width:50px}table.intro a:before,table.intro a:after{backface-visibility:hidden;pointer-events:none}table.intro a,.int_title a{display:inline-block;overflow:hidden;outline:medium none;position:relative;text-decoration:none;vertical-align:bottom;white-space:nowrap}#header .dots,.aLeft,.aRight{display:none}p.info{background-color:#ffc;border:so
lid 1px #cc9;padding:5px}li p{margin-top:0px}.hidden{display:none}#menu .search-bar{line-height:30px;margin:0 20px 0 20px}#menu .search-bar form{border-radius:6px;border:solid 1px black;background-color:#1A6BC7}#menu .search-bar input[type='text']{border:none;color:white;background-color:transparent !important;font-size:14px;font-weight:inherit;padding:0 0 0 8px;line-height:20px;width:50px}#menu .search-bar input[placeholder]{opacity:.7}#menu .search-bar:hover{background-color:black}#menu .search-bar button[type='submit']{display:inline;border:none;background:none;position:relative;color:white;font-size:14px;cursor:pointer;width:33px}#menu .search-bar ::-webkit-input-placeholder{color:white}#menu .search-bar :-moz-placeholder{color:white}#menu .search-bar ::-moz-placeholder{color:white}#menu .search-bar :-ms-input-placeholder{color:white}.int_text table{border-collapse:collapse;border-spacing:0;empty-cells:show;border:1px solid #cbcbcb}.int_text table caption{color:#000;font-style:i
talic;padding:1em 0;text-align:center}.int_text table td,.int_text table th{border-left:1px solid #cbcbcb;border-width:0 0 0 1px;font-size:inherit;margin:0;overflow:visible;padding:.5em 1em}.int_text table td:first-child,.int_text table th:first-child{border-left-width:0}.int_text table thead{background-color:#e0e0e0;color:#000;text-align:left;vertical-align:bottom}.int_text table td{background-color:transparent}.int_text table-odd td{background-color:#f2f2f2}.int_text table-striped tr:nth-child(2n-1) td{background-color:#f2f2f2}.int_text table-bordered td{border-bottom:1px solid #cbcbcb}.int_text table-bordered tbody>tr:last-child>td{border-bottom-width:0}.int_text table-horizontal td,.int_text table-horizontal th{border-width:0 0 1px;border-bottom:1px solid #cbcbcb}.int_text table-horizontal tbody>tr:last-child>td{border-bottom-width:0}div.alertbar{line-height:1;text-align:center}div.alertbar div{display:inline-block;vertical-align:middle;padding:0 10px}div.alertbar div:nth-child(
2){border-right:solid 1px #cc9}div.alertbar div.news{font-weight:bold}div.alertbar div span{font-size:65%;color:#aa7}div.home-row{border-bottom:solid 1px #ccc;margin:0 auto;text-align:center}div.home-row div{display:inline-block;vertical-align:middle;text-align:left}div.home-row:nth-child(odd) div.big{width:300px}div.home-row:nth-child(odd) div.description{margin-left:40px;width:580px}div.home-row:nth-child(even) div.description{width:580px}div.home-row:nth-child(even) div.big{margin-left:40px;width:300px}.home-row h1{font-size:24px;margin:24px 0;font-weight:bold}.home-row h2{font-size:20px;margin:20px 0;font-weight:bold}.home-row p{font-size:16px;line-height:22px}.home-row div.small{display:none}.home-row div.big{display:inline-block}div.home-row div pre{background:#f3f5f7;color:#2a333c;border:solid 1px #aaa;font-family:Monaco,Menlo,Consolas,"Courier New",monospace;font-size:12px;line-height:1.5}div.home-row div pre span.code-underline{font-weight:bold;color:#000;text-decoration:un
derline}.int_text p a.post-link{font-size:22px}.int_text p span.post-date{font-style:italic}#menu ul li.toc-categories{display:none}#menu ul li.menu-break{display:none}.mobile-break{display:none}@media (min-width: 1025px){#menu ul li.expand-menu{display:none}}@media (max-width: 1024px){table.intro{width:940px}.mw{min-width:0px}.breadcrumbs li:first-of-type{margin-left:8px}#menu ul li.logo{padding-left:30px}#menu ul li.expand-menu{display:none}#menu ul li,#menu ul li.d{display:none}.home_txt p{width:auto}.int_title{text-align:left;width:auto;margin:80px 20px 0px 20px}.int_title:after{left:0px}.int_text{width:auto;margin:20px 10px 100px 20px}#menu.force-expand ul li,#menu.force-expand ul li.d{display:inline-block}#menu.force-expand ul li.toc-categories{display:none}#menu.force-expand ul li ul li{display:block}#menu.force-expand ul li.nav,#menu.force-expand ul li#twitter-menu-item{clear:both;margin:0 auto}#menu ul li.logo{display:block}#menu ul li.expand-menu{display:inline-block;float
:right}#menu ul br.menu-break{display:block}#menu ul li.expand-menu,#menu ul li.expand-menu a{height:50px;width:110px}#menu ul li.expand-menu span.expand-icon{font-size:24px}#menu ul li.expand-menu span.menu-text{margin-right:7px;position:relative;bottom:3px}#menu ul li.pull-right{float:right;margin-right:10px}div.post.int_text{margin:40px 20px 20px 20px}div.post .post-header .int_title{margin-left:0px}div.home-row{width:100%}div.home-row:nth-child(odd) div.small{width:300px}div.home-row:nth-child(odd) div.description{margin-left:20px;width:auto}div.home-row:nth-child(even) div.description{margin-left:20px;width:auto}div.home-row:nth-child(even) div.small{margin:0 0 15px 0;width:300px}div.home-row div.big{display:none}div.home-row div.small{display:inline-block}table.intro{width:100%;background:none}}@media (max-width: 768px){#menu.force-expand ul li.nav{clear:both;margin:0 auto}#menu.force-expand ul li.search-bar{clear:both}div.headlines.tc{margin-left:35px}img{max-width:100%}div.i
nt_search{width:100%}}@media (max-width: 570px){br.mobile-break{display:block}#menu.force-expand ul li.nav,#menu.force-expand ul li#twitter-menu-item{clear:both;width:100%;margin:auto}#menu.force-expand ul li{display:block}#menu ul li.clear-float{clear:both;width:0px;display:block}#menu ul li.search-bar{margin:0 11px 0 20px;float:right}#menu ul li.d{margin:10px;clear:both;float:right}#menu.force-expand{position:relative}#header .scroller .item .tc h1{font-size:40px}#header .scroller .item .tc h2{font-size:24px;line-height:32px}#header .scroller .item div.headlines.tc{margin-left:30px}div.headlines a.download-headline{font-size:.7em}#header .scroller .item div.headlines .btn{font-size:16px}div.alertbar{text-align:left;padding:0 25px}div.alertbar div{display:block;padding:10px 0}div.alertbar div:nth-child(1){border-right:none;border-bottom:solid 1px #cc9}div.alertbar div:nth-child(2){border-right:none;border-bottom:solid 1px #cc9}table.intro{width:100%;background:none}table.intro td{d
isplay:block;padding:25px 0 5px 0}table.intro td h1{font-size:24px;text-align:left;padding-left:60px}table.intro td.ag,table.intro td.fl,table.intro td.fam{background-position:20px 23%}table.intro p{font-size:16px;line-height:24px;padding:2px 25px 15px 20px;text-align:left}table.intro span{position:relative;bottom:10px;padding-left:20px;text-align:left}}.int_search{margin:50px auto 0 auto;width:780px;font-family:'PT Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif}.int_search .gsc-control-cse,.int_search .gsc-control-cse .gsc-table-result{font-family:'PT Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif}.nav-circlepop a{width:50px;height:50px}.nav-circlepop a::before{position:absolute;top:0;left:0;width:100%;height:100%;border-radius:50%;background:#fff;content:'';opacity:0;-webkit-transition:-webkit-transform 0.3s, opacity 0.3s;transition:transform 0.3s, opacity 0.3s;-webkit-transform:scale(0.9);transform:scale(0.9)}.nav-circlepop .icon-wrap{position:relative;display:block
;margin:10% 0 0 10%;width:80%;height:80%}.nav-circlepop a.next .icon-wrap{-webkit-transform:rotate(180deg);transform:rotate(180deg)}.nav-circlepop .icon-wrap::before,.nav-circlepop .icon-wrap::after{position:absolute;left:25%;width:3px;height:50%;background:#fff;content:'';-webkit-transition:-webkit-transform 0.3s, background-color 0.3s;transition:transform 0.3s, background-color 0.3s;-webkit-backface-visibility:hidden;backface-visibility:hidden}.nav-circlepop .icon-wrap::before{-webkit-transform:translateX(-50%) rotate(30deg);transform:translateX(-50%) rotate(30deg);-webkit-transform-origin:0 100%;transform-origin:0 100%}.nav-circlepop .icon-wrap::after{top:50%;-webkit-transform:translateX(-50%) rotate(-30deg);transform:translateX(-50%) rotate(-30deg);-webkit-transform-origin:0 0;transform-origin:0 0}.nav-circlepop a:hover::before{opacity:1;-webkit-transform:scale(1);transform:scale(1)}.nav-circlepop a:hover .icon-wrap::before,.nav-circlepop a:hover .icon-wrap::after{background:#4a
af4c}.nav-circlepop a:hover .icon-wrap::before{-webkit-transform:translateX(-50%) rotate(45deg);transform:translateX(-50%) rotate(45deg)}.nav-circlepop a:hover .icon-wrap::after{-webkit-transform:translateX(-50%) rotate(-45deg);transform:translateX(-50%) rotate(-45deg)}
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/data-type-conversion/index.html
----------------------------------------------------------------------
diff --git a/docs/data-type-conversion/index.html b/docs/data-type-conversion/index.html
index b704777..0120ab0 100644
--- a/docs/data-type-conversion/index.html
+++ b/docs/data-type-conversion/index.html
@@ -1325,7 +1325,7 @@ use in your Drill queries as described in this section:</p>
<h3 id="format-specifiers-for-numerical-conversions">Format Specifiers for Numerical Conversions</h3>
-<p>Use the following format specifiers for converting numbers:</p>
+<p>Use the following Java format specifiers for converting numbers:</p>
<table><thead>
<tr>
@@ -1393,7 +1393,7 @@ use in your Drill queries as described in this section:</p>
<h3 id="format-specifiers-for-date/time-conversions">Format Specifiers for Date/Time Conversions</h3>
-<p>Use the following format specifiers for date/time conversions:</p>
+<p>Use the following Joda format specifiers for date/time conversions:</p>
<table><thead>
<tr>
@@ -1541,7 +1541,7 @@ use in your Drill queries as described in this section:</p>
<ul>
<li><a href="http://docs.oracle.com/javase/7/docs/api/java/text/DecimalFormat.html">Java DecimalFormat class</a> format specifiers </li>
-<li><a href="http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html">Java DateTimeFormat class</a> format specifiers</li>
+<li><a href="http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html">Joda DateTimeFormat class</a> format specifiers</li>
</ul>
<h2 id="to_char">TO_CHAR</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/date-time-and-timestamp/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-and-timestamp/index.html b/docs/date-time-and-timestamp/index.html
index 6c94c6b..8e67441 100644
--- a/docs/date-time-and-timestamp/index.html
+++ b/docs/date-time-and-timestamp/index.html
@@ -915,42 +915,6 @@
<p>Using familiar date and time formats, listed in the <a href="/docs/data-types/data-types">SQL data types table</a>, you can construct query date and time data. You need to cast textual data to date and time data types. The format of date, time, and timestamp text in a textual data source needs to match the SQL query format for successful casting. </p>
-<p>DATE, TIME, and TIMESTAMP store values in Coordinated Universal Time (UTC). Drill supports time functions in the range 1971 to 2037.</p>
-
-<p>Currently, Drill does not support casting a TIMESTAMP with time zone, but you can use the <a href="/docs/casting/converting-data-types#to_timestamp">TO_TIMESTAMP function</a> in a query to use time stamp data having a time zone.</p>
-
-<p>Next, use the following literals in a SELECT statement. </p>
-
-<ul>
-<li><code>date</code></li>
-<li><code>time</code></li>
-<li><p><code>timestamp</code></p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT date '2010-2-15' FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2010-02-15 |
-+------------+
-1 row selected (0.083 seconds)
-
-SELECT time '15:20:30' from sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 15:20:30 |
-+------------+
-1 row selected (0.067 seconds)
-
-SELECT timestamp '2015-03-11 6:50:08' FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-03-11 06:50:08.0 |
-+------------+
-1 row selected (0.071 seconds)
-</code></pre></div></li>
-</ul>
-
<h2 id="intervalyear-and-intervalday">INTERVALYEAR and INTERVALDAY</h2>
<p>The INTERVALYEAR AND INTERVALDAY types represent a period of time. The INTERVALYEAR type specifies values from a year to a month. The INTERVALDAY type specifies values from a day to seconds.</p>
@@ -1027,6 +991,44 @@ SELECT INTERVAL '13' month FROM sys.version;
</code></pre></div>
<p>For information about casting interval data, see the <a href="/docs/data-type-conversion#cast">"CAST"</a> function.</p>
+<h2 id="date,-time,-and-timestamp">DATE, TIME, and TIMESTAMP</h2>
+
+<p>DATE, TIME, and TIMESTAMP store values in Coordinated Universal Time (UTC). Drill supports time functions in the range 1971 to 2037.</p>
+
+<p>Drill does not support TIMESTAMP with time zone; however, if your data includes the time zone, use the <a href="/docs/casting/converting-data-types#to_timestamp">TO_TIMESTAMP function</a> and <a href="/docs/data-type-conversion/#format-specifiers-for-date/time-conversions">Joda format specifiers</a> as shown the examples in section, <a href="/docs/data-type-conversion/#time-zone-limitation">"Time Zone Limitation"</a>.</p>
+
+<p>Next, use the following literals in a SELECT statement. </p>
+
+<ul>
+<li><code>date</code></li>
+<li><code>time</code></li>
+<li><p><code>timestamp</code></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT date '2010-2-15' FROM sys.version;
++------------+
+| EXPR$0 |
++------------+
+| 2010-02-15 |
++------------+
+1 row selected (0.083 seconds)
+
+SELECT time '15:20:30' from sys.version;
++------------+
+| EXPR$0 |
++------------+
+| 15:20:30 |
++------------+
+1 row selected (0.067 seconds)
+
+SELECT timestamp '2015-03-11 6:50:08' FROM sys.version;
++------------+
+| EXPR$0 |
++------------+
+| 2015-03-11 06:50:08.0 |
++------------+
+1 row selected (0.071 seconds)
+</code></pre></div></li>
+</ul>
+
<div class="doc-nav">
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/getting-to-know-the-drill-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/getting-to-know-the-drill-sandbox/index.html b/docs/getting-to-know-the-drill-sandbox/index.html
index d1ba958..aaebf6b 100644
--- a/docs/getting-to-know-the-drill-sandbox/index.html
+++ b/docs/getting-to-know-the-drill-sandbox/index.html
@@ -922,24 +922,23 @@ Welcome to your Mapr Demo virtual machine.
</code></pre></div>
<p>Using the secure shell instead of the VM interface has some advantages. You can copy/paste commands from the tutorial and avoid mouse control problems.</p>
-<p>Drill includes a shell for connecting to relational databases and executing SQL commands. On the sandbox, the Drill shell runs in embedded mode. After logging into the sandbox, use the <code>SQLLine</code> command to start SQLLine for executing Drill queries in embedded mode. </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">[mapr@maprdemo ~]# sqlline
-sqlline version 1.1.6
+<p>Drill includes a shell for connecting to relational databases and executing SQL commands. On the sandbox, the Drill shell runs in embedded mode. After logging into the sandbox, use the <code>SQLLine</code> command. The Drill shell appears, and you can run Drill queries. </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">[mapr@maprdemo ~]$ sqlline
+apache drill 1.0.0
+"the only truly happy people are children, the creative minority and drill users"
0: jdbc:drill:>
</code></pre></div>
<p>In this tutorial you query a number of data sets, including Hive and HBase, and files on the file system, such as CSV, JSON, and Parquet files. To access these diverse data sources, you connect Drill to storage plugins. </p>
<h2 id="storage-plugin-overview">Storage Plugin Overview</h2>
-<p>This section describes storage plugins included in the sandbox. For general information about Drill storage plugins, see <a href="/docs/connect-a-data-source-introduction">"Connect to a Data Source"</a>.
-Take a look at the pre-configured storage plugins for the sandbox by opening the Storage tab in the Drill Web UI. Launch a web browser and go to: <code>http://<IP address>:8047/storage</code>. For example:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">http://localhost:8047/storage
-</code></pre></div>
+<p>You use a <a href="/docs/connect-a-data-source-introduction">storage plugins</a> to connect to a data source, such as a file or the Hive metastore. Take a look at the storage plugin definitions by opening the Storage tab in the Drill Web UI. Launch a web browser and go to: <code>http://<IP address>:8047/storage</code>. </p>
+
<p>The control panel for managing storage plugins appears.</p>
<p><img src="/docs/img/get2kno_plugin.png" alt="sandbox plugin"></p>
-<p>You see that the following storage plugin controls:</p>
+<p>You see the following storage plugin controls:</p>
<ul>
<li>cp</li>
@@ -950,11 +949,9 @@ Take a look at the pre-configured storage plugins for the sandbox by opening the
<li>mongo</li>
</ul>
-<p>Click Update to look at a configuration. </p>
-
-<p>In some cases, the storage plugin defined for use in the sandbox differs from the default storage plugin of the same name in a Drill installation as described in the following sections. Typically you create a storage plugin or customize an existing one for analyzing a particular data source. </p>
+<p>Click Update to examine a configuration. </p>
-<p>The tutorial uses the dfs, hive, maprdb, and hbase storage plugins. </p>
+<p>If you've used an installation of Drill before using the sandbox, you might notice that a few storage plugins in the sandbox differ from the same storage plugin in a Drill installation. The sandbox version of dfs, hive, maprdb, and hbase storage plugins definitions play a role in simulating the cluster environment for running the tutorial. </p>
<h3 id="dfs">dfs</h3>
@@ -997,30 +994,33 @@ location in MapR-FS:</p>
"delimiter": ","
},
. . .
- "json": {
- "type": "json"
- }
+ "json": {
+ "type": "json"
+ },
+ "maprdb": {
+ "type": "maprdb"
}
-}
+ . . .
</code></pre></div>
<h3 id="maprdb">maprdb</h3>
<p>The maprdb storage plugin is a configuration for MapR-DB in the sandbox. You use this plugin in the sandbox to query HBase as well as MapR-DB data because the sandbox does not include HBase services. In addition to the following brief example, see the <a href="/docs/hbase-storage-plugin">Registering HBase</a> for more
information on how to configure Drill to query HBase.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">{
- "type" : "hbase",
- "enabled" : true,
- "config" : {
- "hbase.table.namespace.mappings" : "*:/tables"
- }
- }
+ "type": "hbase",
+ "config": {
+ "hbase.table.namespace.mappings": "*:/tables"
+ },
+ "size.calculator.enabled": false,
+ "enabled": true
+}
</code></pre></div>
<h3 id="hive">hive</h3>
<p>The hive storage plugin is a configuration for a Hive data warehouse within the sandbox.
Drill connects to the Hive metastore by using the configured metastore thrift
URI. Metadata for Hive tables is automatically available for users to query.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> {
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
"type": "hive",
"enabled": true,
"configProps": {
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/img/loginSandBox.png
----------------------------------------------------------------------
diff --git a/docs/img/loginSandBox.png b/docs/img/loginSandBox.png
index 5727ea4..07a6dfc 100644
Binary files a/docs/img/loginSandBox.png and b/docs/img/loginSandBox.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/img/vbImport.png
----------------------------------------------------------------------
diff --git a/docs/img/vbImport.png b/docs/img/vbImport.png
index a8ed45b..197f419 100644
Binary files a/docs/img/vbImport.png and b/docs/img/vbImport.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/img/vbMaprSetting.png
----------------------------------------------------------------------
diff --git a/docs/img/vbMaprSetting.png b/docs/img/vbMaprSetting.png
index b7720e3..73e0304 100644
Binary files a/docs/img/vbMaprSetting.png and b/docs/img/vbMaprSetting.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/img/vbNetwork.png
----------------------------------------------------------------------
diff --git a/docs/img/vbNetwork.png b/docs/img/vbNetwork.png
index cbb36f1..db72a7f 100644
Binary files a/docs/img/vbNetwork.png and b/docs/img/vbNetwork.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1e0ae343/docs/installing-the-apache-drill-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-apache-drill-sandbox/index.html b/docs/installing-the-apache-drill-sandbox/index.html
index 148e9c0..808bbb4 100644
--- a/docs/installing-the-apache-drill-sandbox/index.html
+++ b/docs/installing-the-apache-drill-sandbox/index.html
@@ -963,15 +963,10 @@ VMware Player or VMware Fusion:</p>
<p>If you are running VMware Fusion, select <strong>Import</strong>. </p>
<p><img src="/docs/img/vmWelcome.png" alt="drill query flow"></p></li>
-<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill file, and select <code>MapR-Sandbox-For-Apache-Drill-4.0.1_VM.ova</code>.</p>
-
-<p><img src="/docs/img/vmShare.png" alt="drill query flow"></p>
-
-<p>The Import Virtual Machine dialog appears.</p></li>
-<li><p>Click <strong>Import</strong>. The virtual machine player imports the sandbox.</p>
-
-<p><img src="/docs/img/vmLibrary.png" alt="drill query flow"></p></li>
-<li><p>Select <code>MapR-Sandbox-For-Apache-Drill-4.0.1_VM</code>, and click <strong>Play virtual machine</strong>. It takes a few minutes for the MapR services to start. </p>
+<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill file, and select <code>MapR-Sandbox-For-Apache-Drill-1.0.0-4.1.0-vmware.ova</code>.<br>
+The Import Virtual Machine dialog appears.</p></li>
+<li><p>Click <strong>Import</strong>. The virtual machine player imports the sandbox. </p></li>
+<li><p>Select <code>MapR-Sandbox-For-Apache-Drill-4.1.0_VM</code>, and click <strong>Play virtual machine</strong>. It takes a few minutes for the MapR services to start. </p>
<p>After the MapR services start and installation completes, the following screen
appears:</p>
@@ -988,10 +983,7 @@ Drill.</p></li>
</ul>
<p>For example: <code>127.0.1.1 <vm_hostname></code></p></li>
-<li><p>You can navigate to the URL provided to experience Drill Web UI or you can login to the sandbox through the command line. </p>
-
-<p>a. To navigate to the MapR Sandbox with Apache Drill, enter the provided URL in your browser's address bar.<br>
-b. To login to the virtual machine and access the command line, press Alt+F2 on Windows or Option+F5 on Mac. When prompted, enter <code>mapr</code> as the login name and password.</p></li>
+<li><p>Navigate to <a href="http://localhost:8047">localhost:8047</a> to experience the Drill Web UI, or log into the sandbox through the command line. Login using ssh as described in <a href="/docs/getting-to-know-the-drill-sandbox">"Getting to Know the Sandbox"</a>. When prompted, enter <code>mapr</code> as the login name and password. Alternatively, access the command line on the VM: Press Alt+F2 on Windows or Option+F5 on Mac. </p></li>
</ol>
<h3 id="what's-next">What's Next</h3>
@@ -1015,51 +1007,28 @@ VirtualBox:</p>
<li><p>Select <strong>File > Import Appliance</strong>. The Import Virtual Appliance dialog appears.</p>
<p><img src="/docs/img/vbImport.png" alt="drill query flow"></p></li>
-<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill and click <strong>Next</strong>. The Appliance Settings window appears.</p>
+<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill, select MapR-Sandbox-For-Apache-Drill-1.0.0-4.1.0.ova, and click <strong>Next</strong>. The Appliance Settings window appears.</p>
<p><img src="/docs/img/vbApplSettings.png" alt="drill query flow"></p></li>
<li><p>Select the check box at the bottom of the screen: <strong>Reinitialize the MAC address of all network cards</strong>, then click <strong>Import</strong>. The Import Appliance imports the sandbox.</p></li>
-<li><p>When the import completes, select <strong>File > Preferences</strong>. The VirtualBox - Settings dialog appears.</p>
+<li><p>When the import completes, select <strong>Settings</strong>. The VirtualBox - Settings dialog appears.</p>
<p><img src="/docs/img/vbNetwork.png" alt="drill query flow"></p></li>
<li><p>Select <strong>Network</strong>. </p>
<p>The correct setting depends on your network connectivity when you run the
Sandbox. In general, if you are going to use a wired Ethernet connection,
-select <strong>NAT Networks</strong> and <strong>vboxnet0</strong>. If you are going to use a wireless
-network, select <strong>Host-only Networks</strong> and the <strong>VirtualBox Host-Only Ethernet
-Adapter</strong>. If no adapters appear, click the <strong>green</strong> + <strong>button</strong> to add the
-VirtualBox adapter.</p>
+select <strong>NAT Network</strong>. If you are going to use a wireless
+network, select <strong>Host-only Networks</strong> and the <strong>Host-Only Ethernet</strong>. </p>
<p><img src="/docs/img/vbMaprSetting.png" alt="drill query flow"></p></li>
<li><p>Click <strong>OK</strong> to continue.</p></li>
-<li><p>Click Settings.</p>
-
-<p><img src="/docs/img/settings.png" alt="settings icon"><br>
-The MapR-Sandbox-For-Apache-Drill - Settings dialog appears.</p>
-
-<p><img src="/docs/img/vbGenSettings.png" alt="drill query flow"> </p></li>
-<li><p>Click <strong>OK</strong> to continue.</p></li>
<li><p>Click <strong>Start</strong>. It takes a few minutes for the MapR services to start. </p>
<p>After the MapR services start and installation completes, the following screen appears:</p>
<p><img src="/docs/img/vbloginSandBox.png" alt="drill query flow"></p></li>
-<li><p>The client must be able to resolve the actual hostname of the Drill node(s) with the IP(s). Verify that a DNS entry was created on the client machine for the Drill node(s). </p>
-
-<p>If a DNS entry does not exist, create the entry for the Drill node(s).</p>
-
-<ul>
-<li>For Windows, create the entry in the %WINDIR%\system32\drivers\etc\hosts file.</li>
-<li>For Linux and Mac, create the entry in /etc/hosts.<br>
-<drill-machine-IP> <drill-machine-hostname><br></li>
-</ul>
-
-<p>Example: <code>127.0.1.1 maprdemo</code></p></li>
-<li><p>You can navigate to the URL provided or to <a href="http://localhost:8047">localhost:8047</a> to experience the Drill Web UI, or you can log into the sandbox through the command line. </p>
-
-<p>a. To navigate to the MapR Sandbox with Apache Drill, enter the provided URL in your browser's address bar.<br>
-b. To log into the virtual machine and access the command line, enter Alt+F2 on Windows or Option+F5 on Mac. When prompted, enter <code>mapr</code> as the login name and password.</p></li>
+<li><p>Navigate to <a href="http://localhost:8047">localhost:8047</a> to experience the Drill Web UI, or log into the sandbox through the command line. Login using ssh as described in <a href="/docs/getting-to-know-the-drill-sandbox">"Getting to Know the Sandbox"</a>. When prompted, enter <code>mapr</code> as the login name and password. Alternatively, access the command line on the VM: Press Alt+F2 on Windows or Option+F5 on Mac. </p></li>
</ol>
<h3 id="what's-next">What's Next</h3>