This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new 3868da6 updates to drill doc for 115
3868da6 is described below
commit 3868da623a9809a21f679279d2312847ff2570f6
Author: Bridget Bevens <[email protected]>
AuthorDate: Mon Dec 10 14:06:39 2018 -0800
updates to drill doc for 115
---
_data/docs.json | 122 +++++++++++++++++-----------------
_docs/query-data/070-query-sys-tbl.md | 47 ++++++-------
2 files changed, 85 insertions(+), 84 deletions(-)
diff --git a/_data/docs.json b/_data/docs.json
index ffb6306..4922843 100644
--- a/_data/docs.json
+++ b/_data/docs.json
@@ -1542,8 +1542,8 @@
}
],
"children": [],
- "next_title": "Configuring Web Console and REST
API Security",
- "next_url":
"/docs/configuring-web-console-and-rest-api-security/",
+ "next_title": "Configuring Web UI and REST API
Security",
+ "next_url":
"/docs/configuring-web-ui-and-rest-api-security/",
"parent": "Securing Drill",
"previous_title": "Configuring Kerberos Security",
"previous_url":
"/docs/configuring-kerberos-security/",
@@ -1569,8 +1569,8 @@
"previous_title": "Configuring Drill to use SPNEGO
for HTTP Authentication",
"previous_url":
"/docs/configuring-drill-to-use-spnego-for-http-authentication/",
"relative_path":
"_docs/configure-drill/securing-drill/092-configuring-web-ui-and-rest-api-security.md",
- "title": "Configuring Web Console and REST API
Security",
- "url":
"/docs/configuring-web-console-and-rest-api-security/"
+ "title": "Configuring Web UI and REST API
Security",
+ "url":
"/docs/configuring-web-ui-and-rest-api-security/"
}
],
"next_title": "Securing Drill Introduction",
@@ -1657,8 +1657,8 @@
"next_title": "Configuring a Multitenant Cluster
Introduction",
"next_url":
"/docs/configuring-a-multitenant-cluster-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring Web Console and REST API
Security",
- "previous_url":
"/docs/configuring-web-console-and-rest-api-security/",
+ "previous_title": "Configuring Web UI and REST API
Security",
+ "previous_url":
"/docs/configuring-web-ui-and-rest-api-security/",
"relative_path":
"_docs/configure-drill/040-configuring-a-multitenant-cluster.md",
"title": "Configuring a Multitenant Cluster",
"url": "/docs/configuring-a-multitenant-cluster/"
@@ -1893,8 +1893,8 @@
}
],
"children": [],
- "next_title": "Configuring Web Console and REST API Security",
- "next_url":
"/docs/configuring-web-console-and-rest-api-security/",
+ "next_title": "Configuring Web UI and REST API Security",
+ "next_url": "/docs/configuring-web-ui-and-rest-api-security/",
"parent": "Securing Drill",
"previous_title": "Configuring Kerberos Security",
"previous_url": "/docs/configuring-kerberos-security/",
@@ -2340,7 +2340,7 @@
"title": "Configuring User Impersonation with Hive Authorization",
"url":
"/docs/configuring-user-impersonation-with-hive-authorization/"
},
- "Configuring Web Console and REST API Security": {
+ "Configuring Web UI and REST API Security": {
"breadcrumbs": [
{
"title": "Securing Drill",
@@ -2358,8 +2358,8 @@
"previous_title": "Configuring Drill to use SPNEGO for HTTP
Authentication",
"previous_url":
"/docs/configuring-drill-to-use-spnego-for-http-authentication/",
"relative_path":
"_docs/configure-drill/securing-drill/092-configuring-web-ui-and-rest-api-security.md",
- "title": "Configuring Web Console and REST API Security",
- "url": "/docs/configuring-web-console-and-rest-api-security/"
+ "title": "Configuring Web UI and REST API Security",
+ "url": "/docs/configuring-web-ui-and-rest-api-security/"
},
"Configuring a Multitenant Cluster": {
"breadcrumbs": [
@@ -2436,8 +2436,8 @@
"next_title": "Configuring a Multitenant Cluster Introduction",
"next_url":
"/docs/configuring-a-multitenant-cluster-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring Web Console and REST API Security",
- "previous_url":
"/docs/configuring-web-console-and-rest-api-security/",
+ "previous_title": "Configuring Web UI and REST API Security",
+ "previous_url": "/docs/configuring-web-ui-and-rest-api-security/",
"relative_path":
"_docs/configure-drill/040-configuring-a-multitenant-cluster.md",
"title": "Configuring a Multitenant Cluster",
"url": "/docs/configuring-a-multitenant-cluster/"
@@ -5508,8 +5508,8 @@
}
],
"children": [],
- "next_title": "Starting the Web Console",
- "next_url": "/docs/starting-the-web-console/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the
Cluster",
"previous_url":
"/docs/installing-drill-on-the-cluster/",
@@ -5541,8 +5541,8 @@
"previous_title": "Starting Drill in Distributed Mode",
"previous_url":
"/docs/starting-drill-in-distributed-mode/",
"relative_path":
"_docs/install/060-starting-the-web-ui.md",
- "title": "Starting the Web Console",
- "url": "/docs/starting-the-web-console/"
+ "title": "Starting the Web UI",
+ "url": "/docs/starting-the-web-ui/"
},
{
"breadcrumbs": [
@@ -5555,8 +5555,8 @@
"next_title": "Identifying Multiple Drill Versions in a
Cluster",
"next_url":
"/docs/identifying-multiple-drill-versions-in-a-cluster/",
"parent": "Install Drill",
- "previous_title": "Starting the Web Console",
- "previous_url": "/docs/starting-the-web-console/",
+ "previous_title": "Starting the Web UI",
+ "previous_url": "/docs/starting-the-web-ui/",
"relative_path": "_docs/install/061-stopping-drill.md",
"title": "Stopping Drill",
"url": "/docs/stopping-drill/"
@@ -5667,8 +5667,8 @@
}
],
"children": [],
- "next_title": "Starting the Web Console",
- "next_url": "/docs/starting-the-web-console/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the Cluster",
"previous_url": "/docs/installing-drill-on-the-cluster/",
@@ -6756,7 +6756,7 @@
"title": "Monitoring Metrics",
"url": "/docs/monitoring-metrics/"
},
- "Monitoring and Canceling Queries in the Drill Web Console": {
+ "Monitoring and Canceling Queries in the Drill Web UI": {
"breadcrumbs": [
{
"title": "Query Data",
@@ -6770,8 +6770,8 @@
"previous_title": "Querying System Tables",
"previous_url": "/docs/querying-system-tables/",
"relative_path":
"_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md",
- "title": "Monitoring and Canceling Queries in the Drill Web
Console",
- "url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/"
+ "title": "Monitoring and Canceling Queries in the Drill Web UI",
+ "url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/"
},
"Multiple Drill Clusters": {
"breadcrumbs": [
@@ -8312,8 +8312,8 @@
"next_title": "Performance Tuning Introduction",
"next_url": "/docs/performance-tuning-introduction/",
"parent": "",
- "previous_title": "Monitoring and Canceling Queries in the Drill
Web Console",
- "previous_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/",
+ "previous_title": "Monitoring and Canceling Queries in the Drill
Web UI",
+ "previous_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/",
"relative_path": "_docs/072-performance-tuning.md",
"title": "Performance Tuning",
"url": "/docs/performance-tuning/"
@@ -8934,8 +8934,8 @@
}
],
"children": [],
- "next_title": "Monitoring and Canceling Queries in the
Drill Web Console",
- "next_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/",
+ "next_title": "Monitoring and Canceling Queries in the
Drill Web UI",
+ "next_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/",
"parent": "Query Data",
"previous_title": "Querying the INFORMATION SCHEMA",
"previous_url": "/docs/querying-the-information-schema/",
@@ -8957,8 +8957,8 @@
"previous_title": "Querying System Tables",
"previous_url": "/docs/querying-system-tables/",
"relative_path":
"_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md",
- "title": "Monitoring and Canceling Queries in the Drill
Web Console",
- "url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/"
+ "title": "Monitoring and Canceling Queries in the Drill
Web UI",
+ "url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/"
}
],
"next_title": "Query Data Introduction",
@@ -9628,8 +9628,8 @@
}
],
"children": [],
- "next_title": "Monitoring and Canceling Queries in the Drill Web
Console",
- "next_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/",
+ "next_title": "Monitoring and Canceling Queries in the Drill Web
UI",
+ "next_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/",
"parent": "Query Data",
"previous_title": "Querying the INFORMATION SCHEMA",
"previous_url": "/docs/querying-the-information-schema/",
@@ -13515,8 +13515,8 @@
}
],
"children": [],
- "next_title": "Configuring Web Console and REST API
Security",
- "next_url":
"/docs/configuring-web-console-and-rest-api-security/",
+ "next_title": "Configuring Web UI and REST API Security",
+ "next_url":
"/docs/configuring-web-ui-and-rest-api-security/",
"parent": "Securing Drill",
"previous_title": "Configuring Kerberos Security",
"previous_url": "/docs/configuring-kerberos-security/",
@@ -13542,8 +13542,8 @@
"previous_title": "Configuring Drill to use SPNEGO for
HTTP Authentication",
"previous_url":
"/docs/configuring-drill-to-use-spnego-for-http-authentication/",
"relative_path":
"_docs/configure-drill/securing-drill/092-configuring-web-ui-and-rest-api-security.md",
- "title": "Configuring Web Console and REST API Security",
- "url":
"/docs/configuring-web-console-and-rest-api-security/"
+ "title": "Configuring Web UI and REST API Security",
+ "url": "/docs/configuring-web-ui-and-rest-api-security/"
}
],
"next_title": "Securing Drill Introduction",
@@ -13710,8 +13710,8 @@
}
],
"children": [],
- "next_title": "Starting the Web Console",
- "next_url": "/docs/starting-the-web-console/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the Cluster",
"previous_url": "/docs/installing-drill-on-the-cluster/",
@@ -13761,7 +13761,7 @@
"title": "Starting Drill on Windows",
"url": "/docs/starting-drill-on-windows/"
},
- "Starting the Web Console": {
+ "Starting the Web UI": {
"breadcrumbs": [
{
"title": "Install Drill",
@@ -13775,8 +13775,8 @@
"previous_title": "Starting Drill in Distributed Mode",
"previous_url": "/docs/starting-drill-in-distributed-mode/",
"relative_path": "_docs/install/060-starting-the-web-ui.md",
- "title": "Starting the Web Console",
- "url": "/docs/starting-the-web-console/"
+ "title": "Starting the Web UI",
+ "url": "/docs/starting-the-web-ui/"
},
"Stopping Drill": {
"breadcrumbs": [
@@ -13789,8 +13789,8 @@
"next_title": "Identifying Multiple Drill Versions in a Cluster",
"next_url":
"/docs/identifying-multiple-drill-versions-in-a-cluster/",
"parent": "Install Drill",
- "previous_title": "Starting the Web Console",
- "previous_url": "/docs/starting-the-web-console/",
+ "previous_title": "Starting the Web UI",
+ "previous_url": "/docs/starting-the-web-ui/",
"relative_path": "_docs/install/061-stopping-drill.md",
"title": "Stopping Drill",
"url": "/docs/stopping-drill/"
@@ -16206,8 +16206,8 @@
}
],
"children": [],
- "next_title": "Starting the Web Console",
- "next_url": "/docs/starting-the-web-console/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the
Cluster",
"previous_url":
"/docs/installing-drill-on-the-cluster/",
@@ -16239,8 +16239,8 @@
"previous_title": "Starting Drill in Distributed Mode",
"previous_url":
"/docs/starting-drill-in-distributed-mode/",
"relative_path":
"_docs/install/060-starting-the-web-ui.md",
- "title": "Starting the Web Console",
- "url": "/docs/starting-the-web-console/"
+ "title": "Starting the Web UI",
+ "url": "/docs/starting-the-web-ui/"
},
{
"breadcrumbs": [
@@ -16253,8 +16253,8 @@
"next_title": "Identifying Multiple Drill Versions in a
Cluster",
"next_url":
"/docs/identifying-multiple-drill-versions-in-a-cluster/",
"parent": "Install Drill",
- "previous_title": "Starting the Web Console",
- "previous_url": "/docs/starting-the-web-console/",
+ "previous_title": "Starting the Web UI",
+ "previous_url": "/docs/starting-the-web-ui/",
"relative_path": "_docs/install/061-stopping-drill.md",
"title": "Stopping Drill",
"url": "/docs/stopping-drill/"
@@ -16574,8 +16574,8 @@
}
],
"children": [],
- "next_title": "Configuring Web Console and REST
API Security",
- "next_url":
"/docs/configuring-web-console-and-rest-api-security/",
+ "next_title": "Configuring Web UI and REST API
Security",
+ "next_url":
"/docs/configuring-web-ui-and-rest-api-security/",
"parent": "Securing Drill",
"previous_title": "Configuring Kerberos Security",
"previous_url":
"/docs/configuring-kerberos-security/",
@@ -16601,8 +16601,8 @@
"previous_title": "Configuring Drill to use SPNEGO
for HTTP Authentication",
"previous_url":
"/docs/configuring-drill-to-use-spnego-for-http-authentication/",
"relative_path":
"_docs/configure-drill/securing-drill/092-configuring-web-ui-and-rest-api-security.md",
- "title": "Configuring Web Console and REST API
Security",
- "url":
"/docs/configuring-web-console-and-rest-api-security/"
+ "title": "Configuring Web UI and REST API
Security",
+ "url":
"/docs/configuring-web-ui-and-rest-api-security/"
}
],
"next_title": "Securing Drill Introduction",
@@ -16689,8 +16689,8 @@
"next_title": "Configuring a Multitenant Cluster
Introduction",
"next_url":
"/docs/configuring-a-multitenant-cluster-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring Web Console and REST API
Security",
- "previous_url":
"/docs/configuring-web-console-and-rest-api-security/",
+ "previous_title": "Configuring Web UI and REST API
Security",
+ "previous_url":
"/docs/configuring-web-ui-and-rest-api-security/",
"relative_path":
"_docs/configure-drill/040-configuring-a-multitenant-cluster.md",
"title": "Configuring a Multitenant Cluster",
"url": "/docs/configuring-a-multitenant-cluster/"
@@ -18256,8 +18256,8 @@
}
],
"children": [],
- "next_title": "Monitoring and Canceling Queries in the
Drill Web Console",
- "next_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/",
+ "next_title": "Monitoring and Canceling Queries in the
Drill Web UI",
+ "next_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/",
"parent": "Query Data",
"previous_title": "Querying the INFORMATION SCHEMA",
"previous_url": "/docs/querying-the-information-schema/",
@@ -18279,8 +18279,8 @@
"previous_title": "Querying System Tables",
"previous_url": "/docs/querying-system-tables/",
"relative_path":
"_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md",
- "title": "Monitoring and Canceling Queries in the Drill
Web Console",
- "url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/"
+ "title": "Monitoring and Canceling Queries in the Drill
Web UI",
+ "url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/"
}
],
"next_title": "Query Data Introduction",
@@ -18784,8 +18784,8 @@
"next_title": "Performance Tuning Introduction",
"next_url": "/docs/performance-tuning-introduction/",
"parent": "",
- "previous_title": "Monitoring and Canceling Queries in the Drill
Web Console",
- "previous_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-console/",
+ "previous_title": "Monitoring and Canceling Queries in the Drill
Web UI",
+ "previous_url":
"/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/",
"relative_path": "_docs/072-performance-tuning.md",
"title": "Performance Tuning",
"url": "/docs/performance-tuning/"
diff --git a/_docs/query-data/070-query-sys-tbl.md
b/_docs/query-data/070-query-sys-tbl.md
index 19d0f31..65c1753 100644
--- a/_docs/query-data/070-query-sys-tbl.md
+++ b/_docs/query-data/070-query-sys-tbl.md
@@ -1,14 +1,14 @@
---
title: "Querying System Tables"
-date: 2018-12-08
+date: 2018-12-10
parent: "Query Data"
---
-Drill has a sys database that contains system tables. You can query the system
tables for information about Drill, such as available configuration options and
the Drill version running on the system. Starting in Drill 1.15, you can query
the functions table expose the available built-in SQL functions and
user-defined functions.
+Drill has a sys database that contains system tables. You can query the system
tables for information about Drill, such as available configuration options and
the Drill version running on the system. Starting in Drill 1.15, you can query
the functions table to expose built-in SQL functions and user-defined
functions.
## Viewing Drill Databases
-When you run the `SHOW DATABASES` command, Drill returns the list of available
databases/schemas that you can query. In the following example, you can see
that Drill returns the sys database/schema:
+When you run the `SHOW DATABASES` command, Drill returns the list of available
databases that you can query. In the following example, you can see that Drill
returns the sys database:
SHOW DATABASES;
+--------------------+
@@ -28,7 +28,7 @@ When you run the `SHOW DATABASES` command, Drill returns the
list of available d
+--------------------+
-## Switching to the System Database/Schema
+## Switching to the sys Database
The USE command changes the schema context to the specified schema. When you
switch to the sys schema, as shown, Drill issues all subsequent queries against
that schema only:
@@ -43,7 +43,7 @@ The USE command changes the schema context to the specified
schema. When you swi
## Viewing System Tables
-When you run the `SHOW TABLES` command, Drill returns the list of system
tables that you can query for information about Drill:
+When you run the `SHOW TABLES` command against the sys database, Drill returns
the list of system tables that you can query for information about Drill:
SHOW TABLES;
+---------------+-----------------------+
@@ -69,7 +69,7 @@ When you run the `SHOW TABLES` command, Drill returns the
list of system tables
The following sections show examples of queries against the system tables
available in the sys database/schema.
-###Querying the drillbits table
+###Querying the drillbits Table
SELECT * FROM drillbits;
+-------------------+------------+--------------+------------+---------+
@@ -96,7 +96,7 @@ Apache Drill.
True means the Drillbit is connected to the session or client running the
query. This Drillbit is the Foreman for the current session.
-### Querying the version table
+### Querying the version Table
SELECT * FROM version;
+-------------------------------------------+--------------------------------------------------------------------+----------------------------+--------------+----------------------------+
@@ -118,11 +118,11 @@ example.
* **build_time**
The time that the release was built.
-### Querying the options table
+### Querying the options Table
-Drill provides system, session, and boot options that you can query.
+The options table contains system, session, and boot options that you can
query.
-The following example shows a query on the system options:
+The following example shows a query on the options table that returns ten of
the system options:
SELECT * FROM options WHERE type='SYSTEM' LIMIT 10;
+-------------------------------------------------+----------+---------+----------+-------------+-------------+-----------+------------+
@@ -159,7 +159,7 @@ The default value, which is true or false; otherwise, null.
The default value, which is of the double, float, or long double data type;
otherwise, null.
-### Querying the boot table
+### Querying the boot Table
SELECT * FROM boot LIMIT 10;
+--------------------------------------+----------+-------+---------+------------+-------------------------+-----------+------------+
@@ -196,7 +196,7 @@ The default value, which is true or false; otherwise, null.
The default value, which is of the double, float, or long double data type;
otherwise, null.
-### Querying the threads table
+### Querying the threads Table
SELECT * FROM threads;
+--------------------+------------+----------------+---------------+
@@ -218,7 +218,7 @@ The peak thread count on the node.
* **busy_threads**
The current number of live threads (daemon and non-daemon) on the node.
-### Querying the memory table
+### Querying the memory Table
SELECT * FROM memory;
+--------------------+------------+---------------+-------------+-----------------+---------------------+-------------+
@@ -247,7 +247,7 @@ The current JVM direct memory allocation, in bytes.
The maximum direct memory available to the allocator, in bytes.
-### Querying the connections table
+### Querying the connections Table
SELECT * FROM connections limit 3;
+------------+--------------+------------+--------------------------+------------------------+----------+------------------+--------------+-----------+---------------------------------------+
@@ -268,7 +268,7 @@ The connections table provides the following information
about the connection to
- security for the connection
- session ID
-### Querying the profiles_json table
+### Querying the profiles_json Table
SELECT * FROM profiles_json LIMIT 1;
+---------------------------------------+----------------------------------------------------------------------------------+
@@ -277,15 +277,16 @@ The connections table provides the following information
about the connection to
| 23f4e2a7-5d60-a766-0b03-d7a03e99033e |
{"id":{"part1":2590944894098909030,"part2":793715042592293694},"type":1,"start":1544232280280,"end":1544232280309,"query":"SELECT
* FROM profiles_json LIMIT 0","plan":"00-00 Screen : rowType =
RecordType(VARCHAR(65536) queryId, VARCHAR(65536) json): rowcount = 1.0,
cumulative cost = {1.1 rows, 2.1 cpu, 1.0 io, 0.0 network, 0.0 memory}, id =
2115\n00-01 Project(queryId=[$0], json=[$1]) : rowType =
RecordType(VARCHAR(65536) queryId, VARCH [...]
+---------------------------------------+----------------------------------------------------------------------------------+
-The profiles_json provides the query profile in JSON format for all queries,
by queryID.
+The profiles_json table provides the query profile in JSON format for all
queries, by queryID.
-### Querying the options table
+### Querying the options Table
-The options table contains configuration options available in Drill. You can
set most of the options at the system or session level. Starting in Drill 1.15,
a new options table lists option descriptions, the value that the option is
currently set to, and the status of the option. Status shows if the value for
the option has been changed from the default. You can query the new and old
options table, as shown in the examples below.
+The options table contains configuration options available in Drill that you
can set at the system or session level. Starting in Drill 1.15, a new options
table lists option descriptions. You can query the latest and previous options
table, as shown in the examples below.
+
+**Note:** Option names are case-sensitive.
The following query selects all of the options related to memory from the new
options table:
-
-**Note:** Option names are case-sensitive.
+
SELECT * FROM options WHERE name LIKE '%memory%';
+----------------------------------------------------------------+---------+-------------------+-------------+----------+--------------+----------------------------------------------------------------------------------+
@@ -308,9 +309,9 @@ The following query selects all of the options related to
memory from the new op
+----------------------------------------------------------------+---------+-------------------+-------------+----------+--------------+----------------------------------------------------------------------------------+
-The following query selects three of the options related to memory from the
old options table:
+The following query selects three of the options related to memory from the
pre-1.15 options table:
-**Note:** Notice that the old options table contains _val columns, which have
been removed from the options table introduced in Drill 1.15.
+**Note:** Notice that the table contains _val columns, which have been removed
from the latest options table (introduced in Drill 1.15).
SELECT * FROM options_old WHERE name LIKE '%memory%' LIMIT 3;
+----------------------------------------------------------------+----------+-------------------+--------------+----------+-----------+-------------+-----------+------------+
@@ -322,7 +323,7 @@ The following query selects three of the options related to
memory from the old
+----------------------------------------------------------------+----------+-------------------+--------------+----------+-----------+-------------+-----------+------------+
-### Querying the functions table
+### Querying the functions Table
The functions table is available starting in Drill 1.15. The functions table
exposes the available SQL functions in Drill and also detects UDFs that have
been dynamically loaded into Drill. You can query the functions table to see
the following information about built-in and user-defined functions in Drill:
