[ 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 Updated patch which returns a merged list of session and query options. > 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, > 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)