You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/03/17 22:08:22 UTC
svn commit: r1667403 [2/5] - in /drill/site/trunk/content/drill: ./ docs/
docs/apache-drill-contribution-guidelines/ docs/apache-drill-in-10-minutes/
docs/connect-to-a-data-source/ docs/data-sources-and-file-formats/
docs/data-type-casting/ docs/date-t...
Added: drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html?rev=1667403&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html (added)
+++ drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html Tue Mar 17 21:08:21 2015
@@ -0,0 +1,122 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>HBase Storage Plugin - Apache Drill</title>
+
+<link href="/css/syntax.css" rel="stylesheet" type="text/css">
+<link href="/css/style.css" rel="stylesheet" type="text/css">
+<link href="/css/arrows.css" rel="stylesheet" type="text/css">
+<link href="/css/button.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script>
+<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script>
+<script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript" src="/js/script.js"></script>
+
+</head>
+
+<body onResize="resized();">
+
+<div class="bui"></div>
+
+<div id="search">
+<input type="text" placeholder="Enter search term here">
+</div>
+
+<div id="menu" class="mw">
+<ul>
+ <li class="logo"><a href="/"></a></li>
+ <li>
+ <a href="/overview/">Documentation</a>
+ <ul>
+ <li><a href="/overview/">Overview </a></li>
+ <li><a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes" target="_blank">Drill in 10 Minutes</a></li>
+ <li><a href="/why/">Why Drill? </a></li>
+ <li><a href="/architecture/">Architecture</a></li>
+ </ul>
+ </li>
+ <li>
+ <a href="/community/">Community</a>
+ <ul>
+ <li><a href="/team/">Team</a></li>
+ <li><a href="/community/#events">Events and Meetups</a></li>
+ <li><a href="/community/#mailinglists">Mailing Lists</a></li>
+ <li><a href="/community/#getinvolved">Get Involved</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
+ <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+ </ul>
+ </li>
+ <li><a href="/faq/">FAQ</a></li>
+ <li><a href="/blog/">Blog</a></li>
+ <li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </li>
+ <li class="l"><span> </span></li>
+ <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>HBase Storage Plugin</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Register a storage plugin instance and specify a zookeeper quorum to connect
+Drill to an HBase data source. When you register a storage plugin instance for
+an HBase data source, provide a unique name for the instance, and identify the
+type as âhbaseâ in the Drill Web UI.</p>
+
+<p>Drill supports HBase version 0.98.</p>
+
+<p>To register HBase with Drill, complete the following steps:</p>
+
+<ol>
+<li>Navigate to <a href="http://localhost:8047/">http://localhost:8047</a>, and select the <strong>Storage</strong> tab</li>
+<li>In the disabled storage plugins section, click <strong>Update</strong> next to the <code>hbase</code> instance.</li>
+<li><p>In the Configuration window, specify the Zookeeper quorum and port. </p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+ "type": "hbase",
+ "config": {
+ "hbase.zookeeper.quorum": "<zk1host,zk2host,zk3host> or <localhost>",
+ "hbase.zookeeper.property.clientPort": "2181"
+ },
+ "enabled": false
+}
+</code></pre></div></li>
+<li><p>Click <strong>Enable</strong>.</p></li>
+</ol>
+
+<p>After you configure a storage plugin instance for the HBase, you can
+issue Drill queries against it.</p>
+
+<p>In the Drill sandbox, use the <code>dfs</code> storage plugin and the <a href="/docs/mapr-db-format/">MapR-DB format</a> to query HBase files because the sandbox does not include HBase services.</p>
+</div>
+
+
+<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>
Added: drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html?rev=1667403&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html (added)
+++ drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html Tue Mar 17 21:08:21 2015
@@ -0,0 +1,173 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Hive Storage Plugin - Apache Drill</title>
+
+<link href="/css/syntax.css" rel="stylesheet" type="text/css">
+<link href="/css/style.css" rel="stylesheet" type="text/css">
+<link href="/css/arrows.css" rel="stylesheet" type="text/css">
+<link href="/css/button.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script>
+<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script>
+<script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript" src="/js/script.js"></script>
+
+</head>
+
+<body onResize="resized();">
+
+<div class="bui"></div>
+
+<div id="search">
+<input type="text" placeholder="Enter search term here">
+</div>
+
+<div id="menu" class="mw">
+<ul>
+ <li class="logo"><a href="/"></a></li>
+ <li>
+ <a href="/overview/">Documentation</a>
+ <ul>
+ <li><a href="/overview/">Overview </a></li>
+ <li><a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes" target="_blank">Drill in 10 Minutes</a></li>
+ <li><a href="/why/">Why Drill? </a></li>
+ <li><a href="/architecture/">Architecture</a></li>
+ </ul>
+ </li>
+ <li>
+ <a href="/community/">Community</a>
+ <ul>
+ <li><a href="/team/">Team</a></li>
+ <li><a href="/community/#events">Events and Meetups</a></li>
+ <li><a href="/community/#mailinglists">Mailing Lists</a></li>
+ <li><a href="/community/#getinvolved">Get Involved</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
+ <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+ </ul>
+ </li>
+ <li><a href="/faq/">FAQ</a></li>
+ <li><a href="/blog/">Blog</a></li>
+ <li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </li>
+ <li class="l"><span> </span></li>
+ <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Hive Storage Plugin</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>You can register a storage plugin instance that connects Drill to a Hive data
+source that has a remote or embedded metastore service. When you register a
+storage plugin instance for a Hive data source, provide a unique name for the
+instance, and identify the type as â<code>hive</code>â. You must also provide the
+metastore connection information.</p>
+
+<p>Drill supports Hive 1.0. To access Hive tables
+using custom SerDes or InputFormat/OutputFormat, all nodes running Drillbits
+must have the SerDes or InputFormat/OutputFormat <code>JAR</code> files in the
+<code><drill_installation_directory>/jars/3rdparty</code> folder.</p>
+
+<h2 id="hive-remote-metastore">Hive Remote Metastore</h2>
+
+<p>In this configuration, the Hive metastore runs as a separate service outside
+of Hive. Drill communicates with the Hive metastore through Thrift. The
+metastore service communicates with the Hive database over JDBC. Point Drill
+to the Hive metastore service address, and provide the connection parameters
+in the Drill Web UI to configure a connection to Drill.</p>
+
+<p><strong>Note:</strong> Verify that the Hive metastore service is running before you register the Hive metastore.</p>
+
+<p>To register a remote Hive metastore with Drill, complete the following steps:</p>
+
+<ol>
+<li><p>Issue the following command to start the Hive metastore service on the system specified in the <code>hive.metastore.uris</code>:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">hive --service metastore
+</code></pre></div></li>
+<li><p>Navigate to <a href="http://localhost:8047/">http://localhost:8047</a>, and select the <strong>Storage</strong> tab.</p></li>
+<li><p>In the disabled storage plugins section, click <strong>Update</strong> next to the <code>hive</code> instance.</p></li>
+<li><p>In the configuration window, add the <code>Thrift URI</code> and port to <code>hive.metastore.uris</code>.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+ "type": "hive",
+ "enabled": true,
+ "configProps": {
+ "hive.metastore.uris": "thrift://<localhost>:<port>",
+ "hive.metastore.sasl.enabled": "false"
+ }
+}
+</code></pre></div></li>
+<li><p>Click <strong>Enable</strong>.</p></li>
+<li><p>Verify that <code>HADOOP_CLASSPATH</code> is set in <code>drill-env.sh</code>. If you need to set the classpath, add the following line to <code>drill-env.sh</code>.</p></li>
+</ol>
+
+<p>Once you have configured a storage plugin instance for a Hive data source, you
+can <a href="/docs/querying-hive/">query Hive tables</a>.</p>
+
+<h2 id="hive-embedded-metastore">Hive Embedded Metastore</h2>
+
+<p>In this configuration, the Hive metastore is embedded within the Drill
+process. Provide the metastore database configuration settings in the Drill
+Web UI. Before you register Hive, verify that the driver you use to connect to
+the Hive metastore is in the Drill classpath located in <code>/<drill installation
+dirctory>/lib/.</code> If the driver is not there, copy the driver to <code>/<drill
+installation directory>/lib</code> on the Drill node. For more information about
+storage types and configurations, refer to <a href="https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin">"Hive Metastore Administration"</a>.</p>
+
+<p>To register an embedded Hive metastore with Drill, complete the following
+steps:</p>
+
+<ol>
+<li>Navigate to <code>[http://localhost:8047](http://localhost:8047/)</code>, and select the <strong>Storage</strong> tab</li>
+<li>In the disabled storage plugins section, click <strong>Update</strong> next to <code>hive</code> instance.</li>
+<li><p>In the configuration window, add the database configuration settings.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+ "type": "hive",
+ "enabled": true,
+ "configProps": {
+ "javax.jdo.option.ConnectionURL": "jdbc:<database>://<host:port>/<metastore database>;create=true",
+ "hive.metastore.warehouse.dir": "/tmp/drill_hive_wh",
+ "fs.default.name": "file:///",
+ }
+}
+</code></pre></div></li>
+<li><p>Click** Enable.**</p></li>
+<li><p>Verify that <code>HADOOP_CLASSPATH</code> is set in <code>drill-env.sh</code>. If you need to set the classpath, add the following line to <code>drill-env.sh</code>.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">export HADOOP_CLASSPATH=/<directory path>/hadoop/hadoop-<version-number>
+</code></pre></div></li>
+</ol>
+</div>
+
+
+<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>
Added: drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html?rev=1667403&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html (added)
+++ drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html Tue Mar 17 21:08:21 2015
@@ -0,0 +1,264 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Hive-to-Drill Data Type Mapping - Apache Drill</title>
+
+<link href="/css/syntax.css" rel="stylesheet" type="text/css">
+<link href="/css/style.css" rel="stylesheet" type="text/css">
+<link href="/css/arrows.css" rel="stylesheet" type="text/css">
+<link href="/css/button.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script>
+<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script>
+<script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript" src="/js/script.js"></script>
+
+</head>
+
+<body onResize="resized();">
+
+<div class="bui"></div>
+
+<div id="search">
+<input type="text" placeholder="Enter search term here">
+</div>
+
+<div id="menu" class="mw">
+<ul>
+ <li class="logo"><a href="/"></a></li>
+ <li>
+ <a href="/overview/">Documentation</a>
+ <ul>
+ <li><a href="/overview/">Overview </a></li>
+ <li><a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes" target="_blank">Drill in 10 Minutes</a></li>
+ <li><a href="/why/">Why Drill? </a></li>
+ <li><a href="/architecture/">Architecture</a></li>
+ </ul>
+ </li>
+ <li>
+ <a href="/community/">Community</a>
+ <ul>
+ <li><a href="/team/">Team</a></li>
+ <li><a href="/community/#events">Events and Meetups</a></li>
+ <li><a href="/community/#mailinglists">Mailing Lists</a></li>
+ <li><a href="/community/#getinvolved">Get Involved</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
+ <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+ </ul>
+ </li>
+ <li><a href="/faq/">FAQ</a></li>
+ <li><a href="/blog/">Blog</a></li>
+ <li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </li>
+ <li class="l"><span> </span></li>
+ <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Hive-to-Drill Data Type Mapping</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Using Drill you can read tables created in Hive that use data types compatible with Drill. Drill currently does not support writing Hive tables. The following table shows Drill support for Hive primitive types:
+<table>
+ <tr>
+ <th>Supported SQL Type</th>
+ <th>Hive Type</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>bigint</td>
+ <td>BIGINT</td>
+ <td>8-byte signed integer</td>
+ </tr>
+ <tr>
+ <td>boolean</td>
+ <td>BOOLEAN</td>
+ <td>TRUE (1) or FALSE (0)</td>
+ </tr>
+ <tr>
+ <td>N/A</td>
+ <td>CHAR</td>
+ <td>Same as Varchar but having a fixed-length max 255</td>
+ </tr>
+ <tr>
+ <td>date</td>
+ <td>DATE</td>
+ <td>Years months and days in the form in the form YYYY-ÂMM-ÂDD</td>
+ </tr>
+ <tr>
+ <td>decimal</td>
+ <td>DECIMAL</td>
+ <td>38-digit precision</td>
+ </tr>
+ <tr>
+ <td>float</td>
+ <td>FLOAT</td>
+ <td>4-byte single precision floating point number</td>
+ </tr>
+ <tr>
+ <td>double</td>
+ <td>DOUBLE</td>
+ <td>8-byte double precision floating point number</td>
+ </tr>
+ <tr>
+ <td>integer</td>
+ <td>INT</td>
+ <td>4-byte signed integer</td>
+ </tr>
+ <tr>
+ <td>interval</td>
+ <td>N/A</td>
+ <td>Integer fields representing a period of time depending on the type of interval</td>
+ </tr>
+ <tr>
+ <td>intervalday</td>
+ <td>N/A</td>
+ <td>Integer fields representing a day</td>
+ </tr>
+ <tr>
+ <td>intervalyear</td>
+ <td>N/A</td>
+ <td>Integer fields representing a year</td>
+ </tr>
+ <tr>
+ <td>smallint</td>
+ <td>SMALLINT</td>
+ <td>2-byte signed integer</td>
+ </tr>
+ <tr>
+ <td>time</td>
+ <td>N/A</td>
+ <td>Hours minutes seconds 24-hour basis</td>
+ </tr>
+ <tr>
+ <td>N/A</td>
+ <td>TIMESTAMP</td>
+ <td>Conventional UNIX Epoch timestamp.</td>
+ </tr>
+ <tr>
+ <td>timestamp</td>
+ <td>TIMESTAMP</td>
+ <td>JDBC timestamp in yyyy-mm-dd hh:mm:ss format</td>
+ </tr>
+ <tr>
+ <td>None</td>
+ <td>STRING</td>
+ <td>Binary string (16)</td>
+ </tr></p>
+
+<p><tr>
+ <td>varchar</td>
+ <td>VARCHAR</td>
+ <td>Character string variable length</td>
+ </tr>
+</table></p>
+
+<h2 id="unsupported-types">Unsupported Types</h2>
+
+<p>Drill does not support the following Hive types:</p>
+
+<ul>
+<li>LIST</li>
+<li>MAP</li>
+<li>STRUCT</li>
+<li>TIMESTAMP (Unix Epoch format)</li>
+<li>UNION</li>
+</ul>
+
+<p>The Hive version used in MapR supports the Hive timestamp in Unix Epoch format. Currently, the Apache Hive version used by Drill does not support this timestamp format. The workaround is to use the JDBC format for the timestamp, which Hive accepts and Drill uses, as shown in the type mapping example. The timestamp value appears in the CSV file in JDBC format: 2015-03-25 01:23:15. The Hive table defines column i as a timestamp column. The Drill extract function verifies that Drill interprets the timestamp correctly.</p>
+
+<h2 id="type-mapping-example">Type Mapping Example</h2>
+
+<p>This example demonstrates the mapping of Hive data types to Drill data types. Using a CSV that has the following contents, you create a Hive table having values of different supported types:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> 8223372036854775807,true,3.5,-1231.4,3.14,42,"SomeText",2015-03-25,2015-03-25 01:23:15
+</code></pre></div>
+<p>The example assumes that the CSV resides on the MapR file system (MapRFS) in the Drill sandbox: <code>/mapr/demo.mapr.com/data/</code></p>
+
+<p>In Hive, you define an external table using the following query:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">hive> CREATE EXTERNAL TABLE types_demo (
+ a bigint,
+ b boolean,
+ c DECIMAL(3, 2),
+ d double,
+ e float,
+ f INT,
+ g VARCHAR(64),
+ h date,
+ i timestamp
+ ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
+ LINES TERMINATED BY '\n'
+ STORED AS TEXTFILE LOCATION '/mapr/demo.mapr.com/data/mytypes.csv';
+</code></pre></div>
+<p>You check that Hive mapped the data from the CSV to the typed values as as expected:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">hive> SELECT * FROM types_demo;
+OK
+8223372036854775807 true 3.5 -1231.4 3.14 42 "SomeText" 2015-03-25 2015-03-25 01:23:15
+Time taken: 0.524 seconds, Fetched: 1 row(s)
+</code></pre></div>
+<p>In Drill, you use the Hive storage plugin that has the following definition.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+ "type": "hive",
+ "enabled": true,
+ "configProps": {
+ "hive.metastore.uris": "thrift://localhost:9083",
+ "hive.metastore.sasl.enabled": "false"
+ }
+}
+</code></pre></div>
+<p>Using the Hive storage plugin connects Drill to the Hive metastore containing the data.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> USE hive;
++------------+------------+
+| ok | summary |
++------------+------------+
+| true | Default schema changed to 'hive' |
++------------+------------+
+1 row selected (0.067 seconds)
+</code></pre></div>
+<p>The data in the Hive table shows the expected values.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> SELECT * FROM hive.`types_demo`;
++---------------------+------+------+---------+------+----+------------+------------+-----------+
+| a | b | c | d | e | f | g | h | i |
++---------------------+---------+---------+------+----+------------+------------+-----------+
+| 8223372036854775807 | true | 3.50 | -1231.4 | 3.14 | 42 | "SomeText" | 2015-03-25 | 2015-03-25 01:23:15.0 |
++---------------------+------+------+---------+------+----+------------+------------+-----------+
+1 row selected (1.262 seconds)
+</code></pre></div>
+<p>To validate that Drill interprets the timestamp in column i correctly, use the extract function to extract part of the date:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select extract(year from i) from hive.`types_demo`;
++------------+
+| EXPR$0 |
++------------+
+| 2015 |
++------------+
+1 row selected (0.387 seconds)
+</code></pre></div></div>
+
+
+<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>
Modified: drill/site/trunk/content/drill/docs/img/Hbase_Browse.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/Hbase_Browse.png?rev=1667403&r1=1667402&r2=1667403&view=diff
==============================================================================
Binary files - no diff available.
Added: drill/site/trunk/content/drill/docs/img/connect-plugin.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/connect-plugin.png?rev=1667403&view=auto
==============================================================================
Binary file - no diff available.
Propchange: drill/site/trunk/content/drill/docs/img/connect-plugin.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: drill/site/trunk/content/drill/docs/img/data-sources-schemachg.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/data-sources-schemachg.png?rev=1667403&view=auto
==============================================================================
Binary file - no diff available.
Propchange: drill/site/trunk/content/drill/docs/img/data-sources-schemachg.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: drill/site/trunk/content/drill/docs/img/datasources-json-bracket.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/datasources-json-bracket.png?rev=1667403&view=auto
==============================================================================
Binary file - no diff available.
Propchange: drill/site/trunk/content/drill/docs/img/datasources-json-bracket.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: drill/site/trunk/content/drill/docs/img/datasources-json.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/datasources-json.png?rev=1667403&view=auto
==============================================================================
Binary file - no diff available.
Propchange: drill/site/trunk/content/drill/docs/img/datasources-json.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: drill/site/trunk/content/drill/docs/img/get2kno_plugin.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/get2kno_plugin.png?rev=1667403&view=auto
==============================================================================
Binary file - no diff available.
Propchange: drill/site/trunk/content/drill/docs/img/get2kno_plugin.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: drill/site/trunk/content/drill/docs/img/json-workaround.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/json-workaround.png?rev=1667403&view=auto
==============================================================================
Binary file - no diff available.
Propchange: drill/site/trunk/content/drill/docs/img/json-workaround.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: drill/site/trunk/content/drill/docs/img/plugin-default.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/plugin-default.png?rev=1667403&view=auto
==============================================================================
Binary file - no diff available.
Propchange: drill/site/trunk/content/drill/docs/img/plugin-default.png
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Modified: drill/site/trunk/content/drill/docs/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/index.html?rev=1667403&r1=1667402&r2=1667403&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/index.html (original)
+++ drill/site/trunk/content/drill/docs/index.html Tue Mar 17 21:08:21 2015
@@ -114,6 +114,8 @@
+
+
<li><a href="/docs/core-modules-within-a-drillbit/">Core Modules within a Drillbit</a></li>
@@ -168,6 +170,8 @@
+
+
<li><a href="/docs/flexibility/">Flexibility</a></li>
@@ -379,6 +383,28 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -591,6 +617,28 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -835,6 +883,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill Sandbox</a></li>
@@ -1086,6 +1158,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/">Installing the MapR Sandbox with Apache Drill on VMware Player/VMware Fusion</a></li>
@@ -1255,6 +1351,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/apache-drill-in-10-minutes/">Apache Drill in 10 Minutes</a></li>
@@ -1384,6 +1492,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/installing-drill-on-linux/">Installing Drill on Linux</a></li>
@@ -1529,6 +1649,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -1680,12 +1812,24 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
- <li><a href="/docs/connect-to-data-sources/">Connect to Data Sources</a></li>
+ <li><a href="/docs/connect-to-a-data-source/">Connect to a Data Source</a></li>
@@ -1740,10 +1884,19 @@
+
+
<li><a href="/docs/storage-plugin-registration/">Storage Plugin Registration</a></li>
+
+
+
+ <li><a href="/docs/storage-plugin-configuration/">Storage Plugin Configuration</a></li>
+
+
+
<ul>
@@ -1797,19 +1950,23 @@
+
+
+
+
<li><a href="/docs/workspaces/">Workspaces</a></li>
- <li><a href="/docs/registering-a-file-system/">Registering a File System</a></li>
+ <li><a href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
- <li><a href="/docs/registering-hbase/">Registering HBase</a></li>
+ <li><a href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
- <li><a href="/docs/registering-hive/">Registering Hive</a></li>
+ <li><a href="/docs/hive-storage-plugin/">Hive Storage Plugin</a></li>
@@ -2004,6 +2161,26 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -2026,7 +2203,7 @@
- <li><a href="/docs/mapr-db-plugin-for-apache-drill/">MapR-DB Plugin for Apache Drill</a></li>
+ <li><a href="/docs/mapr-db-format/">MapR-DB Format</a></li>
@@ -2216,6 +2393,26 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -2342,6 +2539,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/using-the-mapr-odbc-driver-on-windows/">Using the MapR ODBC Driver on Windows</a></li>
@@ -2483,6 +2692,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/">Step 1. Install the MapR Drill ODBC Driver on Windows</a></li>
@@ -2606,6 +2827,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -2738,6 +2971,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/installing-the-mapr-drill-odbc-driver-on-linux/">Installing the MapR Drill ODBC Driver on Linux</a></li>
@@ -2879,6 +3124,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -3018,6 +3275,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -3194,7 +3463,19 @@
- <li><a href="/docs/querying-a-file-system/">Querying a File System</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/getting-started-tutorial/">Getting Started Tutorial</a></li>
@@ -3387,19 +3668,41 @@
- <li><a href="/docs/querying-json-files/">Querying JSON Files</a></li>
+
- <li><a href="/docs/querying-parquet-files/">Querying Parquet Files</a></li>
+ <li><a href="/docs/lesson-1-connect-to-data-sources/">Lesson 1: Connect to Data Sources</a></li>
- <li><a href="/docs/querying-plain-text-files/">Querying Plain Text Files</a></li>
+ <li><a href="/docs/lesson-2-query-plain-text/">Lesson 2: Query Plain Text</a></li>
- <li><a href="/docs/querying-directories/">Querying Directories</a></li>
+ <li><a href="/docs/lesson-3-create-a-storage-plugin/">Lesson 3: Create a Storage Plugin</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -3461,14 +3764,7 @@
- <li><a href="/docs/querying-hbase/">Querying HBase</a></li>
-
-
-
-
-
-
- <li><a href="/docs/querying-complex-data/">Querying Complex Data</a></li>
+ <li><a href="/docs/querying-a-file-system/">Querying a File System</a></li>
@@ -3651,28 +3947,50 @@
- <li><a href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
+
- <li><a href="/docs/query-1-selecting-flat-data/">Query 1: Selecting Flat Data</a></li>
+
- <li><a href="/docs/query-2-using-standard-sql-functions-clauses-and-joins/">Query 2: Using Standard SQL Functions, Clauses, and Joins</a></li>
+
- <li><a href="/docs/query-3-selecting-nested-data-for-a-column/">Query 3: Selecting Nested Data for a Column</a></li>
+
- <li><a href="/docs/query-4-selecting-multiple-columns-within-nested-data/">Query 4: Selecting Multiple Columns Within Nested Data</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/querying-json-files/">Querying JSON Files</a></li>
+
+
+
+ <li><a href="/docs/querying-parquet-files/">Querying Parquet Files</a></li>
+ <li><a href="/docs/querying-plain-text-files/">Querying Plain Text Files</a></li>
+
+ <li><a href="/docs/querying-directories/">Querying Directories</a></li>
+
@@ -3737,176 +4055,506 @@
- <li><a href="/docs/querying-hive/">Querying Hive</a></li>
-
-
-
-
-
-
- <li><a href="/docs/querying-the-information-schema/">Querying the INFORMATION SCHEMA</a></li>
+ <li><a href="/docs/querying-hbase/">Querying HBase</a></li>
- <li><a href="/docs/querying-system-tables/">Querying System Tables</a></li>
+ <li><a href="/docs/querying-complex-data/">Querying Complex Data</a></li>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- </ul>
-
-
-
-
- <li><a href="/docs/sql-reference/">SQL Reference</a></li>
-
-
-
- <ul>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
+
+
+
+ <li><a href="/docs/query-1-selecting-flat-data/">Query 1: Selecting Flat Data</a></li>
+
+
+
+ <li><a href="/docs/query-2-using-standard-sql-functions-clauses-and-joins/">Query 2: Using Standard SQL Functions, Clauses, and Joins</a></li>
+
+
+
+ <li><a href="/docs/query-3-selecting-nested-data-for-a-column/">Query 3: Selecting Nested Data for a Column</a></li>
+
+
+
+ <li><a href="/docs/query-4-selecting-multiple-columns-within-nested-data/">Query 4: Selecting Multiple Columns Within Nested Data</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </ul>
+
+
+
+
+ <li><a href="/docs/querying-hive/">Querying Hive</a></li>
+
+
+
+
+
+
+ <li><a href="/docs/querying-the-information-schema/">Querying the INFORMATION SCHEMA</a></li>
+
+
+
+
+
+
+ <li><a href="/docs/querying-system-tables/">Querying System Tables</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </ul>
+
+
+
+
+ <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+
+
+
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -4045,7 +4693,7 @@
- <li><a href="/docs/data-types/">Data Types</a></li>
+ <li><a href="/docs/data-type-casting/">Data Type Casting</a></li>
@@ -4276,7 +4924,33 @@
- <li><a href="/docs/supported-date-time-data-type-formats/">Supported Date/Time Data Type Formats</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/date-time-formats/">Date/Time Formats</a></li>
+
+
+
+ <li><a href="/docs/handling-disparate-data-types/">Handling Disparate Data Types</a></li>
@@ -4306,6 +4980,13 @@
+ <li><a href="/docs/lexical-structure/">Lexical Structure</a></li>
+
+
+
+
+
+
<li><a href="/docs/operators/">Operators</a></li>
@@ -4553,6 +5234,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/flatten-function/">FLATTEN Function</a></li>
@@ -4808,6 +5513,28 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) command</a></li>
@@ -4847,18 +5574,325 @@
+
+
</ul>
- <li><a href="/docs/reserved-keywords/">Reserved Keywords</a></li>
+ <li><a href="/docs/reserved-keywords/">Reserved Keywords</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </ul>
+
+
+
+
+ <li><a href="/docs/data-sources-and-file-formats/">Data Sources and File Formats</a></li>
+
+
+
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type Mapping</a></li>
+
+
+
+
+
+
+ <li><a href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive UDF</a></li>
+
+
+
+
+
+
+ <li><a href="/docs/parquet-format/">Parquet Format</a></li>
+ <li><a href="/docs/json-data-model/">JSON Data Model</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -4986,6 +6020,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/develop-a-simple-function/">Develop a Simple Function</a></li>
@@ -5174,6 +6220,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -5330,6 +6388,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/configuration-options/">Configuration Options</a></li>
@@ -5491,6 +6561,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/memory-allocation/">Memory Allocation</a></li>
@@ -5592,6 +6674,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -5718,6 +6812,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -5824,6 +6930,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
@@ -5992,6 +7110,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -6198,6 +7328,26 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release Notes</a></li>
@@ -6276,6 +7426,10 @@
+
+
+
+
</ul>
@@ -6352,6 +7506,10 @@
+
+
+
+
<li><a href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution Guidelines</a></li>
@@ -6545,6 +7703,26 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -6625,6 +7803,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/aol-search/">AOL Search</a></li>
@@ -6819,6 +8009,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -6905,6 +8107,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
<li><a href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
@@ -7103,12 +8317,24 @@
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
- <li><a href="/docs/progress-reports/">Progress Reports</a></li>
+ <li><a href="/docs/archived-pages/">Archived Pages</a></li>
@@ -7161,6 +8387,18 @@
+ <li><a href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
+
+
+
+
+
+
+ <li><a href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
+
+
+
+
@@ -7277,10 +8515,27 @@
- <li><a href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -7372,7 +8627,7 @@
- <li><a href="/docs/archived-pages/">Archived Pages</a></li>
+ <li><a href="/docs/progress-reports/">Progress Reports</a></li>
@@ -7423,17 +8678,31 @@
- <li><a href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-
-
-
+
- <li><a href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -7539,6 +8808,11 @@
+ <li><a href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
+
+
+
+
@@ -7648,6 +8922,28 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html?rev=1667403&r1=1667402&r2=1667403&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html Tue Mar 17 21:08:21 2015
@@ -124,7 +124,7 @@ The MapR-Sandbox-For-Apache-Drill-0.6.0-
<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 and password.</p></li>
+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>
</ol>
<h1 id="what's-next">What's Next</h1>
Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html?rev=1667403&r1=1667402&r2=1667403&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html Tue Mar 17 21:08:21 2015
@@ -108,7 +108,7 @@ Drill.</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 and password.</p></li>
+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>
</ol>
<h2 id="what's-next">What's Next</h2>