[jira] [Closed] (DRILL-5043) Function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID()

["Krystal (JIRA)" <ji...@apache.org>]

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

Krystal closed DRILL-5043.
--------------------------

Verified that session_id function works as expected via the following tests:
1. Each sqlline session returns different session_id.
2. In the same session, multiple "select session_id" queries return the same result.
3. For table with column name of "session_id", using table alias with column in the select clause returns data for column.
4. Ran tests from sqlline and Web UI; with and without impersonation.

> Function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID()
> -------------------------------------------------------------------------------------------
>
>                 Key: DRILL-5043
>                 URL: https://issues.apache.org/jira/browse/DRILL-5043
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Functions - Drill
>    Affects Versions: 1.8.0
>            Reporter: Nagarajan Chinnasamy
>            Assignee: Arina Ielchiieva
>            Priority: Minor
>              Labels: CONNECTION_ID, SESSION, UDF, doc-impacting
>             Fix For: 1.10.0
>
>         Attachments: 01_session_id_sqlline.png, 02_session_id_webconsole_query.png, 03_session_id_webconsole_result.png
>
>
> Design and implement a function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID().
> *Implementation details*
> function *session_id* will be added. Function returns current session unique id represented as string. Parameter {code:java} boolean isNiladic{code} will be added to UDF FunctionTemplate to indicate if a function is niladic (a function to be called without any parameters and parentheses)
> Please note, this function will override columns that have the same name. Table alias should be used to retrieve column value from table.
> Example:
> {code:sql}select session_id from <table>  // returns the value of niladic function session_id {code} 
> {code:sql}select t1.session_id from <table> t1 // returns session_id column value from table {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)