Hi Yuzhao, I use SqlStdOperatorTable like this:
val defaultValidator = SqlValidatorUtil.newValidator(new SqlStdOperatorTable(), calciteCatelogReader, sqlTypeFactoryImpl, SqlConformanceEnum.LENIENT) ... val sqlToRelConverter = new SqlToRelConverter(planner, defaultValidator, calciteCatelogReader, relExpressionOptimizationCluster, StandardConvertletTable.INSTANCE, sqlToRelConfig) Thanks, Michael > On Mar 26, 2019, at 7:01 PM, Yuzhao Chen <[email protected]> wrote: > > So what is the SqlOperatorTable you use, usually we use a > SqlStdOperatorTable(for builtin operators) chained with a > ListSqlOperatorTable(for UDFs), for your case, a single SqlStdOperatorTable > is enough. > >> Michael Tu <[email protected]>于2019年3月27日 周三上午8:37写道： >> Hi All, >> >> I’m a new user to Apache Calcite and have a question about a >> SqlValidatorException being thrown regarding SUM or COUNT aggregate >> functions not found during SQL to relational algebra conversion using >> SqlToRelConverter.convertQuery. >> >> The detailed question is on Stack Overflow: >> https://stackoverflow.com/questions/55367966/converting-sql-query-with-aggregate-function-to-relational-algebra-expression-in >> >> <https://stackoverflow.com/questions/55367966/converting-sql-query-with-aggregate-function-to-relational-algebra-expression-in>. >> >> If anyone has any insights it would be greatly appreciated! >> >> Thanks in advance. >> >> -Michael
