Krystal created DRILL-5222:
------------------------------
Summary: 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)
