[DRILL-5222] C++ client unable to parse queries with table function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.10.0
• Component/s: Client - C++
• Assignee: Unassigned
• Reporter: Krystal
• Created: 25/Jan/17 16:57
• Updated: 25/Jan/17 20:59
• Resolved: 25/Jan/17 20:59

Description

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:

           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