[ https://issues.apache.org/jira/browse/DRILL-6790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bridget Bevens updated DRILL-6790: ---------------------------------- Labels: doc-impacting (was: ) > 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 > Priority: Major > Labels: doc-impacting > 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)