You could consider contributing a UDF (user-defined function) for the same. If the UserSession were to contain a unique ID per session it is pretty straightforward to pass it along to the UDF which would return it to the caller.
After this, you could then invoke it just like MySQL e.g. *SELECT MY_CONNECTION_ID_UDF() FROM TABLE;* *If interested, please start by filing an Apache Drill JIRA.* On Mon, Nov 14, 2016 at 2:01 AM, Nagarajan Chinnasamy < [email protected]> wrote: > Hi, > > I would like to know if there is a function or column in system tables that > is equivalent to MySQL's CONNECTION_ID function. > > I am basically trying to achieve the technique answered by Justin Swanhart > for the following stackoverflow question: > > http://stackoverflow.com/questions/2281890/can-i- > create-view-with-parameter-in-mysql > > > Best Regards, > Nagu. >
