You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by dz...@apache.org on 2021/01/06 09:08:38 UTC
[drill] branch gh-pages updated (976b268 -> 49dab68)
This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a change to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git.
from 976b268 Clean up note blocks in rdbms-storage-plugin and distributed-mode-prerequisites.
new 5085473 Document the SPLIT_PART function.
new 49dab68 Move attachments/ dir out of _docs collection and up to top level.
The 2 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
_config.yml | 6 ++--
_data/authors.json | 6 ++++
.../010-apache-drill-contribution-guidelines.md | 2 +-
.../sql-functions/040-string-manipulation.md | 35 ++++++++++++++++-----
.../intellij-idea-settings.jar | Bin
blog/_posts/2020-09-04-drill-1.18-released.md | 32 -------------------
6 files changed, 37 insertions(+), 44 deletions(-)
rename {_docs/attachments => attachments}/intellij-idea-settings.jar (100%)
delete mode 100644 blog/_posts/2020-09-04-drill-1.18-released.md
[drill] 02/02: Move attachments/ dir out of _docs collection and up
to top level.
Posted by dz...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
commit 49dab68c56a00d2153b527b9fe6c550089959235
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Wed Jan 6 11:07:07 2021 +0200
Move attachments/ dir out of _docs collection and up to top level.
---
_config.yml | 6 ++--
_data/authors.json | 6 ++++
.../010-apache-drill-contribution-guidelines.md | 2 +-
.../intellij-idea-settings.jar | Bin
blog/_posts/2020-09-04-drill-1.18-released.md | 32 ---------------------
5 files changed, 9 insertions(+), 37 deletions(-)
diff --git a/_config.yml b/_config.yml
index d47620a..559eaf5 100644
--- a/_config.yml
+++ b/_config.yml
@@ -1,13 +1,11 @@
title: Apache Drill - Schema-free SQL for Hadoop, NoSQL and Cloud Storage
title_suffix: Apache Drill # This is appended to every page title on the site
-email: tshiran@apache.org
+email: dzamo@apache.org
permalink: pretty
description: > # this means to ignore newlines until "baseurl:"
- Write an awesome description for your new site here. You can edit this
- line in _config.yml. It will appear in your document head meta (for
- Google search results) and in your feed.xml site description.
+ The official user documentation for Apache Drill.
baseurl: "/drill" # Base URL when hosted on GitHub Pages (drill repository under apache account)
noindex: 1
diff --git a/_data/authors.json b/_data/authors.json
index 6d1f6f2..8ef0219 100644
--- a/_data/authors.json
+++ b/_data/authors.json
@@ -46,5 +46,11 @@
"title": "Committer",
"org": "MapR Technologies",
"email": "agirish@mapr.com"
+ },
+ "jturton": {
+ "name": "James Turton",
+ "title": "Committer",
+ "org": "Apache Software Foundation",
+ "email": "dzamo@apache.org"
}
}
diff --git a/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md b/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md
index 3e8d518..9972912 100644
--- a/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md
+++ b/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md
@@ -54,7 +54,7 @@ Setting up IDE formatters is recommended and can be done by importing the
following settings into your browser:
-* IntelliJ IDEA formatter: [settings jar]({{site.baseurl}}/docs/attachments/intellij-idea-settings.jar)
+* IntelliJ IDEA formatter: [settings jar]({{site.baseurl}}/attachments/intellij-idea-settings.jar)
* Eclipse: [formatter xml](https://issues.apache.org/jira/secure/attachment/12474245/eclipse_formatter_apache.xml)
### Understanding Maven
diff --git a/_docs/attachments/intellij-idea-settings.jar b/attachments/intellij-idea-settings.jar
similarity index 100%
rename from _docs/attachments/intellij-idea-settings.jar
rename to attachments/intellij-idea-settings.jar
diff --git a/blog/_posts/2020-09-04-drill-1.18-released.md b/blog/_posts/2020-09-04-drill-1.18-released.md
deleted file mode 100644
index d8101df..0000000
--- a/blog/_posts/2020-09-04-drill-1.18-released.md
+++ /dev/null
@@ -1,32 +0,0 @@
----
-layout: post
-title: "Drill 1.18 Released"
-code: drill-1.18-released
-excerpt: Apache Drill 1.18's highlights are: Hadoop, Kafka, Sqlline, and Calcite upgrades, .zip compression, file/table function for schema provisioning, new UDFs, and more.
-authors: ["bbevens"]
----
-
-Today, we're happy to announce the availability of Drill 1.18.0. You can download it [here](https://drill.apache.org/download/).
-
-This release provides the following bug fixes and improvements:
-
-## Hive complex types support:
-* <a href='https://issues.apache.org/jira/browse/DRILL-7251'>DRILL-7251</a> - Read Hive array without nulls
-* <a href='https://issues.apache.org/jira/browse/DRILL-7252'>DRILL-7252</a> - Read Hive map using Dict<K,V> vector
-* <a href='https://issues.apache.org/jira/browse/DRILL-7253'>DRILL-7253</a> - Read Hive struct without nulls
-* <a href='https://issues.apache.org/jira/browse/DRILL-7254'>DRILL-7254</a> - Read Hive union without nulls
-* <a href='https://issues.apache.org/jira/browse/DRILL-7268'>DRILL-7268</a> - Read Hive array with parquet native reader
-
-## New format plugins support:
-* <a href='https://issues.apache.org/jira/browse/DRILL-4303'>DRILL-4303</a> - ESRI Shapefile (shp) format plugin
-* <a href='https://issues.apache.org/jira/browse/DRILL-7177'>DRILL-7177</a> - Format Plugin for Excel Files
-* <a href='https://issues.apache.org/jira/browse/DRILL-6096'>DRILL-6096</a> - Provide mechanisms to specify field delimiters and quoted text for TextRecordWriter
-* Parquet format improvements, including runtime row group pruning (<a href='https://issues.apache.org/jira/browse/DRILL-7062'>DRILL-7062</a>), empty parquet creation (<a href='https://issues.apache.org/jira/browse/DRILL-7156'>DRILL-7156</a>), reading (<a href='https://issues.apache.org/jira/browse/DRILL-4517'>DRILL-4517</a>) support, and more.
-
-## Metastore support:
-* <a href='https://issues.apache.org/jira/browse/DRILL-7272'>DRILL-7272</a> - Implement Drill Iceberg Metastore plugin
-* <a href='https://issues.apache.org/jira/browse/DRILL-7273'>DRILL-7273</a> - Create operator for handling metadata
-* <a href='https://issues.apache.org/jira/browse/DRILL-7357'>DRILL-7357</a> - Expose Drill Metastore data through INFORMATION_SCHEMA
-
-You can find a complete list of improvements and JIRAs resolved in the 1.18.0 release [here]({{site.baseurl}}/docs/apache-drill-1-18-0-release-notes/).
-
[drill] 01/02: Document the SPLIT_PART function.
Posted by dz...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
commit 5085473d16e65009d24853fbaf929b599d173590
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Tue Dec 15 06:47:50 2020 +0200
Document the SPLIT_PART function.
---
.../sql-functions/040-string-manipulation.md | 35 +++++++++++++++++-----
1 file changed, 28 insertions(+), 7 deletions(-)
diff --git a/_docs/sql-reference/sql-functions/040-string-manipulation.md b/_docs/sql-reference/sql-functions/040-string-manipulation.md
index 3a7121e..376832f 100644
--- a/_docs/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/sql-reference/sql-functions/040-string-manipulation.md
@@ -27,6 +27,7 @@ You can use the following string functions in Drill queries:
| [RPAD]({{ site.baseurl }}/docs/string-manipulation/#rpad) | VARCHAR |
| [RTRIM]({{ site.baseurl }}/docs/string-manipulation/#rtrim) | VARCHAR |
| [SPLIT]({{ site.baseurl }}/docs/string-manipulation/#split) | INTEGER |
+| [SPLIT_PART]({{ site.baseurl }}/docs/string-manipulation/#split_part) | VARCHAR |
| [STRPOS]({{ site.baseurl }}/docs/string-manipulation/#strpos) | INTEGER |
| [SUBSTR]({{ site.baseurl }}/docs/string-manipulation/#substr) | VARCHAR |
| [TOASCII]({{ site.baseurl }}/docs/string-manipulation/#toascii) | VARCHAR |
@@ -34,7 +35,7 @@ You can use the following string functions in Drill queries:
| [UPPER]({{ site.baseurl }}/docs/string-manipulation/#upper) | VARCHAR |
{% include startnote.html %}
-As with indexes througout SQL, indexes into character strings are 1-based.
+As is the case for indexes througout SQL, indexes into character strings are 1-based.
{% include endnote.html %}
## BYTE_SUBSTR
@@ -518,8 +519,28 @@ The _delimiter_ must not be null and must contain a single character.
| [The, quick, brown, fox, jumps...] |
|------------------------------------|
+## SPLIT_PART
+Return the string part at _index_ after splitting the input string using the specified delimiter.
+
+### SPLIT_PART Syntax
+ SPLIT_PART(string, delimiter, index)
+
+### SPLIT_PART Usage Notes
+The _delimiter_ string may be multiple characters long. The _index_ must be a positive integer.
+
+### SPLIT_PART Examples
+
+ SELECT split_part('The | quick | brown | fox | jumps', ' | ', 4);
+
+ |--------|
+ | EXPR$0 |
+ |--------|
+ | fox |
+ |--------|
+
## STRPOS
-Returns the location of the first occurrence of a substring of the input string, or 0 if the substring does not occur.
+Returns the location of the first occurrence of a substring of the input
+string, or 0 if the substring does not occur.
### STRPOS Syntax
@@ -529,11 +550,11 @@ STRPOS(string, substring)
SELECT STRPOS('Apache Drill', 'Drill') FROM (VALUES(1));
- |------------|
- | EXPR$0 |
- |------------|
- | 8 |
- |------------|
+ |--------|
+ | EXPR$0 |
+ |--------|
+ | 8 |
+ |--------|
1 row selected (0.22 seconds)
## SUBSTR