You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by ta...@apache.org on 2020/03/24 21:19:20 UTC
[impala] branch master updated (1411ca6 -> a694848)
This is an automated email from the ASF dual-hosted git repository.
tarmstrong pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git.
from 1411ca6 IMPALA-9183: Convert disjunctive predicates to conjunctive normal form
new 35d2718 IMPALA-9547: retry accept in test_shell_commandline
new a694848 IMPALA-9443: [DOCS] Make tables optically pleasing and complete
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:
docs/topics/impala_perf_stats.xml | 80 ++++++++++++++--------------
docs/topics/impala_show.xml | 99 ++++++++++++++++++-----------------
tests/shell/test_shell_commandline.py | 11 +++-
3 files changed, 100 insertions(+), 90 deletions(-)
[impala] 01/02: IMPALA-9547: retry accept in test_shell_commandline
Posted by ta...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
tarmstrong pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git
commit 35d2718d36c06abe867dff61307be920325e8a5e
Author: Tim Armstrong <ta...@cloudera.com>
AuthorDate: Mon Mar 23 20:36:09 2020 -0700
IMPALA-9547: retry accept in test_shell_commandline
This is a point solution to this particular socket.accept()
call failing. The more general problem is described in
https://www.python.org/dev/peps/pep-0475/ and fixed in
Python 3.5.
Change-Id: Icc9cab98b059042855ca9149427d079951471be0
Reviewed-on: http://gerrit.cloudera.org:8080/15541
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
---
tests/shell/test_shell_commandline.py | 11 ++++++++++-
1 file changed, 10 insertions(+), 1 deletion(-)
diff --git a/tests/shell/test_shell_commandline.py b/tests/shell/test_shell_commandline.py
index ac8e07b..ec16641 100644
--- a/tests/shell/test_shell_commandline.py
+++ b/tests/shell/test_shell_commandline.py
@@ -17,6 +17,7 @@
# specific language governing permissions and limitations
# under the License.
+import errno
import os
import pytest
import re
@@ -789,7 +790,15 @@ class TestImpalaShell(ImpalaTestSuite):
try:
connection = None
impala_shell = Popen(shell_cmd + args, stdout=devnull, stderr=devnull)
- connection, client_address = sock.accept()
+ # IMPALA-9547: retry accept(). This is required in Python < 3.5 because some
+ # EINTR return calls from syscalls are not automatically retried. See PEP475.
+ while True:
+ try:
+ connection, client_address = sock.accept()
+ break
+ except IOError, e:
+ if e.errno != errno.EINTR:
+ raise
data = connection.recv(1024)
assert expected_output in data
finally:
[impala] 02/02: IMPALA-9443: [DOCS] Make tables optically pleasing
and complete
Posted by ta...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
tarmstrong pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git
commit a6948487346f29e2d06a3493262e79f961285400
Author: Kris Hahn <kh...@cloudera.com>
AuthorDate: Wed Mar 18 11:17:18 2020 -0700
IMPALA-9443: [DOCS] Make tables optically pleasing and complete
- Replaced ellipses in example columns with sample output
- Fixed table formatting problems
- Exhumed varname styles
- Reverted table formatting at line 292 to published version formatting
- Fixed table formatting at 831
Change-Id: I83fd30b87730c82c87f6f7aee26d8cceb77b6308
Reviewed-on: http://gerrit.cloudera.org:8080/15476
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-by: Tim Armstrong <ta...@cloudera.com>
---
docs/topics/impala_perf_stats.xml | 80 +++++++++++++++----------------
docs/topics/impala_show.xml | 99 ++++++++++++++++++++-------------------
2 files changed, 90 insertions(+), 89 deletions(-)
diff --git a/docs/topics/impala_perf_stats.xml b/docs/topics/impala_perf_stats.xml
index 703cb4a..f04d4fc 100644
--- a/docs/topics/impala_perf_stats.xml
+++ b/docs/topics/impala_perf_stats.xml
@@ -82,11 +82,11 @@ under the License.
<codeblock>
show table stats parquet_snappy;
-+-------+--------+---------+--------------+-------------------+---------+-------------------+...
-| #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats |...
-+-------+--------+---------+--------------+-------------------+---------+-------------------+...
-| -1 | 96 | 23.35GB | NOT CACHED | NOT CACHED | PARQUET | false |...
-+-------+--------+---------+--------------+-------------------+---------+-------------------+...
++-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location |
++-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| -1 | 96 | 23.35GB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
++-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
compute stats parquet_snappy;
+-----------------------------------------+
@@ -97,11 +97,11 @@ compute stats parquet_snappy;
show table stats parquet_snappy;
-+------------+--------+---------+--------------+-------------------+---------+-------------------+...
-| #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats |...
-+------------+--------+---------+--------------+-------------------+---------+-------------------+...
-| 1000000000 | 96 | 23.35GB | NOT CACHED | NOT CACHED | PARQUET | false |...
-+------------+--------+---------+--------------+-------------------+---------+-------------------+...
++------------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location |
++------------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| 1000000000 | 96 | 23.35GB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
++------------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
</codeblock>
<p>
@@ -247,28 +247,28 @@ show column stats parquet_snappy;
<codeblock>
show partitions year_month_day;
-+-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+...
-| year | month | day | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format |...
-+-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+...
-| 2013 | 12 | 1 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 2 | -1 | 1 | 2.53MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 3 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 4 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 5 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET |...
-| Total | | | -1 | 5 | 12.58MB | 0B | | |...
-+-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+...
++-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| year | month | day | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location |
++-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| 2013 | 12 | 1 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 2 | -1 | 1 | 2.53MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 3 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 4 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 5 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| Total | | | -1 | 5 | 12.58MB | 0B | | | | |
++-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
show table stats year_month_day;
-+-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+...
-| year | month | day | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format |...
-+-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+...
-| 2013 | 12 | 1 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 2 | -1 | 1 | 2.53MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 3 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 4 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 5 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET |...
-| Total | | | -1 | 5 | 12.58MB | 0B | | |...
-+-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+...
++-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| year | month | day | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location |
++-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| 2013 | 12 | 1 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 2 | -1 | 1 | 2.53MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 3 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 4 | -1 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 5 | -1 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| Total | | | -1 | 5 | 12.58MB | 0B | | | | |
++-------+-------+-----+-------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
show column stats year_month_day;
+-----------+---------+------------------+--------+----------+----------+
@@ -292,16 +292,16 @@ compute stats year_month_day;
+-----------------------------------------+
show table stats year_month_day;
-+-------+-------+-----+--------+--------+---------+--------------+-------------------+---------+...
-| year | month | day | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format |...
-+-------+-------+-----+--------+--------+---------+--------------+-------------------+---------+...
-| 2013 | 12 | 1 | 93606 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 2 | 94158 | 1 | 2.53MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 3 | 94122 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 4 | 93559 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET |...
-| 2013 | 12 | 5 | 93845 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET |...
-| Total | | | 469290 | 5 | 12.58MB | 0B | | |...
-+-------+-------+-----+--------+--------+---------+--------------+-------------------+---------+...
++-------+-------+-----+--------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| year | month | day | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location |
++-------+-------+-----+--------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
+| 2013 | 12 | 1 | 93606 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 2 | 94158 | 1 | 2.53MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 3 | 94122 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 4 | 93559 | 1 | 2.51MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| 2013 | 12 | 5 | 93845 | 1 | 2.52MB | NOT CACHED | NOT CACHED | PARQUET | false | hdfs://<server>:8020/<path>/parquet_snappy |
+| Total | | | 469290 | 5 | 12.58MB | 0B | | | | |
++-------+-------+-----+--------+--------+---------+--------------+-------------------+---------+-------------------+--------------------------------------------+
show column stats year_month_day;
+-----------+---------+------------------+--------+----------+-------------------+
diff --git a/docs/topics/impala_show.xml b/docs/topics/impala_show.xml
index 0e40717..83c6c19 100644
--- a/docs/topics/impala_show.xml
+++ b/docs/topics/impala_show.xml
@@ -178,11 +178,11 @@ show files in sample_table partition (month like 'J%');
[localhost:21000] > insert into unpart_text (x, s) select id, name
> from oreilly.sample_data limit 20e6;
[localhost:21000] > show files in unpart_text;
-+------------------------------------------------------------------------------+----------+-----------+
-| path | size | partition |
-+------------------------------------------------------------------------------+----------+-----------+
++--------------------------------------------------------------------------------------+----------+-----------+
+| path | size | partition |
++--------------------------------------------------------------------------------------+----------+-----------+
| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/35665776ef85cfaf_1012432410_data.0. | 448.31MB | |
-+------------------------------------------------------------------------------+----------+-----------+
++--------------------------------------------------------------------------------------+----------+-----------+
[localhost:21000] > insert into unpart_text (x, s) select id, name from oreilly.sample_data limit 100e6;
[localhost:21000] > show files in unpart_text;
+--------------------------------------------------------------------------------------+----------+-----------+
@@ -203,14 +203,14 @@ show files in sample_table partition (month like 'J%');
<codeblock scale="60">[localhost:21000] > insert into unpart_text values (10,'hello'), (20, 'world');
[localhost:21000] > insert into unpart_text values (-1,'foo'), (-1000, 'bar');
[localhost:21000] > show files in unpart_text;
-+--------------------------------------------------------------------------------------+----------+
-| path | size |
-+--------------------------------------------------------------------------------------+----------+
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/4f11b8bdf8b6aa92_238145083_data.0. | 18B
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/35665776ef85cfaf_1012432410_data.0. | 448.31MB
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/ac3dba252a8952b8_1663177415_data.0. | 2.19GB
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/cfb8252452445682_1868457216_data.0. | 17B
-+--------------------------------------------------------------------------------------+----------+
++--------------------------------------------------------------------------------------+----------+-----------+
+| path | size | partition |
++--------------------------------------------------------------------------------------+----------+-----------+
+| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/4f11b8bdf8b6aa92_238145083_data.0. | 18B | |
+| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/35665776ef85cfaf_1012432410_data.0. | 448.31MB | |
+| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/ac3dba252a8952b8_1663177415_data.0. | 2.19GB | |
+| hdfs://<varname>impala_data_dir</varname>/show_files.db/unpart_text/cfb8252452445682_1868457216_data.0. | 17B | |
++--------------------------------------------------------------------------------------+----------+-----------+
[localhost:21000] > create table unpart_parq stored as parquet as select * from unpart_text;
+---------------------------+
| summary |
@@ -258,18 +258,18 @@ where id between 1 and 1000000;
| Total | | | -1 | 8 | 51.38MB | 0B | | | |
+-------+-------+-----+-------+--------+---------+--------------+-------------------+--------+-------------------+
[localhost:21000] > show files in part_text;
-+---------------------------------------------------------------------------------------------------------+--------+-------------------------+
-| path | size | partition |
-+---------------------------------------------------------------------------------------------------------+--------+-------------------------+
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc80689f_1418645991_data.0. | 5.77MB | year=2014/month=1/day=1 |
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc8068a0_1418645991_data.0. | 6.25MB | year=2014/month=1/day=1 |
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc8068a1_147082319_data.0. | 7.16MB | year=2014/month=1/day=1 |
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc8068a2_2111411753_data.0. | 5.98MB | year=2014/month=1/day=1 |
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbb_501271652_data.0. | 6.42MB | year=2014/month=1/day=2 |
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbc_501271652_data.0. | 6.62MB | year=2014/month=1/day=2 |
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbd_1393490200_data.0. | 6.98MB | year=2014/month=1/day=2 |
-| hdfs://<varname>impala_data_dir</varname>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbe_1393490200_data.0. | 6.20MB | year=2014/month=1/day=2 |
-+---------------------------------------------------------------------------------------------------------+--------+-------------------------+
++-----------------------------------------------------------------------------------------------------------------------+--------+-------------------------+
+| path | size | partition |
++-----------------------------------------------------------------------------------------------------------------------+--------+-------------------------+
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc80689f_1418645991_data.0. | 5.77MB | year=2014/month=1/day=1 |
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc8068a0_1418645991_data.0. | 6.25MB | year=2014/month=1/day=1 |
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc8068a1_147082319_data.0. | 7.16MB | year=2014/month=1/day=1 |
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=1/80732d9dc8068a2_2111411753_data.0. | 5.98MB | year=2014/month=1/day=1 |
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbb_501271652_data.0. | 6.42MB | year=2014/month=1/day=2 |
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbc_501271652_data.0. | 6.62MB | year=2014/month=1/day=2 |
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbd_1393490200_data.0. | 6.98MB | year=2014/month=1/day=2 |
+| hdfs://<impala_data_dir>/show_files.db/part_text/year=2014/month=1/day=2/21a828cf494b5bbe_1393490200_data.0. | 6.20MB | year=2014/month=1/day=2 |
++-----------------------------------------------------------------------------------------------------------------------+--------+-------------------------+
</codeblock>
<p>
The following example shows a <codeph>SHOW FILES</codeph> statement for a partitioned Parquet table.
@@ -820,20 +820,20 @@ show CREATE TABLE numeric_grades_default_letter;
| student STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION, |
| PRIMARY KEY (score) |
| ) |
-| PARTITION BY <b>RANGE (score) (...)</b> |
+| PARTITION BY RANGE (score) (...) . |
| STORED AS KUDU |
| TBLPROPERTIES ('kudu.master_addresses'='vd0342.example.com:7051') |
+------------------------------------------------------------------------------------------------+
show range partitions numeric_grades_default_letter;
-+--------------------+
-| RANGE (score) |
-+--------------------+
-| 0 <= VALUES < 50 |
-| 50 <= VALUES < 65 |
-| 65 <= VALUES < 80 |
-| 80 <= VALUES < 100 |
-+--------------------+
++--------------------------+
+| RANGE (score) |
++--------------------------+
+| 0 <= VALUES < 50 |
+| 50 <= VALUES < 65 |
+| 65 <= VALUES < 80 |
+| 80 <= VALUES < 100 |
++--------------------------+
</codeblock>
<p conref="../shared/impala_common.xml#common/example_blurb"/>
@@ -1333,20 +1333,22 @@ show column stats store_sales;
<codeblock rev="kudu IMPALA-4403"><![CDATA[
show partitions million_rows_hash;
-+-----------+----------+-----------------------+------------+
-| Start Key | Stop Key | Leader Replica | # Replicas |
-+-----------+----------+-----------------------+------------+
-| | 00000001 | n236.example.com:7050 | 3 |
-| 00000001 | 00000002 | n236.example.com:7050 | 3 |
-| 00000002 | 00000003 | n336.example.com:7050 | 3 |
-| 00000003 | 00000004 | n238.example.com:7050 | 3 |
-| 00000004 | 00000005 | n338.example.com:7050 | 3 |
-... |
-| 0000002E | 0000002F | n240.example.com:7050 | 3 |
-| 0000002F | 00000030 | n336.example.com:7050 | 3 |
-| 00000030 | 00000031 | n240.example.com:7050 | 3 |
-| 00000031 | | n334.example.com:7050 | 3 |
-+-----------+----------+-----------------------+------------+
+
++--------+-----------+----------+-----------------------+------------+
+| # Rows | Start Key | Stop Key | Leader Replica | # Replicas |
++--------+-----------+----------+-----------------------+------------+
+| -1 | | 00000001 | n236.example.com:7050 | 3 |
+| -1 | 00000001 | 00000002 | n236.example.com:7050 | 3 |
+| -1 | 00000002 | 00000003 | n336.example.com:7050 | 3 |
+| -1 | 00000003 | 00000004 | n238.example.com:7050 | 3 |
+| -1 | 00000004 | 00000005 | n338.example.com:7050 | 3 |
+...
+| -1 | 0000002E | 0000002F | n240.example.com:7050 | 3 |
+| -1 | 0000002F | 00000030 | n336.example.com:7050 | 3 |
+| -1 | 00000030 | 00000031 | n240.example.com:7050 | 3 |
+| -1 | 00000031 | | n334.example.com:7050 | 3 |
++--------+-----------+----------+-----------------------+------------+
+Fetched 50 row(s) in 0.05s
]]>
</codeblock>
@@ -1452,8 +1454,7 @@ show range partitions million_rows_range;
| DECIMAL(*,*) | abs(DECIMAL(*,*)) | BUILTIN | true |
| DOUBLE | abs(DOUBLE) | BUILTIN | true |
| FLOAT | abs(FLOAT) | BUILTIN | true |
-+----------------+----------------------------------------+
-...
++----------------+-----------------------------------------------+-------------+---------------+
show functions in _impala_builtins like '*week*';
+-------------+------------------------------+-------------+---------------+