Apache Drill
  1. Apache Drill
  2. DRILL-845

Right outer join fails while setting up foreman

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: SQL Parser
    • Labels:
      None

      Description

      git.commit.id.abbrev=5b8f8d8

      0: jdbc:drill:schema=dfs> select student.name, voter.registration from student right outer join voter on (student.name = voter.name) where student.age < 30;

      message: "Failure while setting up Foreman. < AssertionError"

        Activity

        Hide
        Krystal added a comment -

        git.commit.id.abbrev=79c1502

        The query runs successfully in this build.

        Show
        Krystal added a comment - git.commit.id.abbrev=79c1502 The query runs successfully in this build.
        Hide
        Krystal added a comment -

        If just run the query without the where clause, the query ran successfully. Get the error mentioned in the bug when adding "where student.age < 30" to the query.

        Show
        Krystal added a comment - If just run the query without the where clause, the query ran successfully. Get the error mentioned in the bug when adding "where student.age < 30" to the query.
        Hide
        Krystal added a comment -

        stack trace:

        ava.lang.AssertionError
        org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.getRootField(SqlToRelConverter.java:3932) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.adjustInputRef(SqlToRelConverter.java:3214) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:3189) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.access$1400(SqlToRelConverter.java:62) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4220) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:3611) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:4116) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3427) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:519) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:474) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2787) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:432) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        net.hydromatic.optiq.prepare.PlannerImpl.convert(PlannerImpl.java:192) ~[optiq-core-0.7-20140513.013236-5.jar:na]
        org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRel(DefaultSqlHandler.java:124) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:106) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:129) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:313) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:167) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
        java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
        java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
        java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]

        Show
        Krystal added a comment - stack trace: ava.lang.AssertionError org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.getRootField(SqlToRelConverter.java:3932) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.adjustInputRef(SqlToRelConverter.java:3214) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:3189) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.access$1400(SqlToRelConverter.java:62) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4220) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:3611) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:4116) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.convertSelectList(SqlToRelConverter.java:3427) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:519) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:474) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2787) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:432) ~ [optiq-core-0.7-20140513.013236-5.jar:na] net.hydromatic.optiq.prepare.PlannerImpl.convert(PlannerImpl.java:192) ~ [optiq-core-0.7-20140513.013236-5.jar:na] org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRel(DefaultSqlHandler.java:124) ~ [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:106) ~ [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:129) ~ [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:313) ~ [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:167) ~ [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45] java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45] java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]

          People

          • Assignee:
            Jacques Nadeau
            Reporter:
            Krystal
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development