Re: Drill UDF input - pass variable list of strings

Thanks Charles. We will give it a try and let you know if it works out On Fri, Feb 10, 2017 at 12:54 AM, Charles Givre wrote: > Hi Sandeep, > You might want to look into the ComplexHolder as an option. I haven’t > tried this, but I’d think that you could specify an input

Re: How to avoid case sensitivity in group by

How about the following: 0: jdbc:drill:schema=dfs.tpchRaw> select lower(state), sum(price) from junk group by lower(state); +--+-+ | EXPR$0 | EXPR$1 | +--+-+ | alaska | 165 | | florida | 170 | | texas| 80 | +--+-+ 3 rows

Re: Drill UDF input - pass variable list of strings

Hi Sandeep, You might want to look into the ComplexHolder as an option. I haven’t tried this, but I’d think that you could specify an input param as a ComplexHolder. I’m not sure if this would work or not, but also take a look at the implementation of KVGEN(). I hope this helps, - C > On

Re: Drill UDF input - pass variable list of strings

Jin, we are looking for passing list as input to a function something like function(col1,[1,2,3]), I feel this is doable Just not able to find a way to pass the second parameter as array input On Thu, Feb 9, 2017 at 11:22 PM, Jinfeng Ni wrote: > AFAIK, Drill currently does not

Re: Drill UDF input - pass variable list of strings

AFAIK, Drill currently does not allow variable size of parameters in UDF in general (built-in function concat is specially handled internally). Someone once intended to add such support. Looks like that work has not been completed yet. On Thu, Feb 9, 2017 at 6:51 AM, Sandeep Dugar

Drill UDF input - pass variable list of strings

Hi, I am trying to write a UDF which will whether a list of strings is contained in another list. Is there a way to pass a list of values to UDF where the list size is variable? Thanks in advance! - Regards, Sandeep

Re: Storage Plugin for accessing Hive ORC Table from Drill

First of all, sorry for late reply. @Chunhui, you are right. we are using Hive 2.0 And are we planning to update hive libraries in next release of drill? @rahul, as you said i have created another table with just "use stored as orc" but all column and now drill is able to read it. Do you have

Re: How to avoid case sensitivity in group by

Hello This is my input table in db:- State Price Alaska 75 Texas 80 Alaska 90 Florida 100 florida 70 Sql Server Query:- select State, Sum (Price) from testTable group by State. Sql Server Output:- State Price Alaska 165 Texas 80 Florida 170 Drill Query:- select T1.State, Sum(T1.Price) from