Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6790

Updating SET and ALTER SYSTEM doc pages

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.14.0
    • Fix Version/s: 1.15.0
    • Component/s: Documentation
    • Labels:

      Description

      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:

      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)
      

      DRILL-5723 introduces new fields for "sys.options" system table.
      The "type" field could be replaced with "optionScope":

      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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bbevens Bridget Bevens
                Reporter:
                vitalii Vitalii Diravka
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: