[ https://issues.apache.org/jira/browse/DRILL-5222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-5222. -------------------------- Resolution: Not A Bug > C++ client unable to parse queries with table function > ------------------------------------------------------ > > Key: DRILL-5222 > URL: https://issues.apache.org/jira/browse/DRILL-5222 > Project: Apache Drill > Issue Type: Bug > Components: Client - C++ > Affects Versions: 1.10.0 > Reporter: Krystal > > The following query failed from was odbc and custom C++ client app: > SQL>select columns[0] from table(`table_function/cr_lf.csv`(type=>'text', > lineDelimiter=>'\r\n')) > 1: SQLPrepare = [MapR][Drill] (1040) Drill failed to execute the query: > select columns[0] from table(`table_function/cr_lf.csv`(type=>'text', > lineDelimiter=>'\r\n')) > [30027]Query execution error. Details:[ > SYSTEM ERROR: SqlValidatorException: No match found for function signature > table_function/cr_lf.csv(type => <CHARACTER>, lineDelimiter => <CHARACTER>) > Here is the stack trace: > {code} > SYSTEM ERROR: SqlValidatorException: No match found for function > signature table_function/cr_lf.csv(type => , lineDelimiter => ) > (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception > during fragment initialization: No match found for function signature > table_function/cr_lf.csv(type => , lineDelimiter => ) > org.apache.drill.exec.work.foreman.Foreman.run():281 > java.util.concurrent.ThreadPoolExecutor.runWorker():1145 > java.util.concurrent.ThreadPoolExecutor$Worker.run():615 > java.lang.Thread.run():745 > Caused By (org.apache.drill.exec.exception.FunctionNotFoundException) No > match found for function signature table_function/cr_lf.csv(type => , > lineDelimiter => ) > org.apache.drill.exec.planner.sql.SqlConverter.validate():170 > > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():606 > > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():192 > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():164 > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():122 > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():96 > org.apache.drill.exec.work.foreman.Foreman.runSQL():1017 > org.apache.drill.exec.work.foreman.Foreman.run():264 > java.util.concurrent.ThreadPoolExecutor.runWorker():1145 > java.util.concurrent.ThreadPoolExecutor$Worker.run():615 > java.lang.Thread.run():745 > Caused By (org.apache.calcite.runtime.CalciteContextException) From line 1, > column 45 to line 1, column 107: No match found for function signature > table_function/cr_lf.csv(type => , lineDelimiter => ) > sun.reflect.NativeConstructorAccessorImpl.newInstance0():-2 > sun.reflect.NativeConstructorAccessorImpl.newInstance():57 > sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45 > java.lang.reflect.Constructor.newInstance():526 > org.apache.calcite.runtime.Resources$ExInstWithCause.ex():405 > org.apache.calcite.sql.SqlUtil.newContextException():765 > org.apache.calcite.sql.SqlUtil.newContextException():753 > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():3974 > > org.apache.calcite.sql.validate.SqlValidatorImpl.handleUnresolvedFunction():1583 > org.apache.calcite.sql.SqlFunction.deriveType():278 > org.apache.calcite.sql.SqlFunction.deriveType():222 > > org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4337 > > org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4324 > org.apache.calcite.sql.SqlCall.accept():130 > org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl():1501 > org.apache.calcite.sql.validate.ProcedureNamespace.validateImpl():53 > org.apache.calcite.sql.validate.AbstractNamespace.validate():86 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2806 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2791 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3014 > org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60 > org.apache.calcite.sql.validate.AbstractNamespace.validate():86 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2806 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2791 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3014 > org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60 > org.apache.calcite.sql.validate.AbstractNamespace.validate():86 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():883 > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():869 > org.apache.calcite.sql.SqlSelect.validate():210 > > org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():843 > org.apache.calcite.sql.validate.SqlValidatorImpl.validate():557 > org.apache.drill.exec.planner.sql.SqlConverter.validate():164 > > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():606 > > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():192 > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():164 > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():122 > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():96 > org.apache.drill.exec.work.foreman.Foreman.runSQL():1017 > org.apache.drill.exec.work.foreman.Foreman.run():264 > java.util.concurrent.ThreadPoolExecutor.runWorker():1145 > java.util.concurrent.ThreadPoolExecutor$Worker.run():615 > java.lang.Thread.run():745 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)