You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Vitalii Diravka (JIRA)" <ji...@apache.org> on 2018/10/11 15:16:00 UTC
[jira] [Created] (DRILL-6790) Updating SET and ALTER SYSTEM doc
pages
Vitalii Diravka created DRILL-6790:
--------------------------------------
Summary: Updating SET and ALTER SYSTEM doc pages
Key: DRILL-6790
URL: https://issues.apache.org/jira/browse/DRILL-6790
Project: Apache Drill
Issue Type: Task
Components: Documentation
Affects Versions: 1.14.0
Reporter: Vitalii Diravka
Fix For: 1.15.0
It is necessary to update old queries related to "sys.options" table in SET [https://drill.apache.org/docs/set/] and ALTER SYSTEM [https://drill.apache.org/docs/alter-system/] drill doc pages:
{code}
0: jdbc:drill:zk=local> SELECT name, type, bool_val FROM sys.options WHERE type = 'SESSION' order by name;
18:04:32.669 [2440997e-a5e7-4458-b7f9-661df830db5f:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.sql.validate.SqlValidatorException: Column 'type' not found in any table
18:04:32.670 [2440997e-a5e7-4458-b7f9-661df830db5f:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteContextException: From line 1, column 52 to line 1, column 55: Column 'type' not found in any table
Error: VALIDATION ERROR: From line 1, column 52 to line 1, column 55: Column 'type' not found in any table
[Error Id: ffb96168-50e6-4d38-baa1-09429f3f191b on vitalii-pc:31010] (state=,code=0)
{code}
DRILL-5723 introduces new fields for "sys.options" system table.
The "type" field could be replaced with "optionScope":
{code}
0: jdbc:drill:zk=local> SELECT * FROM sys.options WHERE optionScope in ('SYSTEM','SESSION') order by name;
+-------------------------------------------------+-------+-------------------+--------+----------+--------------+-----------------------------------------------------------------------------+
| name | kind | accessibleScopes | val | status | optionScope | description |
+-------------------------------------------------+-------+-------------------+--------+----------+--------------+-----------------------------------------------------------------------------+
| drill.exec.functions.cast_empty_string_to_null | BIT | ALL | true | CHANGED | SESSION | In a text file, treat empty fields as NULL values instead of empty string. |
| drill.exec.hashagg.fallback.enabled | BIT | ALL | false | DEFAULT | SYSTEM | |
+-------------------------------------------------+-------+-------------------+--------+----------+--------------+-----------------------------------------------------------------------------+
2 rows selected (0.113 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)