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