Re: Aggregate function definition with two numeric arguments

2022-10-30 Thread Benchao Li
> > I’m getting this error: > java.sql.SQLException: Error while executing SQL "SELECT > percentile(159900102,1) as d": There are not enough rules to produce a node > with desired properties: convention=ENUMERABLE, sort=[]. > Missing conversion is LogicalAggregate[convention: NONE -> ENUMERABLE] >

Aggregate function definition with two numeric arguments

2022-10-26 Thread James Scicluna
Hi team, I’m trying to add a definition for Hive’s percentile(BIGINT col, p) function. I tried to build this definition following on the similar