Repository: drill-site Updated Branches: refs/heads/asf-site 7783cd532 -> 175a8e2f9
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/175a8e2f Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/175a8e2f Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/175a8e2f Branch: refs/heads/asf-site Commit: 175a8e2f9985d6c9fb09e3cd4df5ddb6a45594da Parents: 7783cd5 Author: Tomer Shiran <[email protected]> Authored: Fri May 22 11:36:43 2015 -0700 Committer: Tomer Shiran <[email protected]> Committed: Fri May 22 11:36:43 2015 -0700 ---------------------------------------------------------------------- .../index.html | 5 +- .../index.html | 54 ++++++++----------- docs/core-modules/index.html | 1 - docs/develop-a-simple-function/index.html | 4 +- .../developing-an-aggregate-function/index.html | 23 +------- docs/drill-in-10-minutes/index.html | 57 ++++++++------------ .../index.html | 14 +++-- docs/installing-drill-on-the-cluster/index.html | 2 +- docs/installing-drill-on-windows/index.html | 4 +- docs/mapr-db-format/index.html | 4 +- .../index.html | 6 +-- docs/querying-hbase/index.html | 12 +---- docs/querying-parquet-files/index.html | 33 ++---------- .../index.html | 10 ++-- .../index.html | 2 +- docs/useful-research/index.html | 2 +- feed.xml | 11 ++-- 17 files changed, 86 insertions(+), 158 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html ---------------------------------------------------------------------- diff --git a/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html b/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html index a83f165..5a11f19 100644 --- a/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html +++ b/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html @@ -132,8 +132,9 @@ <div class="addthis_sharing_toolbox"></div> <article class="post-content"> - <p><script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script> -<a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to Calendar" class="addthisevent"> + <script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script> + +<p><a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to Calendar" class="addthisevent"> Add to Calendar <span class="_start">12-17-2014 11:30:00</span> <span class="_end">12-17-2014 12:30:00</span> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/analyzing-the-yelp-academic-dataset/index.html ---------------------------------------------------------------------- diff --git a/docs/analyzing-the-yelp-academic-dataset/index.html b/docs/analyzing-the-yelp-academic-dataset/index.html index 6b5981b..731f661 100644 --- a/docs/analyzing-the-yelp-academic-dataset/index.html +++ b/docs/analyzing-the-yelp-academic-dataset/index.html @@ -973,9 +973,9 @@ <p>Apache Drill is one of the fastest growing open source projects, with the community making rapid progress with monthly releases. The key difference is Drillâs agility and flexibility. Along with meeting the table stakes for SQL-on-Hadoop, which is to achieve low latency performance at scale, Drill allows users to analyze the data without -any ETL or up-front schema definitions. The data could be in any file format -such as text, JSON, or Parquet. Data could have simple types such as string, -integer, dates, or more complex multi-structured data, such as nested maps and +any ETL or up-front schema definitions. The data can be in any file format +such as text, JSON, or Parquet. Data can have simple types such as strings, +integers, dates, or more complex multi-structured data, such as nested maps and arrays. Data can exist in any file system, local or distributed, such as HDFS, MapR FS, or S3. Drill, has a âno schemaâ approach, which enables you to get value from your data in just a few minutes.</p> @@ -991,25 +991,17 @@ example is downloadable from <a href="http://www.yelp.com/dataset_challenge";>Yel <h3 id="step-1:-download-apache-drill-onto-your-local-machine">Step 1: Download Apache Drill onto your local machine</h3> -<p><a href="http://drill.apache.org/download/";>http://drill.apache.org/download/</a></p> +<p>To experiment with Drill locally, follow the installation instructions in <a href="/docs/drill-in-10-minutes/">Drill in 10 Minutes</a>.</p> -<p>You can also <a href="/docs/installing-drill-in-distributed-mode">in Drill in distributed mode</a> if you +<p>Alternatively, you can <a href="/docs/installing-drill-in-distributed-mode">install Drill in distributed mode</a> if you want to scale your environment.</p> -<h3 id="step-2-:-open-the-drill-tar-file">Step 2 : Open the Drill tar file</h3> -<div class="highlight"><pre><code class="language-text" data-lang="text">tar -xvf apache-drill-0.1.0.tar.gz -</code></pre></div> -<h3 id="step-3:-start-the-drill-shell.">Step 3: Start the Drill shell.</h3> -<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drill-embedded -</code></pre></div> -<p>Thatâs it! You are now ready explore the data.</p> - <p>Letâs try out some SQL examples to understand how Drill makes the raw data analysis extremely easy.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> - <p class="last">You need to substitute your local path to the Yelp data set in the FROM clause of each query you run. </p> + <p class="last">You need to substitute your local path to the Yelp data set in the angle-bracketed portion of the FROM clause of each query you run. </p> </div> <hr> @@ -1020,7 +1012,7 @@ analysis extremely easy.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> !set maxwidth 10000 0: jdbc:drill:zk=local> select * from - dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` + dfs.`<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` limit 1; +------------------------+----------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+--------------------------------+---------+--------------+-------------------+-------------+-------+-------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------------+ @@ -1040,7 +1032,7 @@ analysis extremely easy.</p> <h4 id="total-reviews-in-the-data-set">Total reviews in the data set</h4> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select sum(review_count) as totalreviews -from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json`; +from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json`; +--------------+ | totalreviews | @@ -1050,7 +1042,7 @@ from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.js </code></pre></div> <h4 id="top-states-and-cities-in-total-number-of-reviews">Top states and cities in total number of reviews</h4> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select state, city, count(*) totalreviews -from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` +from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` group by state, city order by count(*) desc limit 10; +------------+------------+--------------+ @@ -1070,7 +1062,7 @@ group by state, city order by count(*) desc limit 10; </code></pre></div> <h4 id="average-number-of-reviews-per-business-star-rating">Average number of reviews per business star rating</h4> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select stars,trunc(avg(review_count)) reviewsavg -from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` +from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` group by stars order by stars desc; +------------+------------+ @@ -1089,7 +1081,7 @@ group by stars order by stars desc; </code></pre></div> <h4 id="top-businesses-with-high-review-counts-(>-1000)">Top businesses with high review counts (> 1000)</h4> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select name, state, city, `review_count` from -dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` +dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` where review_count > 1000 order by `review_count` desc limit 10; +-------------------------------+-------------+------------+---------------+ @@ -1111,7 +1103,7 @@ where review_count > 1000 order by `review_count` desc limit 10; <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select b.name, b.hours.Saturday.`open`, b.hours.Saturday.`close` from -dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` +dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` b limit 10; +----------------------------+------------+------------+ @@ -1148,7 +1140,7 @@ the data).</p> +------------+-----------------------------------+ </code></pre></div> <p>Then, query the attributeâs data.</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select attributes from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` limit 10; +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select attributes from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` limit 10; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | attributes | @@ -1182,7 +1174,7 @@ on data.</p> <h3 id="4.-explore-the-restaurant-businesses-in-the-data-set">4. Explore the restaurant businesses in the data set</h3> <h4 id="number-of-restaurants-in-the-data-set">Number of restaurants in the data set</h4> -<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select count(*) as TotalRestaurants from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` where true=repeated_contains(categories,'Restaurants'); +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select count(*) as TotalRestaurants from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` where true=repeated_contains(categories,'Restaurants'); +------------------+ | TotalRestaurants | +------------------+ @@ -1190,7 +1182,7 @@ on data.</p> +------------------+ </code></pre></div> <h4 id="top-restaurants-in-number-of-reviews">Top restaurants in number of reviews</h4> -<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select name,state,city,`review_count` from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` where true=repeated_contains(categories,'Restaurants') order by `review_count` desc limit 10; +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select name,state,city,`review_count` from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` where true=repeated_contains(categories,'Restaurants') order by `review_count` desc limit 10; +------------------------+-------+-----------+--------------+ | name | state | city | review_count | @@ -1208,7 +1200,7 @@ on data.</p> +------------------------+-------+-----------+--------------+ </code></pre></div> <h4 id="top-restaurants-in-number-of-listed-categories">Top restaurants in number of listed categories</h4> -<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select name,repeated_count(categories) as categorycount, categories from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` where true=repeated_contains(categories,'Restaurants') order by repeated_count(categories) desc limit 10; +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select name,repeated_count(categories) as categorycount, categories from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` where true=repeated_contains(categories,'Restaurants') order by repeated_count(categories) desc limit 10; +---------------------------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------+ | name | categorycount | categories | @@ -1232,7 +1224,7 @@ on data.</p> <h4 id="top-first-categories-in-number-of-review-counts">Top first categories in number of review counts</h4> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select categories[0], count(categories[0]) as categorycount -from dfs.`/users/nrentachintala/Downloads/yelp_academic_dataset_business.json` +from dfs.`/<path-to-yelp-dataset>/yelp_academic_dataset_business.json` group by categories[0] order by count(categories[0]) desc limit 10; @@ -1255,7 +1247,7 @@ order by count(categories[0]) desc limit 10; <h4 id="take-a-look-at-the-contents-of-the-yelp-reviews-dataset.">Take a look at the contents of the Yelp reviews dataset.</h4> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select * -from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_review.json` limit 1; +from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_review.json` limit 1; +---------------------------------+------------------------+------------------------+-------+------------+----------------------------------------------------------------------+--------+------------------------+ | votes | user_id | review_id | stars | date | text | type | business_id | +---------------------------------+------------------------+------------------------+-------+------------+----------------------------------------------------------------------+--------+------------------------+ @@ -1268,9 +1260,9 @@ from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_review.json review_count to the Yelp review data, which holds additional details on each of the reviews themselves.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> Select b.name -from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` b +from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` b where b.business_id in (SELECT r.business_id -FROM dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_review.json` r +FROM dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_review.json` r GROUP BY r.business_id having sum(r.votes.cool) > 2000 order by sum(r.votes.cool) desc); +-------------------------------+ @@ -1291,7 +1283,7 @@ or distributed file system). If you want to persist the data physically instead of in a logical view, you can use CREATE TABLE AS SELECT syntax.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> create or replace view dfs.tmp.businessreviews as Select b.name,b.stars,b.state,b.city,r.votes.funny,r.votes.useful,r.votes.cool, r.`date` -from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` b, dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_review.json` r +from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` b, dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_review.json` r where r.business_id=b.business_id +------------+-----------------------------------------------------------------+ | ok | summary | @@ -1307,7 +1299,7 @@ where r.business_id=b.business_id | 1125458 | +------------+ </code></pre></div> -<p>In addition to these queries, you can get many more deeper insights using +<p>In addition to these queries, you can get many deep insights using Drillâs <a href="/docs/sql-reference">SQL functionality</a>. If you are not comfortable with writing queries manually, you can use a BI/Analytics tools such as Tableau/MicroStrategy to query raw files/Hive/HBase data or Drill-created views directly using Drill <a href="/docs/odbc-jdbc-interfaces">ODBC/JDBC @@ -1323,7 +1315,7 @@ data so you can apply even deeper SQL functionality. Here is a sample query:</p> <h4 id="get-a-flattened-list-of-categories-for-each-business">Get a flattened list of categories for each business</h4> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select name, flatten(categories) as category -from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` limit 20; +from dfs.`/<path-to-yelp-dataset>/yelp/yelp_academic_dataset_business.json` limit 20; +-----------------------------+---------------------------------+ | name | category | +-----------------------------+---------------------------------+ http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/core-modules/index.html ---------------------------------------------------------------------- diff --git a/docs/core-modules/index.html b/docs/core-modules/index.html index e76c15e..7aecda8 100644 --- a/docs/core-modules/index.html +++ b/docs/core-modules/index.html @@ -996,7 +996,6 @@ libraries to read data and operate on these sources (Serdes and UDFs).</p> through Hive if they have metadata defined there. Drill integration with Hive is only for metadata. Drill does not invoke the Hive execution engine for any requests.</p></li> -<li><p><strong>Distributed cache</strong>: Drill uses a distributed cache to manage metadata (not the data) and configuration information across various nodes. Sample metadata information that is stored in the cache includes query plan fragments, intermediate state of the query execution, and statistics. Drill uses Infinispan as its cache technology.</p></li> </ul> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/develop-a-simple-function/index.html ---------------------------------------------------------------------- diff --git a/docs/develop-a-simple-function/index.html b/docs/develop-a-simple-function/index.html index 999bf16..d1e4b19 100644 --- a/docs/develop-a-simple-function/index.html +++ b/docs/develop-a-simple-function/index.html @@ -983,7 +983,7 @@ function interface:</p> <div class="highlight"><pre><code class="language-text" data-lang="text"><dependency> <groupId>org.apache.drill.exec</groupId> <artifactId>drill-java-exec</artifactId> -<version>1.0.0-m2-incubating-SNAPSHOT</version> +<version>1.0.0</version> </dependency> </code></pre></div></li> <li><p>Create a class that implements the <code>DrillSimpleFunc</code> interface and identify the scope as <code>FunctionScope.SIMPLE</code>.</p> @@ -1005,7 +1005,7 @@ function interface:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">public void setup(RecordBatch b) { } public void eval() { - out.value = (int) (in1.value + in2.value); + out.value = in1.value + in2.value; } </code></pre></div></li> <li><p>Use the maven-source-plugin to compile the sources and classes JAR files. Verify that an empty <code>drill-module.conf</code> is included in the resources folder of the JARs.<br> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/developing-an-aggregate-function/index.html ---------------------------------------------------------------------- diff --git a/docs/developing-an-aggregate-function/index.html b/docs/developing-an-aggregate-function/index.html index f3345b3..98824e4 100644 --- a/docs/developing-an-aggregate-function/index.html +++ b/docs/developing-an-aggregate-function/index.html @@ -982,7 +982,7 @@ BIGINT. For a list of supported data types, refer to the <a href="/docs/supporte <div class="highlight"><pre><code class="language-text" data-lang="text"><dependency> <groupId>org.apache.drill.exec</groupId> <artifactId>drill-java-exec</artifactId> -<version>1.0.0-m2-incubating-SNAPSHOT</version> +<version>1.0.0</version> </dependency> </code></pre></div></li> <li><p>Create a class that implements the <code>DrillAggFunc</code> interface and identify the scope as <code>FunctionTemplate.FunctionScope.POINT_AGGREGATE</code>.</p> @@ -998,26 +998,7 @@ public static class BitCount implements DrillAggFunc{ @Workspace BitHolder value; @Output BitHolder out; </code></pre></div></li> -<li><p>Include the <code>setup(), add(), output(),</code> and <code>reset()</code> methods.</p> - -<p><strong>Example</strong> - public void setup(RecordBatch b) { - value = new BitHolder(); - value.value = 0; - }</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">@Override -public void add() { - value.value++; -} -@Override -public void output() { - out.value = value.value; -} -@Override -public void reset() { - - value.value = 0; -</code></pre></div></li> +<li><p>Include the <code>setup(), add(), output(),</code> and <code>reset()</code> methods. </p></li> <li><p>Use the maven-source-plugin to compile the sources and classes JAR files. Verify that an empty <code>drill-module.conf</code> is included in the resources folder of the JARs.<br> Drill searches this module during classpath scanning. If the file is not included in the resources folder, you can add it to the JAR file or add it to http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/drill-in-10-minutes/index.html ---------------------------------------------------------------------- diff --git a/docs/drill-in-10-minutes/index.html b/docs/drill-in-10-minutes/index.html index d875bb3..93681b3 100644 --- a/docs/drill-in-10-minutes/index.html +++ b/docs/drill-in-10-minutes/index.html @@ -1014,12 +1014,19 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode) <p>Complete the following steps to install Drill: </p> <ol> -<li><p>Issue the following command in a terminal to download the latest version of Apache Drill to a directory on your machine, or download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz";>Drill web site</a>:</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">wget http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz -</code></pre></div></li> +<li><p>In a terminal windows, change to the directory where you want to install Drill.</p></li> +<li><p>To download the latest version of Apache Drill, download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz";>Drill web site</a>or run one of the following commands, depending on which you have installed on your system:</p></li> +</ol> + +<ul> +<li><code>wget http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</code><br></li> +<li> <code>curl -o apache-drill-1.0.0.tar.gz http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</code><br></li> +</ul> + +<ol> <li><p>Copy the downloaded file to the directory where you want to install Drill. </p></li> -<li><p>Extract the contents of the Drill tar.gz file. Use sudo if necessary: </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">sudo tar -xvzf apache-drill-1.0.0.tar.gz +<li><p>Extract the contents of the Drill tar.gz file. Use sudo only if necessary: </p> +<div class="highlight"><pre><code class="language-text" data-lang="text">tar -xvzf apache-drill-1.0.0.tar.gz </code></pre></div></li> </ol> @@ -1049,7 +1056,7 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode) <p>You can install Drill on Windows 7 or 8. First, set the JAVA_HOME environment variable, and then install Drill. Complete the following steps to install Drill:</p> <ol> -<li>Click the following link to download the latest version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-0.1.0.tar.gz";>http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</a><br></li> +<li>Click the following link to download the latest version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz";>http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</a><br></li> <li>Move the <code>apache-drill-1.0.0.tar.gz</code> file to a directory where you want to install Drill.<br></li> <li>Unzip the <code>TAR.GZ</code> file using a third-party tool. If the tool you use does not unzip the TAR file as well as the <code>TAR.GZ</code> file, unzip the <code>apache-drill-1.0.0.tar</code> to extract the Drill software. The extraction process creates the installation directory named apache-drill-1.0.0 containing the Drill software. For example:<br> <img src="/docs/img/drill-directory.png" alt="drill install dir"></li> @@ -1083,7 +1090,7 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode) </code></pre></div> <h2 id="query-sample-data">Query Sample Data</h2> -<p>Your Drill installation includes a <code>sample-date</code> directory with JSON and +<p>Your Drill installation includes a <code>sample-data</code> directory with JSON and Parquet files that you can query. The local file system on your machine is configured as the <code>dfs</code> storage plugin instance by default when you install Drill in embedded mode. For more information about storage plugin @@ -1096,7 +1103,7 @@ configuration, refer to <a href="/docs/connect-a-data-source-introduction">Stora <p>A sample JSON file, <code>employee.json</code>, contains fictitious employee data.</p> <p>To view the data in the <code>employee.json</code> file, submit the following SQL query -to Drill:</p> +to Drill, using the <a href="/docs/storage-plugin-registration/">cp (classpath) storage plugin</a> to point to the file.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 3; </code></pre></div> <p>The query output is:</p> @@ -1122,24 +1129,13 @@ systems.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> - <p class="last">When you enter the query, include the version of Drill that you are currently running. </p> + <p class="last">Substitute your installation path and the Drill version in the angle-bracketed locations when you enter the query. </p> </div> <p>To view the data in the <code>region.parquet</code> file, issue the query appropriate for your operating system:</p> - -<ul> -<li><p>Linux </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/opt/drill/apache-drill-<version>/sample-data/region.parquet`; -</code></pre></div></li> -<li><p>Mac OS X</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/Users/max/drill/apache-drill-<version>/sample-data/region.parquet`; -</code></pre></div></li> -<li><p>Windows </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`C:\drill\apache-drill-<version>\sample-data\region.parquet`; -</code></pre></div></li> -</ul> - +<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`<path-to-installation>/apache-drill-<version>/sample-data/region.parquet`; +</code></pre></div> <p>The query returns the following results:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+--------------+-----------------------+ | R_REGIONKEY | R_NAME | R_COMMENT | @@ -1160,24 +1156,13 @@ systems.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> - <p class="last">When you enter the query, include the version of Drill that you are currently running. </p> + <p class="last">Substitute your installation path and the Drill version in the angle-bracketed locations when you enter the query </p> </div> <p>To view the data in the <code>nation.parquet</code> file, issue the query appropriate for your operating system:</p> - -<ul> -<li><p>Linux </p> -<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`/opt/drill/apache-drill-<version>/sample-data/nation.parquet`; -</code></pre></div></li> -<li><p>Mac OS X</p> -<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`/Users/max/drill/apache-drill-<version>/sample-data/nation.parquet`; -</code></pre></div></li> -<li><p>Windows </p> -<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`C:\drill\apache-drill-<version>\sample-data\nation.parquet`; -</code></pre></div></li> -</ul> - +<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`<path-to-installation>/apache-drill-<version>/sample-data/nation.parquet`; +</code></pre></div> <p>The query returns the following results:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`Users/khahn/drill/apache-drill-1.0.0-SNAPSHOT/sample-data/nation.parquet`; +--------------+-----------------+--------------+-----------------------+ http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/installing-drill-on-linux-and-mac-os-x/index.html ---------------------------------------------------------------------- diff --git a/docs/installing-drill-on-linux-and-mac-os-x/index.html b/docs/installing-drill-on-linux-and-mac-os-x/index.html index a9a382e..6c5d2c1 100644 --- a/docs/installing-drill-on-linux-and-mac-os-x/index.html +++ b/docs/installing-drill-on-linux-and-mac-os-x/index.html @@ -977,12 +977,16 @@ <p>Complete the following steps to install Drill: </p> <ol> -<li><p>Issue the following command in a terminal to download the latest, stable version of Apache Drill to a directory on your machine, or download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz";>Drill web site</a>:</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">wget http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz -</code></pre></div></li> +<li><p>In a terminal windows, change to the directory where you want to install Drill.</p></li> +<li><p>To download the latest version of Apache Drill, download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz";>Drill web site</a> or run one of the following commands, depending on which you have installed on your system: </p> + +<ul> +<li><code>wget http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</code><br></li> +<li> <code>curl -o apache-drill-1.0.0.tar.gz http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</code><br></li> +</ul></li> <li><p>Copy the downloaded file to the directory where you want to install Drill. </p></li> -<li><p>Extract the contents of the Drill tar.gz file. Use sudo if necessary: </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">sudo tar -xvzf apache-drill-1.0.0.tar.gz +<li><p>Extract the contents of the Drill tar.gz file. Use sudo only if necessary: </p> +<div class="highlight"><pre><code class="language-text" data-lang="text">tar -xvzf apache-drill-1.0.0.tar.gz </code></pre></div></li> </ol> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/installing-drill-on-the-cluster/index.html ---------------------------------------------------------------------- diff --git a/docs/installing-drill-on-the-cluster/index.html b/docs/installing-drill-on-the-cluster/index.html index 9baaa11..88ab217 100644 --- a/docs/installing-drill-on-the-cluster/index.html +++ b/docs/installing-drill-on-the-cluster/index.html @@ -979,7 +979,7 @@ <div class="highlight"><pre><code class="language-text" data-lang="text">curl http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz </code></pre></div></li> <li><p>Explode the tarball to the directory of your choice, such as <code>/opt</code>:</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">tar -xzvf apache-drill-0.9.0.tar.gz -C /opt +<div class="highlight"><pre><code class="language-text" data-lang="text">tar -xzvf apache-drill-1.0.0.tar.gz </code></pre></div></li> <li><p>In <code>drill-override.conf,</code> create a unique Drill <code>cluster ID</code>, and provide Zookeeper host names and port numbers to configure a connection to your Zookeeper quorum.</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/installing-drill-on-windows/index.html ---------------------------------------------------------------------- diff --git a/docs/installing-drill-on-windows/index.html b/docs/installing-drill-on-windows/index.html index c8df0bc..08c84cb 100644 --- a/docs/installing-drill-on-windows/index.html +++ b/docs/installing-drill-on-windows/index.html @@ -975,9 +975,9 @@ <p>You can install Drill on Windows 7 or 8. First, check that you <a href="/docs/embedded-mode-prerequisites">meet the prerequisites</a>, including setting the JAVA_HOME environment variable, and then install Drill. Complete the following steps to install Drill:</p> <ol> -<li>Click the following link to download the latest, stable version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-0.9.0.tar.gz";>http://getdrill.org/drill/download/apache-drill-0.1.0.tar.gz</a></li> +<li>Click the following link to download the latest, stable version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz";>http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</a></li> <li>Move the <code>apache-drill-1.0.0.tar.gz</code> file to a directory where you want to install Drill.</li> -<li>Unzip the <code>TAR.GZ</code> file using a third-party tool. If the tool you use does not unzip the TAR file as well as the <code>TAR.GZ</code> file, unzip the <code>apache-drill-0.1.0.tar</code> to extract the Drill software. The extraction process creates the installation directory named apache-drill-0.1.0 containing the Drill software. For example: +<li>Unzip the <code>TAR.GZ</code> file using a third-party tool. If the tool you use does not unzip the TAR file as well as the <code>TAR.GZ</code> file, unzip the <code>apache-drill-1.0.0.tar</code> to extract the Drill software. The extraction process creates the installation directory named apache-drill-1.0.0 containing the Drill software. For example: <img src="/docs/img/drill-directory.png" alt="drill install dir"></li> </ol> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/mapr-db-format/index.html ---------------------------------------------------------------------- diff --git a/docs/mapr-db-format/index.html b/docs/mapr-db-format/index.html index c396508..c3ba8fa 100644 --- a/docs/mapr-db-format/index.html +++ b/docs/mapr-db-format/index.html @@ -970,7 +970,7 @@ <div class="int_text" align="left"> - <p>Drill includes a <code>maprdb</code> format for MapR-DB that is defined within the + <p>The MapR-DB format is not included in apache drill release. Drill includes a <code>maprdb</code> format for MapR-DB that is defined within the default <code>dfs</code> storage plugin instance when you install Drill from the <code>mapr-drill</code> package on a MapR node. The <code>maprdb</code> format improves the estimated number of rows that Drill uses to plan a query. It also enables you to query tables like you would query files in a file system because MapR-DB @@ -988,7 +988,7 @@ query.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM mfs.`/users/max/mytable`; </code></pre></div> <p>The following image shows a portion of the configuration with the <code>maprdb</code> -format plugin for the <code>dfs</code> instance:</p> +format for the <code>dfs</code> instance:</p> <p><img src="/docs/img/18.png" alt="drill query flow"></p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/plugin-configuration-introduction/index.html ---------------------------------------------------------------------- diff --git a/docs/plugin-configuration-introduction/index.html b/docs/plugin-configuration-introduction/index.html index a428eef..8681db3 100644 --- a/docs/plugin-configuration-introduction/index.html +++ b/docs/plugin-configuration-introduction/index.html @@ -1167,13 +1167,11 @@ The storage plugin definition as you would enter it in the Web UI.</p></li> </code></pre></div> <h2 id="bootstrapping-a-storage-plugin">Bootstrapping a Storage Plugin</h2> -<p>Bootstrapping a storage plugin works only when the first drillbit in the cluster first starts up. After startup, you have to use the REST API or Drill Web UI. If you need to add a storage plugin to Drill and do not want to use a web browser, you can create a <a href="https://github.com/apache/drill/blob/master/contrib/storage-hbase/src/main/resources/bootstrap-storage-plugins.json";>bootstrap-storage-plugins.json</a> file and include it on the classpath when starting Drill. The storage plugin loads when Drill starts up.</p> - <p>If you need to add a storage plugin to Drill and do not want to use a web browser, you can create a <a href="https://github.com/apache/drill/blob/master/contrib/storage-hbase/src/main/resources/bootstrap-storage-plugins.json";>bootstrap-storage-plugins.json</a> file and include it on the classpath when starting Drill. The storage plugin loads when Drill starts up.</p> -<p>If you configure an HBase storage plugin using bootstrap-storage-plugins.json file and HBase is not install, you might experience a delay when executing the queries. Configure the <a href="http://hbase.apache.org/book.html#config.files";>HBase client timeout</a> and retry settings in the config block of HBase plugin instance configuration.</p> +<p>Bootstrapping a storage plugin works only when the first drillbit in the cluster first starts up. After cluster startup, you have to use the REST API or Drill Web UI to add a storage plugin. </p> -<p>If you configure an HBase storage plugin using bootstrap-storage-plugins.json file and HBase is not install, you might experience a delay when executing the queries. Configure the <a href="http://hbase.apache.org/book.html#config.files";>HBase client timeout</a> and retry settings in the config block of HBase plugin instance configuration.</p> +<p>If you configure an HBase storage plugin using bootstrap-storage-plugins.json file and HBase is not installed, you might experience a delay when executing the queries. Configure the <a href="http://hbase.apache.org/book.html#config.files";>HBase client timeout</a> and retry settings in the config block of HBase plugin instance configuration.</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/querying-hbase/index.html ---------------------------------------------------------------------- diff --git a/docs/querying-hbase/index.html b/docs/querying-hbase/index.html index d80b348..a229fc7 100644 --- a/docs/querying-hbase/index.html +++ b/docs/querying-hbase/index.html @@ -970,9 +970,7 @@ <div class="int_text" align="left"> - <p>This exercise creates two tables in HBase, students and clicks, that you can query with Drill. As an HBase user, you most likely are running Drill in distributed mode, in which Drill might start as a service. If you are not an HBase user and just kicking the tires, you might use the Drill Sandbox on a single-node cluster (embedded mode). In this case, you need to <a href="/docs/install-drill/">start Drill</a> before performing step 5 of this exercise. On the Drill Sandbox, HBase tables you create will be located in: <code>/mapr/demo.mapr.com/tables</code></p> - -<p>You use the CONVERT_TO and CONVERT_FROM functions to convert binary text to readable output. You use the CAST function to convert the binary INT to readable output in step 4 of <a href="/docs/querying-hbase/#query-hbase-tables">Query HBase Tables</a>. When converting an INT or BIGINT number, having a byte count in the destination/source that does not match the byte count of the number in the VARBINARY source/destination, use CAST.</p> + <p>This exercise creates two tables in HBase, students and clicks, that you can query with Drill. You use the CONVERT_TO and CONVERT_FROM functions to convert binary text to readable output. You use the CAST function to convert the binary INT to readable output in step 4 of <a href="/docs/querying-hbase/#query-hbase-tables">Query HBase Tables</a>. When converting an INT or BIGINT number, having a byte count in the destination/source that does not match the byte count of the number in the VARBINARY source/destination, use CAST.</p> <h2 id="create-the-hbase-tables">Create the HBase tables</h2> @@ -1053,16 +1051,8 @@ put 'clicks','click9','iteminfo:quantity','10' <li><p>Issue the following command to put the data into hbase: </p> <div class="highlight"><pre><code class="language-text" data-lang="text">cat testdata.txt | hbase shell </code></pre></div></li> -<li><p>In Drill, use the <a href="/docs/mapr-db-format">MapR-DB format plugin</a>, if you are using the Drill Sandbox; otherwise, enable and use the hbase storage plugin on a system having HBase services. </p> - -<ul> -<li>USE hbase; /* If you have installed HBase services. */<br></li> -<li>USE maprdb; /* If you are using the Drill Sandbox */</li> -</ul></li> </ol> -<p>The <code>maprdb</code> format plugin provides access to the <code>/tables</code> directory. Use Drill to query the students and clicks tables on the Drill Sandbox. </p> - <h2 id="query-hbase-tables">Query HBase Tables</h2> <ol> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/querying-parquet-files/index.html ---------------------------------------------------------------------- diff --git a/docs/querying-parquet-files/index.html b/docs/querying-parquet-files/index.html index 804fede..ed87a68 100644 --- a/docs/querying-parquet-files/index.html +++ b/docs/querying-parquet-files/index.html @@ -985,21 +985,9 @@ that you can query. Use SQL syntax to query the <code>region.parquet</code> and <h2 id="region-file">Region File</h2> -<p>To view the data in the <code>region.parquet</code> file, issue the query appropriate for -your operating system:</p> - -<ul> -<li><p>Linux </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/opt/drill/apache-drill-1.0.0/sample-data/region.parquet`; -</code></pre></div></li> -<li><p>Mac OS X </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/Users/max/drill/apache-drill-1.0.0/sample-data/region.parquet`; -</code></pre></div></li> -<li><p>Windows </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`C:\drill\apache-drill-1.0.0\sample-data\region.parquet`; -</code></pre></div></li> -</ul> - +<p>To view the data in the <code>region.parquet</code> file, issue the following query:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`<path-to-installation>/apache-drill-<version>\sample-data\region.parquet`; +</code></pre></div> <p>The query returns the following results:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+--------------+-----------------------+ | R_REGIONKEY | R_NAME | R_COMMENT | @@ -1020,19 +1008,8 @@ systems.</p> <p>To view the data in the <code>nation.parquet</code> file, issue the query appropriate for your operating system:</p> - -<ul> -<li><p>Linux </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/opt/drill/apache-drill-1.0.0/sample-data/nation.parquet`; -</code></pre></div></li> -<li><p>Mac OS X </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/Users/max/drill/apache-drill-1.0.0-incubating/sample-data/nation.parquet`; -</code></pre></div></li> -<li><p>Windows </p> -<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`C:\drill\apache-drill-1.0.0-incubating\sample-data\nation.parquet`; -</code></pre></div></li> -</ul> - +<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`<path-to-installation>/apache-drill-<version>/apache-drill-1.0.0/sample-data/nation.parquet`; +</code></pre></div> <p>The query returns the following results:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+-----------------+--------------+-----------------------+ | N_NATIONKEY | N_NAME | N_REGIONKEY | N_COMMENT | http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/starting-drill-in-distributed-mode/index.html ---------------------------------------------------------------------- diff --git a/docs/starting-drill-in-distributed-mode/index.html b/docs/starting-drill-in-distributed-mode/index.html index f1e2e42..9132133 100644 --- a/docs/starting-drill-in-distributed-mode/index.html +++ b/docs/starting-drill-in-distributed-mode/index.html @@ -1013,11 +1013,11 @@ Opens the Drill shell using a connection to the ZooKeeper running on the local h </ol> <p>Drill provides a list of Drillbits that are running.</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">+----------------+--------------+--------------+--------------------+ -| host | user_port | control_port | data_port | -+----------------+--------------+--------------+--------------------+ -| <host address> | <port number>| <port number>| <port number> | -+----------------+--------------+--------------+--------------------+ +<div class="highlight"><pre><code class="language-text" data-lang="text">+----------------+---------------+---------------+---------------+-----------+ +| hostname | user_port | control_port | data_port | current | ++----------------+---------------+---------------+---------------+-----------+ +| <host address> | <port number> | <port number> | <port number> | <boolean> | ++----------------+---------------+---------------+---------------+-----------+ </code></pre></div> <p>Now you can run queries. The Drill installation includes sample data that you can query. Refer to <a href="/docs/querying-parquet-files/">Querying Parquet Files</a>.</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/starting-drill-on-linux-and-mac-os-x/index.html ---------------------------------------------------------------------- diff --git a/docs/starting-drill-on-linux-and-mac-os-x/index.html b/docs/starting-drill-on-linux-and-mac-os-x/index.html index 7da4350..c59ef31 100644 --- a/docs/starting-drill-on-linux-and-mac-os-x/index.html +++ b/docs/starting-drill-on-linux-and-mac-os-x/index.html @@ -987,7 +987,7 @@ <p>At this point, you can <a href="/docs/query-data">run queries</a>.</p> -<p>You can also use the <strong>sqlline</strong> command to start Drill using a custom connection string, as described in <a href="docs/starting-drill-in-distributed-mode/#using-an-ad-hoc-connection-to-drill">"Using an Ad-Hoc Connection to Drill"</a>. For example, you can specify the storage plugin when you start the shell. Doing so eliminates the need to specify the storage plugin in the query: For example, this command specifies the <code>dfs</code> storage plugin.</p> +<p>You can also use the <strong>sqlline</strong> command to start Drill using a custom connection string, as described in <a href="/docs/starting-drill-in-distributed-mode/#using-an-ad-hoc-connection-to-drill">"Using an Ad-Hoc Connection to Drill"</a>. For example, you can specify the storage plugin when you start the shell. Doing so eliminates the need to specify the storage plugin in the query: For example, this command specifies the <code>dfs</code> storage plugin.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline âu jdbc:drill:schema=dfs;zk=local </code></pre></div> <h2 id="exiting-the-drill-shell">Exiting the Drill Shell</h2> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/docs/useful-research/index.html ---------------------------------------------------------------------- diff --git a/docs/useful-research/index.html b/docs/useful-research/index.html index 06b9cd2..f6f388c 100644 --- a/docs/useful-research/index.html +++ b/docs/useful-research/index.html @@ -1021,7 +1021,7 @@ <li><a href="https://github.com/rgrzywinski/field-stripe/";>https://github.com/rgrzywinski/field-stripe/</a></li> </ul> -Code generation / Physical plan generation</h2> +<h2 id="code-generation-/-physical-plan-generation">Code generation / Physical plan generation</h2> <ul> <li><a href="http://www.vldb.org/pvldb/vol4/p539-neumann.pdf";>http://www.vldb.org/pvldb/vol4/p539-neumann.pdf</a> (SLIDES: <a href="http://www.vldb.org/2011/files/slides/research9/rSession9-3.pdf";>http://www.vldb.org/2011/files/slides/research9/rSession9-3.pdf</a>)</li> http://git-wip-us.apache.org/repos/asf/drill-site/blob/175a8e2f/feed.xml ---------------------------------------------------------------------- diff --git a/feed.xml b/feed.xml index 3f4030d..6013ef1 100644 --- a/feed.xml +++ b/feed.xml @@ -6,9 +6,9 @@ </description> <link>/</link> <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/> - <pubDate>Thu, 21 May 2015 16:35:17 -0700</pubDate> - <lastBuildDate>Thu, 21 May 2015 16:35:17 -0700</lastBuildDate> - <generator>Jekyll v2.5.2</generator> + <pubDate>Fri, 22 May 2015 11:31:14 -0700</pubDate> + <lastBuildDate>Fri, 22 May 2015 11:31:14 -0700</lastBuildDate> + <generator>Jekyll v2.5.1</generator> <item> <title>The Apache Software Foundation Announces Apache Drill 1.0</title> @@ -444,8 +444,9 @@ Tomer Shiran</p> <item> <title>Apache Drill Q&A Panelist Spotlight</title> - <description><p><script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script> -<a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to Calendar" class="addthisevent"> + <description><script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script> + +<p><a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to Calendar" class="addthisevent"> Add to Calendar <span class="_start">12-17-2014 11:30:00</span> <span class="_end">12-17-2014 12:30:00</span>
