[
https://issues.apache.org/jira/browse/DRILL-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15860022#comment-15860022
]
ASF GitHub Bot commented on DRILL-5043:
---------------------------------------
Github user nagarajanchinnasamy closed the pull request at:
https://github.com/apache/drill/pull/685
> 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
> 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)
