You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Aditya Kishore (JIRA)" <ji...@apache.org> on 2014/10/08 13:37:34 UTC

[jira] [Updated] (DRILL-1505) Updating Session Value Doesn't Reflect In 'sys.options' Query Output

     [ https://issues.apache.org/jira/browse/DRILL-1505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aditya Kishore updated DRILL-1505:
----------------------------------
    Attachment: DRILL-1505-Updating-Session-Value-Doesn-t-Reflect-In.patch

> Updating Session Value Doesn't Reflect In 'sys.options' Query Output
> --------------------------------------------------------------------
>
>                 Key: DRILL-1505
>                 URL: https://issues.apache.org/jira/browse/DRILL-1505
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 0.5.0
>            Reporter: MUFEED USMAN
>            Assignee: Aditya Kishore
>            Priority: Critical
>         Attachments: DRILL-1505-Updating-Session-Value-Doesn-t-Reflect-In.patch
>
>
> Even after updating the value for a session option, the value when queried reflects the default value. How to know what is the value for the current session?
> [root@n69 bin]# ./sqlline -u jdbc:drill:zk=n69:5181,n72:5181,n73:5181 -n admin -p admin
> sqlline version 1.1.6
> 0: jdbc:drill:zk=n69:5181,n72:5181,n73:5181> alter session set `exec.errors.verbose`=true;
> +------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | true       | exec.errors.verbose updated. |
> +------------+------------+
> 1 row selected (0.185 seconds)
> 0: jdbc:drill:zk=n69:5181,n72:5181,n73:5181> select * from sys.options where name = 'exec.errors.verbose';
> +------------+------------+------------+------------+------------+------------+------------+
> |    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val  |
> +------------+------------+------------+------------+------------+------------+------------+
> | exec.errors.verbose | BOOLEAN    | SYSTEM     | null       | null       | false      | null       |
> +------------+------------+------------+------------+------------+------------+------------+
> 1 row selected (0.192 seconds)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)