This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 5af7e4f Website update.
5af7e4f is described below
commit 5af7e4fed682bd2d3972e3034b78ebdc020500a5
Author: James Turton <[email protected]>
AuthorDate: Fri Jun 18 14:50:25 2021 +0200
Website update.
---
.../09/running-sql-queries-on-amazon-s3/index.html | 260 +++++++++++++++++++++
blog/index.html | 4 +-
docs/apache-drill-1-19-0-release-notes/index.html | 2 +-
docs/configuring-storage-plugins/index.html | 2 +-
docs/hdf5-format-plugin/index.html | 2 +-
docs/ip-networking-functions/index.html | 28 +--
feed.xml | 68 +++---
7 files changed, 313 insertions(+), 53 deletions(-)
diff --git a/blog/2018/02/09/running-sql-queries-on-amazon-s3/index.html
b/blog/2018/02/09/running-sql-queries-on-amazon-s3/index.html
new file mode 100644
index 0000000..d30c0fc
--- /dev/null
+++ b/blog/2018/02/09/running-sql-queries-on-amazon-s3/index.html
@@ -0,0 +1,260 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+<meta name=viewport content="width=device-width, initial-scale=1">
+
+
+<title>Running SQL Queries on Amazon S3 - Apache Drill</title>
+
+<link
href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"
rel="stylesheet" type="text/css"/>
+<link href='//fonts.googleapis.com/css?family=PT+Sans' rel='stylesheet'
type='text/css'/>
+<link href="/css/site.css" rel="stylesheet" type="text/css"/>
+
+<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/>
+<link rel="icon" href="/favicon.ico" type="image/x-icon"/>
+
+<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"
language="javascript" type="text/javascript"></script>
+<script
src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js"
language="javascript" type="text/javascript"></script>
+<script language="javascript" type="text/javascript"
src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript"
src="/js/script.js"></script>
+<script language="javascript" type="text/javascript"
src="/js/drill.js"></script>
+
+</head>
+
+
+<body onResize="resized();">
+ <div class="page-wrap">
+ <div class="bui"></div>
+
+<div id="menu" class="mw">
+<ul>
+ <li class='toc-categories'>
+ <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa
fa-bars"></i></a>
+ </li>
+ <li class="logo"><a href="/"></a></li>
+ <li class='expand-menu'>
+ <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span
class='expand-icon'><i class="fa fa-bars"></i></span></a>
+ </li>
+ <li class='clear-float'></li>
+ <li class="apache-link">
+ <a href="/apacheASF/">Apache</a>
+ </li>
+ <li class="poweredby">
+ <a href="/poweredBy">Powered By</a>
+ </li>
+ <li class="documentation-menu">
+ <a href="/docs/">Documentation</a>
+ <ul>
+
+ <li><a href="/docs/getting-started/">Getting Started</a></li>
+
+ <li><a href="/docs/architecture/">Architecture</a></li>
+
+ <li><a href="/docs/tutorials/">Tutorials</a></li>
+
+ <li><a href="/docs/drill-on-yarn/">Drill-on-YARN</a></li>
+
+ <li><a href="/docs/install-drill/">Install Drill</a></li>
+
+ <li><a href="/docs/configure-drill/">Configure Drill</a></li>
+
+ <li><a href="/docs/connect-a-data-source/">Connect a Data
Source</a></li>
+
+ <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
+
+ <li><a href="/docs/query-data/">Query Data</a></li>
+
+ <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
+ <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+
+ <li><a href="/docs/data-sources-and-file-formats/">Data Sources and
File Formats</a></li>
+
+ <li><a href="/docs/develop-custom-functions/">Develop Custom
Functions</a></li>
+
+ <li><a href="/docs/troubleshooting/">Troubleshooting</a></li>
+
+ <li><a href="/docs/developer-information/">Developer
Information</a></li>
+
+ <li><a href="/docs/release-notes/">Release Notes</a></li>
+
+ <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
+
+ <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+
+ <li><a href="/docs/ecosystem/">Ecosystem</a></li>
+
+ </ul>
+ </li>
+ <li class='nav'>
+ <a href="/community-resources/">Community</a>
+ <ul>
+ <li><a href="/team/">Team</a></li>
+ <li><a href="/mailinglists/">Mailing Lists</a></li>
+ <li><a href="/community-resources/">Community Resources</a></li>
+ </ul>
+ </li>
+ <li class='nav'><a href="/faq/">FAQ</a></li>
+ <li class='nav'><a href="/blog/">Blog</a></li>
+ <li class="social-menu-item"><a href="https://twitter.com/apachedrill";
title="apachedrill on twitter" target="_blank"><img
src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a>
</li>
+ <li class="social-menu-item"><a
href="https://join.slack.com/t/apache-drill/shared_invite/enQtNTQ4MjM1MDA3MzQ2LTJlYmUxMTRkMmUwYmQ2NTllYmFmMjU4MDk0NjYwZjBmYjg0MDZmOTE2ZDg0ZjBlYmI3Yjc4Y2I2NTQyNGVlZTc";
title="Apache Drill Slack channels"
+ target="_blank"><img src="/images/slack-logo.svg" alt="Slack logo"
align="center"></a> </li>
+ <li class='search-bar'>
+ <form id="drill-search-form">
+ <input type="text" placeholder="Search Apache Drill"
id="drill-search-term" />
+ <button type="submit">
+ <i class="fa fa-search"></i>
+ </button>
+ </form>
+ </li>
+ <li class="d">
+ <a href="/download/">
+ <i class="fa fa-cloud-download"></i> Download
+ </a>
+ </li>
+</ul>
+</div>
+
+ <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+<div class="post int_text">
+ <header class="post-header">
+ <div class="int_title">
+ <h1 class="post-title">Running SQL Queries on Amazon S3</h1>
+ </div>
+ <p class="post-meta">
+
+
+
+ <strong>Author:</strong> Nick Amato (Director, Technical Marketing, MapR
Technologies)<br />
+
+<strong>Date:</strong> Feb 9, 2018
+</p>
+ </header>
+ <div class="addthis_sharing_toolbox"></div>
+
+ <article class="post-content">
+ <p>The functionality and sheer usefulness of Drill is growing fast. If
you’re a user of some of the popular BI tools out there like Tableau or SAP
Lumira, now is a good time to take a look at how Drill can make your life
easier, especially if you’re faced with the task of quickly getting a handle
on large sets of unstructured data. With schema generated on the fly, you can
save a lot of time and headaches by running SQL queries on the data where it
rests without knowing much about [...]
+
+<p>If you’re more of a visual person, you can skip this article entirely and
<a href="https://www.youtube.com/watch?v=w8gZ2nn_ZUQ";>go straight to a
video</a> I put together that walks through an end-to-end example with Tableau.
This example is easily extended to other BI tools, as the steps are identical
on the Drill side.</p>
+
+<p>At a high level, configuring Drill to access S3 bucket data is accomplished
with the following steps on each node running a drillbit.</p>
+
+<ul>
+ <li>Download and install the <a href="http://www.jets3t.org/";>JetS3t</a> JAR
files and enable them.</li>
+ <li>Add your S3 credentials in the relevant XML configuration file.</li>
+ <li>Configure and enable the S3 storage plugin through the Drill web
interface.</li>
+ <li>Connect your BI tool of choice and query away.</li>
+</ul>
+
+<p>Consult the <a
href="https://cwiki.apache.org/confluence/display/DRILL/Architectural+Overview";>Architectural
Overview</a> for a refresher on the architecture of Drill.</p>
+
+<h2 id="prerequisites">Prerequisites</h2>
+
+<p>These steps assume you have a <a
href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes";>typical
Drill cluster and ZooKeeper quorum</a> configured and running. To access data
in S3, you will need an S3 bucket configured and have the required Amazon
security credentials in your possession. An <a
href="http://blogs.aws.amazon.com/security/post/Tx1R9KDN9ISZ0HF/Where-s-my-secret-access-key";>Amazon
blog post</a> has more information on how to get these from yo [...]
+
+<h2 id="configuration-steps">Configuration Steps</h2>
+
+<p>To connect Drill to S3, all of the drillbit nodes will need to access code
in the JetS3t library developed by Amazon. As of this writing, 0.9.2 is the
latest version but you might want to check <a
href="https://jets3t.s3.amazonaws.com/toolkit/toolkit.html";>the main page</a>
to see if anything has been updated. Be sure to get version 0.9.2 or later as
earlier versions have a bug relating to reading Parquet data.</p>
+
+<div class="language-bash highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>wget
http://bitbucket.org/jmurty/jets3t/downloads/jets3t-0.9.2.zip
+<span class="nb">cp </span>jets3t-0.9.2/jars/jets3t-0.9.2.jar <span
class="nv">$DRILL_HOME</span>/jars/3rdparty
+</code></pre></div></div>
+
+<p>Next, enable the plugin by editing the file:</p>
+
+<div class="language-bash highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span
class="nv">$DRILL_HOME</span>/bin/hadoop_excludes.txt
+</code></pre></div></div>
+
+<p>and removing the line <code class="language-plaintext
highlighter-rouge">jets3t</code>.</p>
+
+<p>Drill will need to know your S3 credentials in order to access data there.
These credentials will need to be placed in the core-site.xml file for your
installation. If you already have a core-site.xml file configured for your
environment, add the following parameters to it, otherwise create the file from
scratch. If you do end up creating it from scratch you will need to wrap these
parameters with <code class="language-plaintext
highlighter-rouge"><configuration></code> and <c [...]
+
+<div class="language-xml highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="nt"><property></span>
+ <span class="nt"><name></span>fs.s3.awsAccessKeyId<span
class="nt"></name></span>
+ <span class="nt"><value></span>ID<span class="nt"></value></span>
+<span class="nt"></property></span>
+
+<span class="nt"><property></span>
+ <span class="nt"><name></span>fs.s3.awsSecretAccessKey<span
class="nt"></name></span>
+ <span class="nt"><value></span>SECRET<span
class="nt"></value></span>
+<span class="nt"></property></span>
+
+<span class="nt"><property></span>
+ <span class="nt"><name></span>fs.s3n.awsAccessKeyId<span
class="nt"></name></span>
+ <span class="nt"><value></span>ID<span class="nt"></value></span>
+<span class="nt"></property></span>
+
+<span class="nt"><property></span>
+ <span class="nt"><name></span>fs.s3n.awsSecretAccessKey<span
class="nt"></name></span>
+ <span class="nt"><value></span>SECRET<span
class="nt"></value></span>
+<span class="nt"></property></span>
+</code></pre></div></div>
+
+<p>The steps so far give Drill enough information to connect to the S3
service. Remember, you have to do this on all the nodes running drillbit.</p>
+
+<p>Next, let’s go into the Drill web interface and enable the S3 storage
plugin. In this case you only need to connect to <strong>one</strong> of the
nodes because Drill’s configuration is synchronized across the cluster.
Complete the following steps:</p>
+
+<ol>
+ <li>Point your browser to <code class="language-plaintext
highlighter-rouge">http://<host>:8047</code></li>
+ <li>Select the ‘Storage’ tab.</li>
+ <li>A good starting configuration for S3 can be entirely the same as the
<code class="language-plaintext highlighter-rouge">dfs</code> plugin, except
the connection parameter is changed to <code class="language-plaintext
highlighter-rouge">s3n://bucket</code>. So first select the <code
class="language-plaintext highlighter-rouge">Update</code> button for <code
class="language-plaintext highlighter-rouge">dfs</code>, then select the text
area and copy it into the clipboard (on Windows, [...]
+ <li>Press <code class="language-plaintext highlighter-rouge">Back</code>,
then create a new plugin by typing the name into the <code
class="language-plaintext highlighter-rouge">New Storage Plugin</code>, then
press <code class="language-plaintext highlighter-rouge">Create</code>. You
can choose any name, but a good convention is to use <code
class="language-plaintext highlighter-rouge">s3-<bucketname></code> so
you can easily identify it later.</li>
+ <li>In the configuration area, paste the configuration you just grabbed from
‘dfs’. Change the line <code class="language-plaintext
highlighter-rouge">connection: "file:///"</code> to <code
class="language-plaintext highlighter-rouge">connection:
"s3n://<bucket>"</code>.</li>
+ <li>Click <code class="language-plaintext highlighter-rouge">Update</code>.
You should see a message that indicates success.</li>
+</ol>
+
+<p>Note: Make sure the URI has scheme “s3n”, not “s3”. It will not work with
“s3”.</p>
+
+<p>At this point you can run queries on the data directly and you have a
couple of options on how you want to access it. You can use Drill Explorer and
create a custom view (based on an SQL query) that you can then access in
Tableau or other BI tools, or just use Drill directly from within the tool.</p>
+
+<p>You may want to check out the <a
href="http://www.youtube.com/watch?v=jNUsprJNQUg";>Tableau demo</a>.</p>
+
+<p>With just a few lines of configuration, you’ve just opened the vast world
of data available in the Amazon cloud and reduced the amount of work you have
to do in advance to access data stored there with SQL. There are even some <a
href="https://aws.amazon.com/datasets";>public datasets</a> available directly
on S3 that are great for experimentation.</p>
+
+<p>Happy Drilling!</p>
+
+ </article>
+ <div id="disqus_thread"></div>
+ <script type="text/javascript">
+ /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE
* * */
+ var disqus_shortname = 'drill'; // required: replace example with your
forum shortname
+
+ /* * * DON'T EDIT BELOW THIS LINE * * */
+ (function() {
+ var dsq = document.createElement('script'); dsq.type =
'text/javascript'; dsq.async = true;
+ dsq.src = '//' + disqus_shortname + '.disqus.com/embed.js';
+ (document.getElementsByTagName('head')[0] ||
document.getElementsByTagName('body')[0]).appendChild(dsq);
+ })();
+ </script>
+ <noscript>Please enable JavaScript to view the <a
href="http://disqus.com/?ref_noscript";>comments powered by
Disqus.</a></noscript>
+
+</div>
+<script type="text/javascript"
src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-548b2caa33765e8d"
async="async"></script>
+
+ </div>
+ <p class="push"></p>
+<div id="footer" class="mw">
+<div class="wrapper">
+Copyright © 2012-2020 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>
+<script type="text/javascript"
src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-548b2caa33765e8d"
async="async"></script>
+</body>
+</html>
diff --git a/blog/index.html b/blog/index.html
index 55fe2a0..44744f0 100644
--- a/blog/index.html
+++ b/blog/index.html
@@ -181,8 +181,8 @@ by Bridget Bevens</span>
by Bridget Bevens</span>
<br/>Apache Drill 1.13's highlights are: YARN support, support for HTTP
Kerberos authentication using SPNEGO, SQL syntax highlighting of queries, and
user and distribution specific configuration checks during startup.</p>
<!-- previously: site.posts -->
-<p><a class="post-link"
href="/blog/2018/02/08/running-sql-queries-on-amazon-s3/">Running SQL Queries
on Amazon S3</a><br/>
-<span class="post-date">Posted on Feb 8, 2018
+<p><a class="post-link"
href="/blog/2018/02/09/running-sql-queries-on-amazon-s3/">Running SQL Queries
on Amazon S3</a><br/>
+<span class="post-date">Posted on Feb 9, 2018
by Nick Amato</span>
<br/>Drill enables you to run SQL queries directly on data in S3. There's no
need to ingest the data into a managed cluster or transform the data. This is a
step-by-step tutorial on how to use Drill with S3.</p>
<!-- previously: site.posts -->
diff --git a/docs/apache-drill-1-19-0-release-notes/index.html
b/docs/apache-drill-1-19-0-release-notes/index.html
index 0ac80f5..ba84fa3 100644
--- a/docs/apache-drill-1-19-0-release-notes/index.html
+++ b/docs/apache-drill-1-19-0-release-notes/index.html
@@ -1418,7 +1418,7 @@
<li>[<a
href="https://issues.apache.org/jira/browse/DRILL-5405";>DRILL-5405</a>] - Add
missing operator types without dependency on protobuf enum</li>
<li>[<a
href="https://issues.apache.org/jira/browse/DRILL-7135";>DRILL-7135</a>] -
Upgrade to Jetty 9.4</li>
<li>[<a
href="https://issues.apache.org/jira/browse/DRILL-7551";>DRILL-7551</a>] -
Improve Error Reporting</li>
- <li>[<a
href="https://issues.apache.org/jira/browse/DRILL-7729";>DRILL-7729</a>] - Use
java.time in column accessors</li>
+ <li>[<a
href="https://issues.apache.org/jira/browse/DRILL-7729";>DRILL-7729</a>] - Use
java.time in column accessors. <strong>Please note</strong> that timestamps
returned in the REST API have consequently changed from ISO 8601 to UNIX time
in milliseconds.</li>
<li>[<a
href="https://issues.apache.org/jira/browse/DRILL-7733";>DRILL-7733</a>] - Use
streaming for REST JSON queries</li>
<li>[<a
href="https://issues.apache.org/jira/browse/DRILL-7751";>DRILL-7751</a>] - Add
Storage Plugin for Splunk</li>
<li>[<a
href="https://issues.apache.org/jira/browse/DRILL-7763";>DRILL-7763</a>] - Add
Limit Pushdown to File Based Storage Plugins</li>
diff --git a/docs/configuring-storage-plugins/index.html
b/docs/configuring-storage-plugins/index.html
index 649389b..a4a7d71 100644
--- a/docs/configuring-storage-plugins/index.html
+++ b/docs/configuring-storage-plugins/index.html
@@ -1413,7 +1413,7 @@
<ol>
<li><a href="/docs/starting-drill-on-linux-and-mac-os-x/">Start the Drill
shell</a>.</li>
- <li><a href="/docs/starting-the-web-console/">Start the Web UI</a>. The
Storage tab appears in the Web UI if you are <a
href="/docs/configuring-web-console-and-rest-api-security/">authorized</a> to
view, update, or add storage plugins.</li>
+ <li><a href="/docs/starting-the-web-ui/">Start the Web UI</a>. The Storage
tab appears in the Web UI if you are <a
href="/docs/configuring-web-ui-and-rest-api-security/">authorized</a> to view,
update, or add storage plugins.</li>
<li>On the Storage tab, enter a name in <strong>New Storage Plugin</strong>.
Each configuration registered with Drill must have a distinct
name. Names are case-sensitive.<br />
diff --git a/docs/hdf5-format-plugin/index.html
b/docs/hdf5-format-plugin/index.html
index fd9caf4..e086653 100644
--- a/docs/hdf5-format-plugin/index.html
+++ b/docs/hdf5-format-plugin/index.html
@@ -1397,7 +1397,7 @@
<p><strong>Introduced in release:</strong> 1.18.</p>
-<p>Hierarchical Data Format (HDF) is a set of file formats designed to store
and organize large amounts of data <sup id="fnref:1" role="doc-noteref"><a
href="#fn:1" class="footnote" rel="footnote">1</a></sup>. Originally developed
at the National Center for Supercomputing Applications, it is supported by The
HDF Group, a non-profit corporation whose mission is to ensure continued
development of HDF5 technologies and the continued accessibility of data stored
in HDF <sup id="fnref:2" rol [...]
+<p>Hierarchical Data Format (HDF) is a set of file formats designed to store
and organize large amounts of data <sup id="fnref:1" role="doc-noteref"><a
href="#fn:1" class="footnote">1</a></sup>. Originally developed at the
National Center for Supercomputing Applications, it is supported by The HDF
Group, a non-profit corporation whose mission is to ensure continued
development of HDF5 technologies and the continued accessibility of data stored
in HDF <sup id="fnref:2" role="doc-noteref" [...]
<p>This plugin enables Apache Drill to query HDF5 files.</p>
diff --git a/docs/ip-networking-functions/index.html
b/docs/ip-networking-functions/index.html
index c76e6d8..8f3585d 100644
--- a/docs/ip-networking-functions/index.html
+++ b/docs/ip-networking-functions/index.html
@@ -1411,72 +1411,72 @@
</thead>
<tbody>
<tr>
- <td>inet_aton(<ip>)</ip></td>
+ <td>inet_aton( ip )</td>
<td>INT</td>
<td>Converts an IPv4 address into an integer</td>
</tr>
<tr>
- <td>inet_ntoa( <int>)</int></td>
+ <td>inet_ntoa( int )</td>
<td>VARCHAR</td>
<td>Converts an integer IP into dotted decimal notation</td>
</tr>
<tr>
- <td>in_network( <ip>,<cidr> )</cidr></ip></td>
+ <td>in_network( ip, cidr )</td>
<td>BOOLEAN</td>
<td>Returns true if the IP address is in the given CIDR block</td>
</tr>
<tr>
- <td>address_count( <cidr> )</cidr></td>
+ <td>address_count( cidr )</td>
<td>INT</td>
<td>Returns the number of IPs in a given CIDR block</td>
</tr>
<tr>
- <td>broadcast_address( <cidr> )</cidr></td>
+ <td>broadcast_address( cidr )</td>
<td>VARCHAR</td>
<td>Returns the broadcast address for a given CIDR block</td>
</tr>
<tr>
- <td>netmask(<cidr> )</cidr></td>
+ <td>netmask( cidr )</td>
<td>VARCHAR</td>
<td>Returns the netmask for a given CIDR block</td>
</tr>
<tr>
- <td>low_address(<cidr>)</cidr></td>
+ <td>low_address( cidr )</td>
<td>VARCHAR</td>
<td>Returns the first address in a given CIDR block</td>
</tr>
<tr>
- <td>high_address(<cidr>)</cidr></td>
+ <td>high_address( cidr )</td>
<td>VARCHAR</td>
<td>Returns the last address in a given CIDR block</td>
</tr>
<tr>
- <td>url_encode( <url> )</url></td>
+ <td>url_encode( url )</td>
<td>VARCHAR</td>
<td>Returns a URL encoded string</td>
</tr>
<tr>
- <td>url_decode( <url> )</url></td>
+ <td>url_decode( url )</td>
<td>VARCHAR</td>
<td>Decodes a URL encoded string</td>
</tr>
<tr>
- <td>is_valid_IP(<ip>)</ip></td>
+ <td>is_valid_IP( ip )</td>
<td>BOOLEAN</td>
<td>Returns true if the IP is a valid IP address</td>
</tr>
<tr>
- <td>is_private_ip(<ip>)</ip></td>
+ <td>is_private_ip( ip )</td>
<td>BOOLEAN</td>
<td>Returns true if the IP is a private IPv4 address</td>
</tr>
<tr>
- <td>is_valid_IPv4(<ip>)</ip></td>
+ <td>is_valid_IPv4( ip )</td>
<td>BOOLEAN</td>
<td>Returns true if the IP is a valid IPv4 address</td>
</tr>
<tr>
- <td>is_valid_IPv6(<ip>)</ip></td>
+ <td>is_valid_IPv6( ip )</td>
<td>BOOLEAN</td>
<td>Returns true if the IP is a valid IPv6 address</td>
</tr>
diff --git a/feed.xml b/feed.xml
index eb6c6a5..420d270 100644
--- a/feed.xml
+++ b/feed.xml
@@ -4,10 +4,10 @@
<title>Apache Drill - Schema-free SQL for Hadoop, NoSQL and Cloud
Storage</title>
<description>The official user documentation for Apache Drill.
</description>
- <link>/</link>
- <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Mon, 14 Jun 2021 17:22:20 -0700</pubDate>
- <lastBuildDate>Mon, 14 Jun 2021 17:22:20 -0700</lastBuildDate>
+ <link>http://localhost:4000/</link>
+ <atom:link href="http://localhost:4000/feed.xml"; rel="self"
type="application/rss+xml"/>
+ <pubDate>Tue, 15 Jun 2021 17:14:20 +0200</pubDate>
+ <lastBuildDate>Tue, 15 Jun 2021 17:14:20 +0200</lastBuildDate>
<generator>Jekyll v3.9.0</generator>
<item>
@@ -39,9 +39,9 @@
<p>You can find a complete list of improvements and JIRAs resolved in
the 1.19.0 release <a
href="/docs/apache-drill-1-19-0-release-notes/">here</a>.</p>
</description>
- <pubDate>Thu, 10 Jun 2021 00:00:00 -0700</pubDate>
- <link>/blog/2021/06/10/drill-1.19-released/</link>
- <guid isPermaLink="true">/blog/2021/06/10/drill-1.19-released/</guid>
+ <pubDate>Thu, 10 Jun 2021 00:00:00 +0200</pubDate>
+ <link>http://localhost:4000/blog/2021/06/10/drill-1.19-released/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2021/06/10/drill-1.19-released/</guid>
<category>blog</category>
@@ -63,9 +63,9 @@
<p>You can find a complete list of improvements and JIRAs resolved in
the 1.18.0 release <a
href="/docs/apache-drill-1-18-0-release-notes/">here</a>.</p>
</description>
- <pubDate>Sat, 05 Sep 2020 00:00:00 -0700</pubDate>
- <link>/blog/2020/09/05/drill-1.18-released/</link>
- <guid isPermaLink="true">/blog/2020/09/05/drill-1.18-released/</guid>
+ <pubDate>Sat, 05 Sep 2020 00:00:00 +0200</pubDate>
+ <link>http://localhost:4000/blog/2020/09/05/drill-1.18-released/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2020/09/05/drill-1.18-released/</guid>
<category>blog</category>
@@ -105,9 +105,9 @@
<p>You can find a complete list of improvements and JIRAs resolved in
the 1.17.0 release <a
href="/docs/apache-drill-1-17-0-release-notes/">here</a>.</p>
</description>
- <pubDate>Thu, 26 Dec 2019 00:00:00 -0800</pubDate>
- <link>/blog/2019/12/26/drill-1.17-released/</link>
- <guid isPermaLink="true">/blog/2019/12/26/drill-1.17-released/</guid>
+ <pubDate>Thu, 26 Dec 2019 00:00:00 +0200</pubDate>
+ <link>http://localhost:4000/blog/2019/12/26/drill-1.17-released/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2019/12/26/drill-1.17-released/</guid>
<category>blog</category>
@@ -118,9 +118,9 @@
<title>Drill User Meetup 2019</title>
<description>
</description>
- <pubDate>Thu, 02 May 2019 00:00:00 -0700</pubDate>
- <link>/blog/2019/05/02/drill-user-meetup/</link>
- <guid isPermaLink="true">/blog/2019/05/02/drill-user-meetup/</guid>
+ <pubDate>Thu, 02 May 2019 00:00:00 +0200</pubDate>
+ <link>http://localhost:4000/blog/2019/05/02/drill-user-meetup/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2019/05/02/drill-user-meetup/</guid>
<category>blog</category>
@@ -154,9 +154,9 @@
<p>You can find a complete list of improvements and JIRAs resolved in
the 1.16.0 release <a
href="/docs/apache-drill-1-16-0-release-notes/">here</a>.</p>
</description>
- <pubDate>Thu, 02 May 2019 00:00:00 -0700</pubDate>
- <link>/blog/2019/05/02/drill-1.16-released/</link>
- <guid isPermaLink="true">/blog/2019/05/02/drill-1.16-released/</guid>
+ <pubDate>Thu, 02 May 2019 00:00:00 +0200</pubDate>
+ <link>http://localhost:4000/blog/2019/05/02/drill-1.16-released/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2019/05/02/drill-1.16-released/</guid>
<category>blog</category>
@@ -187,9 +187,9 @@
<p>You can find a complete list of improvements and JIRAs resolved in
the 1.15.0 release <a
href="/docs/apache-drill-1-15-0-release-notes/">here</a>.</p>
</description>
- <pubDate>Mon, 31 Dec 2018 00:00:00 -0800</pubDate>
- <link>/blog/2018/12/31/drill-1.15-released/</link>
- <guid isPermaLink="true">/blog/2018/12/31/drill-1.15-released/</guid>
+ <pubDate>Mon, 31 Dec 2018 00:00:00 +0200</pubDate>
+ <link>http://localhost:4000/blog/2018/12/31/drill-1.15-released/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2018/12/31/drill-1.15-released/</guid>
<category>blog</category>
@@ -222,9 +222,9 @@
<li>Paul Rogers, Big Data Engineer, Cloudera</li>
</ul>
</description>
- <pubDate>Sat, 01 Dec 2018 00:00:00 -0800</pubDate>
- <link>/blog/2018/12/01/learning-apache-drill-book/</link>
- <guid
isPermaLink="true">/blog/2018/12/01/learning-apache-drill-book/</guid>
+ <pubDate>Sat, 01 Dec 2018 00:00:00 +0200</pubDate>
+
<link>http://localhost:4000/blog/2018/12/01/learning-apache-drill-book/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2018/12/01/learning-apache-drill-book/</guid>
<category>blog</category>
@@ -235,9 +235,9 @@
<title>Drill User Meetup 2018</title>
<description>
</description>
- <pubDate>Tue, 16 Oct 2018 12:18:04 -0700</pubDate>
- <link>/blog/2018/10/16/drill-user-meetup/</link>
- <guid isPermaLink="true">/blog/2018/10/16/drill-user-meetup/</guid>
+ <pubDate>Tue, 16 Oct 2018 21:18:04 +0200</pubDate>
+ <link>http://localhost:4000/blog/2018/10/16/drill-user-meetup/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2018/10/16/drill-user-meetup/</guid>
<category>blog</category>
@@ -248,9 +248,9 @@
<title>Drill Developer Day 2018</title>
<description>
</description>
- <pubDate>Tue, 16 Oct 2018 12:18:04 -0700</pubDate>
- <link>/blog/2018/10/16/drill-developer-day/</link>
- <guid isPermaLink="true">/blog/2018/10/16/drill-developer-day/</guid>
+ <pubDate>Tue, 16 Oct 2018 21:18:04 +0200</pubDate>
+ <link>http://localhost:4000/blog/2018/10/16/drill-developer-day/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2018/10/16/drill-developer-day/</guid>
<category>blog</category>
@@ -282,9 +282,9 @@ See <a
href="/docs/image-metadata-format-plugin/">Image Metadata
<p>You can find a complete list of JIRAs resolved in the 1.14.0 release
<a
href="/docs/apache-drill-1-14-0-release-notes/">here</a>.</p>
</description>
- <pubDate>Sun, 05 Aug 2018 00:00:00 -0700</pubDate>
- <link>/blog/2018/08/05/drill-1.14-released/</link>
- <guid isPermaLink="true">/blog/2018/08/05/drill-1.14-released/</guid>
+ <pubDate>Sun, 05 Aug 2018 00:00:00 +0200</pubDate>
+ <link>http://localhost:4000/blog/2018/08/05/drill-1.14-released/</link>
+ <guid
isPermaLink="true">http://localhost:4000/blog/2018/08/05/drill-1.14-released/</guid>
<category>blog</category>
