N Campbell created DRILL-4400: --------------------------------- Summary: Cannot apply 'NOT' to arguments of type 'NOT<CHAR(2)>'. Key: DRILL-4400 URL: https://issues.apache.org/jira/browse/DRILL-4400 Project: Apache Drill Issue Type: Wish Components: Server Affects Versions: 1.5.0 Reporter: N Campbell
select tjoin2.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from postgres.public.tjoin1 inner join postgres.public.tjoin2 on ( tjoin1.c1 = tjoin2.c1 and not tjoin2.c2 = 'AA' ) Error: VALIDATION ERROR: From line 1, column 154 to line 1, column 163: Cannot apply 'NOT' to arguments of type 'NOT<CHAR(2)>'. Supported form(s): 'NOT<BOOLEAN>' [Error Id: f781f07a-2361-4f3d-8f03-0a3f1ddec8f0 on centos1:31010] (org.apache.calcite.tools.ValidationException) org.apache.calcite.runtime.CalciteContextException: From line 1, column 154 to line 1, column 163: Cannot apply 'NOT' to arguments of type 'NOT<CHAR(2)>'. Supported form(s): 'NOT<BOOLEAN>' org.apache.calcite.prepare.PlannerImpl.validate():189 org.apache.calcite.prepare.PlannerImpl.validateAndGetType():198 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():451 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():198 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():167 org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():199 org.apache.drill.exec.work.foreman.Foreman.runSQL():924 org.apache.drill.exec.work.foreman.Foreman.run():250 java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$Worker.run():617 java.lang.Thread.run():745 Caused By (org.apache.calcite.runtime.CalciteContextException) From line 1, column 154 to line 1, column 163: Cannot apply 'NOT' to arguments of type 'NOT<CHAR(2)>'. Supported form(s): 'NOT<BOOLEAN>' sun.reflect.GeneratedConstructorAccessor66.newInstance():-1 sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45 java.lang.reflect.Constructor.newInstance():422 org.apache.calcite.runtime.Resources$ExInstWithCause.ex():405 org.apache.calcite.sql.SqlUtil.newContextException():714 org.apache.calcite.sql.SqlUtil.newContextException():702 org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():3931 org.apache.calcite.sql.SqlCallBinding.newValidationSignatureError():275 org.apache.calcite.sql.type.FamilyOperandTypeChecker.checkSingleOperandType():92 org.apache.calcite.sql.type.FamilyOperandTypeChecker.checkOperandTypes():109 org.apache.calcite.sql.SqlOperator.checkOperandTypes():563 org.apache.calcite.sql.SqlOperator.validateOperands():420 org.apache.calcite.sql.SqlOperator.deriveType():487 org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4268 org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4255 org.apache.calcite.sql.SqlCall.accept():130 org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl():1495 org.apache.calcite.sql.validate.SqlValidatorImpl.deriveType():1478 org.apache.calcite.sql.type.InferTypes$1.inferOperandTypes():51 org.apache.calcite.sql.validate.SqlValidatorImpl.inferUnknownTypes():1672 org.apache.calcite.sql.validate.SqlValidatorImpl.inferUnknownTypes():1678 org.apache.calcite.sql.validate.SqlValidatorImpl.validateWhereOrOn():3370 org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin():2814 org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2772 org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():2986 org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60 org.apache.calcite.sql.validate.AbstractNamespace.validate():86 org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():877 org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():863 org.apache.calcite.sql.SqlSelect.validate():210 org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():837 org.apache.calcite.sql.validate.SqlValidatorImpl.validate():551 org.apache.calcite.prepare.PlannerImpl.validate():187 org.apache.calcite.prepare.PlannerImpl.validateAndGetType():198 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():451 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():198 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():167 org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():199 org.apache.drill.exec.work.foreman.Foreman.runSQL():924 org.apache.drill.exec.work.foreman.Foreman.run():250 java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$Worker.run():617 java.lang.Thread.run():745 Caused By (org.apache.calcite.sql.validate.SqlValidatorException) Cannot apply 'NOT' to arguments of type 'NOT<CHAR(2)>'. Supported form(s): 'NOT<BOOLEAN>' sun.reflect.GeneratedConstructorAccessor65.newInstance():-1 sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45 java.lang.reflect.Constructor.newInstance():422 org.apache.calcite.runtime.Resources$ExInstWithCause.ex():405 org.apache.calcite.runtime.Resources$ExInst.ex():514 org.apache.calcite.sql.SqlUtil.newContextException():714 org.apache.calcite.sql.SqlUtil.newContextException():702 org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():3931 org.apache.calcite.sql.SqlCallBinding.newValidationSignatureError():275 org.apache.calcite.sql.type.FamilyOperandTypeChecker.checkSingleOperandType():92 org.apache.calcite.sql.type.FamilyOperandTypeChecker.checkOperandTypes():109 org.apache.calcite.sql.SqlOperator.checkOperandTypes():563 org.apache.calcite.sql.SqlOperator.validateOperands():420 org.apache.calcite.sql.SqlOperator.deriveType():487 org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4268 org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit():4255 org.apache.calcite.sql.SqlCall.accept():130 org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl():1495 org.apache.calcite.sql.validate.SqlValidatorImpl.deriveType():1478 org.apache.calcite.sql.type.InferTypes$1.inferOperandTypes():51 org.apache.calcite.sql.validate.SqlValidatorImpl.inferUnknownTypes():1672 org.apache.calcite.sql.validate.SqlValidatorImpl.inferUnknownTypes():1678 org.apache.calcite.sql.validate.SqlValidatorImpl.validateWhereOrOn():3370 org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin():2814 org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2772 org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():2986 org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60 org.apache.calcite.sql.validate.AbstractNamespace.validate():86 org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():877 org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():863 org.apache.calcite.sql.SqlSelect.validate():210 org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():837 org.apache.calcite.sql.validate.SqlValidatorImpl.validate():551 org.apache.calcite.prepare.PlannerImpl.validate():187 org.apache.calcite.prepare.PlannerImpl.validateAndGetType():198 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():451 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():198 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():167 org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():199 org.apache.drill.exec.work.foreman.Foreman.runSQL():924 org.apache.drill.exec.work.foreman.Foreman.run():250 java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$Worker.run():617 java.lang.Thread.run():745 SQLState: null ErrorCode: 0 create table TJOIN1 (RNUM integer not null , C1 integer, C2 integer); insert into TJOIN1 (RNUM, C1, C2) values ( 0, 10, 15); insert into TJOIN1 (RNUM, C1, C2) values ( 1, 20, 25); insert into TJOIN1 (RNUM, C1, C2) values ( 2, NULL, 50); create table TJOIN2 (RNUM integer not null , C1 integer, C2 char(2)); insert into TJOIN2 (RNUM, C1, C2) values ( 0, 10, 'BB'); insert into TJOIN2 (RNUM, C1, C2) values ( 1, 15, 'DD'); insert into TJOIN2 (RNUM, C1, C2) values ( 2, NULL, 'EE'); insert into TJOIN2 (RNUM, C1, C2) values ( 3, 10, 'FF'); -- This message was sent by Atlassian JIRA (v6.3.4#6332)