Re: how to query the output of the scalar table function

2018-04-04 Thread Darshan Singh
Thanks Fabian We are going to replace all scalar functions with the table functions. Thanks On Wed, Apr 4, 2018 at 12:16 PM, Fabian Hueske wrote: > Hi Darshan, > > What you observe is the result of what's supposed to be an optimization. > By fusing the two select() calls, we reduce the number

Re: how to query the output of the scalar table function

2018-04-04 Thread Fabian Hueske
Hi Darshan, What you observe is the result of what's supposed to be an optimization. By fusing the two select() calls, we reduce the number of operators in the resulting plan (one MapFunction less). This optimization is only applied for ScalarFunctions but not for TableFunctions. With a better cos

how to query the output of the scalar table function

2018-03-30 Thread Darshan Singh
Hi, I am not able to find what is best way to query the output of a scalar table function. Suppose I have table which has column col1 which is string. I have a scalar function and returns a POJO {col1V1 String, col1V2 String , col1V3 String}. I am using following. so table.select("sf(col1) as