[
https://issues.apache.org/jira/browse/DRILL-6790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bridget Bevens resolved DRILL-6790.
-----------------------------------
Resolution: Fixed
Fix Version/s: (was: 1.16.0)
1.15.0
Page is updated.
> 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
> Assignee: Bridget Bevens
> Priority: Major
> Labels: doc-complete
> 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)
