Re: Suggestion for topics for Drill hangout tomorrow

Drill way of invoking UDFs without parenthesis Best Regards, Nagu. On Tue, Jan 10, 2017 at 11:41 PM, Aman Sinha wrote: > Hangout starting .. link: https://plus.google.com/hangouts/_/event/ > ci4rdiju8bv04a64efj5fedd0lc > > On 1/9/17, 5:24 PM, "Aman Sinha"

Get/Set Session Options from UDFs

Hi, I need to get/set session options from a UDF that I am developing. Please let me know how I can do this. Best Regards, Nagu.

Re: MySQL CONNECTION_ID() equivalent in Drill

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

MySQL CONNECTION_ID() equivalent in Drill

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:

Querying MySQL View Fails with DATA_READ ERROR

Facing this problem with: MySQL Version: 5.7.8 Drill Version: 1.7 and 1.8 MySQL JDBC Connector: mysql-connector-java-5.1.39-bin.jar I have created a view on MySQL using the following query: create or replace view `mydb`.`customerview` as select `cust`.`Id` as `Customer`, `tnt`.`Id` as `Tenant`