Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1889

UndefinedColumnException when a query with table subquery is executed on self-describing tables

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: Planner/Optimizer
    • Labels:
      None

      Description

      Here is the log.

      default> select title1, title2, null_expected, sortas, abbrev from (
      select
        glossary.title title1,
        glossary."GlossDiv".title title2,
        glossary."GlossDiv".null_expected null_expected,
        glossary."GlossDiv"."GlossList"."GlossEntry"."SortAs" sortas,
        glossary."GlossDiv"."GlossList"."GlossEntry"."Abbrev" abbrev
      from
        self_desc_table2
        where glossary.title is not null) t
      
      ...
      2015-09-24 18:35:44,833 ERROR: org.apache.tajo.master.GlobalEngine (printStackTrace(188)) - 
      Stack Trace:
      org.apache.tajo.exception.UndefinedColumnException: column 'glossary.title' does not exist
      	at org.apache.tajo.plan.nameresolver.NameResolver.lookupQualifierAndCanonicalName(NameResolver.java:429)
      	at org.apache.tajo.plan.nameresolver.NameResolver.resolveFromRelsWithinBlock(NameResolver.java:162)
      	at org.apache.tajo.plan.nameresolver.ResolverByRels.resolve(ResolverByRels.java:37)
      	at org.apache.tajo.plan.nameresolver.NameResolver.resolve(NameResolver.java:81)
      	at org.apache.tajo.plan.rewrite.BaseSchemaBuildPhase$Processor$NameRefInSelectListNormalizer.visitColumnReference(BaseSchemaBuildPhase.java:581)
      	at org.apache.tajo.plan.rewrite.BaseSchemaBuildPhase$Processor$NameRefInSelectListNormalizer.visitColumnReference(BaseSchemaBuildPhase.java:565)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:225)
      	at org.apache.tajo.plan.visitor.SimpleAlgebraVisitor.visit(SimpleAlgebraVisitor.java:46)
      	at org.apache.tajo.plan.rewrite.BaseSchemaBuildPhase$Processor$NameRefInSelectListNormalizer.normalize(BaseSchemaBuildPhase.java:574)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitFilter(SelfDescSchemaBuildPhase.java:248)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitFilter(SelfDescSchemaBuildPhase.java:153)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:78)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visitProjection(BaseAlgebraVisitor.java:319)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitProjection(SelfDescSchemaBuildPhase.java:180)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitProjection(SelfDescSchemaBuildPhase.java:153)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:60)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visitTableSubQuery(BaseAlgebraVisitor.java:419)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitTableSubQuery(SelfDescSchemaBuildPhase.java:319)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitTableSubQuery(SelfDescSchemaBuildPhase.java:153)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:93)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visitRelationList(BaseAlgebraVisitor.java:429)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:96)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visitProjection(BaseAlgebraVisitor.java:319)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitProjection(SelfDescSchemaBuildPhase.java:180)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase$Processor.visitProjection(SelfDescSchemaBuildPhase.java:153)
      	at org.apache.tajo.plan.algebra.BaseAlgebraVisitor.visit(BaseAlgebraVisitor.java:60)
      	at org.apache.tajo.plan.rewrite.SelfDescSchemaBuildPhase.process(SelfDescSchemaBuildPhase.java:141)
      	at org.apache.tajo.plan.rewrite.BaseLogicalPlanPreprocessEngine.process(BaseLogicalPlanPreprocessEngine.java:94)
      	at org.apache.tajo.plan.LogicalPlanPreprocessor.process(LogicalPlanPreprocessor.java:43)
      	at org.apache.tajo.plan.LogicalPlanner.createPlan(LogicalPlanner.java:167)
      	at org.apache.tajo.plan.LogicalPlanner.createPlan(LogicalPlanner.java:157)
      	at org.apache.tajo.master.GlobalEngine.createLogicalPlan(GlobalEngine.java:274)
      	at org.apache.tajo.master.GlobalEngine.executeQuery(GlobalEngine.java:190)
      
      1. TAJO-1889.patch
        8 kB
        Jihoon Son
      2. TAJO-1889_wrong_query.patch
        0.7 kB
        Jihoon Son

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user jihoonson opened a pull request:

        https://github.com/apache/tajo/pull/784

        TAJO-1889: Duplicate column name exception when a query with table subquery is executed on self-describing tables

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/jihoonson/tajo-2 TAJO-1889

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/784.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #784


        commit 404f1ae530aca3674fbe5511abd04b188d0b0a17
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-24T09:39:43Z

        TAJO-1889


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user jihoonson opened a pull request: https://github.com/apache/tajo/pull/784 TAJO-1889 : Duplicate column name exception when a query with table subquery is executed on self-describing tables You can merge this pull request into a Git repository by running: $ git pull https://github.com/jihoonson/tajo-2 TAJO-1889 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/784.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #784 commit 404f1ae530aca3674fbe5511abd04b188d0b0a17 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-24T09:39:43Z TAJO-1889
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/784#issuecomment-142947054

        +1
        The patch looks good to me. The test looks failed, but it is not related to this patch.

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/784#issuecomment-142947054 +1 The patch looks good to me. The test looks failed, but it is not related to this patch.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson commented on the pull request:

        https://github.com/apache/tajo/pull/784#issuecomment-143103406

        @hyunsik, thank you for your quick review, but I updated my patch to fix one more problem.
        Would you please review again?

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson commented on the pull request: https://github.com/apache/tajo/pull/784#issuecomment-143103406 @hyunsik, thank you for your quick review, but I updated my patch to fix one more problem. Would you please review again?
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson commented on the pull request:

        https://github.com/apache/tajo/pull/784#issuecomment-143103956

        I also put my patch on jira to trigger jenkins.

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson commented on the pull request: https://github.com/apache/tajo/pull/784#issuecomment-143103956 I also put my patch on jira to trigger jenkins.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson commented on the pull request:

        https://github.com/apache/tajo/pull/784#issuecomment-143107561

        I don't know why the diff includes the changes other than I modified.
        I'll close and reopen this pr.

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson commented on the pull request: https://github.com/apache/tajo/pull/784#issuecomment-143107561 I don't know why the diff includes the changes other than I modified. I'll close and reopen this pr.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson closed the pull request at:

        https://github.com/apache/tajo/pull/784

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson closed the pull request at: https://github.com/apache/tajo/pull/784
        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user jihoonson reopened a pull request:

        https://github.com/apache/tajo/pull/784

        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/jihoonson/tajo-2 TAJO-1889

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/784.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #784


        commit 404f1ae530aca3674fbe5511abd04b188d0b0a17
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-24T09:39:43Z

        TAJO-1889

        commit 1a7cde2c40d0e64444a1f788d7fada4a10f80922
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-24T12:56:12Z

        Fix one more case

        commit d8b99cc989079ca4c969a33a8c4998c1df94874b
        Author: Hyunsik Choi <hyunsik@apache.org>
        Date: 2015-09-24T14:33:08Z

        TAJO-1886: Set compilerSourceVM and compilerTargetVM to web.xml.

        Closes #781

        commit bf04b56c52a53d6465d0eff97eef3dcf9b0187e3
        Author: JaeHwa Jung <blrunner@apache.org>
        Date: 2015-09-24T16:59:45Z

        TAJO-1827: JSON parsing error at storage-site.json while tajo master starts up.

        Closes #776

        commit 32d851e920f8d93ac5de6a79a1e2559dda20a62d
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-25T01:32:04Z

        Merge branch 'TAJO-1889' of https://github.com/jihoonson/tajo-2 into TAJO-1889

        commit d9405e5d7b9d01d73bd0c9d795ecce346204c031
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-25T02:10:07Z

        Fix one more case

        commit 165b94e6e70cc86ff972cf0f31f190259dd62b54
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-25T02:12:48Z

        Add missing test result


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user jihoonson reopened a pull request: https://github.com/apache/tajo/pull/784 TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables You can merge this pull request into a Git repository by running: $ git pull https://github.com/jihoonson/tajo-2 TAJO-1889 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/784.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #784 commit 404f1ae530aca3674fbe5511abd04b188d0b0a17 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-24T09:39:43Z TAJO-1889 commit 1a7cde2c40d0e64444a1f788d7fada4a10f80922 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-24T12:56:12Z Fix one more case commit d8b99cc989079ca4c969a33a8c4998c1df94874b Author: Hyunsik Choi <hyunsik@apache.org> Date: 2015-09-24T14:33:08Z TAJO-1886 : Set compilerSourceVM and compilerTargetVM to web.xml. Closes #781 commit bf04b56c52a53d6465d0eff97eef3dcf9b0187e3 Author: JaeHwa Jung <blrunner@apache.org> Date: 2015-09-24T16:59:45Z TAJO-1827 : JSON parsing error at storage-site.json while tajo master starts up. Closes #776 commit 32d851e920f8d93ac5de6a79a1e2559dda20a62d Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-25T01:32:04Z Merge branch ' TAJO-1889 ' of https://github.com/jihoonson/tajo-2 into TAJO-1889 commit d9405e5d7b9d01d73bd0c9d795ecce346204c031 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-25T02:10:07Z Fix one more case commit 165b94e6e70cc86ff972cf0f31f190259dd62b54 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-25T02:12:48Z Add missing test result
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson closed the pull request at:

        https://github.com/apache/tajo/pull/784

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson closed the pull request at: https://github.com/apache/tajo/pull/784
        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user jihoonson opened a pull request:

        https://github.com/apache/tajo/pull/787

        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/jihoonson/tajo-2 TAJO-1889

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/787.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #787


        commit 404f1ae530aca3674fbe5511abd04b188d0b0a17
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-24T09:39:43Z

        TAJO-1889

        commit 1a7cde2c40d0e64444a1f788d7fada4a10f80922
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-24T12:56:12Z

        Fix one more case

        commit 32d851e920f8d93ac5de6a79a1e2559dda20a62d
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-25T01:32:04Z

        Merge branch 'TAJO-1889' of https://github.com/jihoonson/tajo-2 into TAJO-1889

        commit d9405e5d7b9d01d73bd0c9d795ecce346204c031
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-25T02:10:07Z

        Fix one more case

        commit 165b94e6e70cc86ff972cf0f31f190259dd62b54
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-09-25T02:12:48Z

        Add missing test result


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user jihoonson opened a pull request: https://github.com/apache/tajo/pull/787 TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables You can merge this pull request into a Git repository by running: $ git pull https://github.com/jihoonson/tajo-2 TAJO-1889 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/787.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #787 commit 404f1ae530aca3674fbe5511abd04b188d0b0a17 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-24T09:39:43Z TAJO-1889 commit 1a7cde2c40d0e64444a1f788d7fada4a10f80922 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-24T12:56:12Z Fix one more case commit 32d851e920f8d93ac5de6a79a1e2559dda20a62d Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-25T01:32:04Z Merge branch ' TAJO-1889 ' of https://github.com/jihoonson/tajo-2 into TAJO-1889 commit d9405e5d7b9d01d73bd0c9d795ecce346204c031 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-25T02:10:07Z Fix one more case commit 165b94e6e70cc86ff972cf0f31f190259dd62b54 Author: Jihoon Son <jihoonson@apache.org> Date: 2015-09-25T02:12:48Z Add missing test result
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/787#issuecomment-143863071

        +1
        I verified 'mvn clean install'. The patch looks good to me.

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/787#issuecomment-143863071 +1 I verified 'mvn clean install'. The patch looks good to me.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

        https://github.com/apache/tajo/pull/787

        Show
        githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/tajo/pull/787
        Hide
        jihoonson Jihoon Son added a comment -

        Committed to master and 0.11.

        Show
        jihoonson Jihoon Son added a comment - Committed to master and 0.11.
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-CODEGEN-build #543 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/543/)
        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables. (jihoon) (jihoonson: rev 72dd1c025fa0fe54a0161c26c01e2ae5d03d8bcb)

        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery.1.result
        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery3.1.result
        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery2.1.result
        • tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/SelfDescSchemaBuildPhase.java
        • tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        • CHANGES
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-CODEGEN-build #543 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/543/ ) TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables. (jihoon) (jihoonson: rev 72dd1c025fa0fe54a0161c26c01e2ae5d03d8bcb) tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery.1.result tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery3.1.result tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery2.1.result tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/SelfDescSchemaBuildPhase.java tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java CHANGES
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-build #912 (See https://builds.apache.org/job/Tajo-master-build/912/)
        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables. (jihoon) (jihoonson: rev 72dd1c025fa0fe54a0161c26c01e2ae5d03d8bcb)

        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery3.1.result
        • tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/SelfDescSchemaBuildPhase.java
        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery2.1.result
        • CHANGES
        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery.1.result
        • tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-build #912 (See https://builds.apache.org/job/Tajo-master-build/912/ ) TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables. (jihoon) (jihoonson: rev 72dd1c025fa0fe54a0161c26c01e2ae5d03d8bcb) tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery3.1.result tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/SelfDescSchemaBuildPhase.java tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery2.1.result CHANGES tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery.1.result tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-0.11.0-build #77 (See https://builds.apache.org/job/Tajo-0.11.0-build/77/)
        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables. (jihoonson: rev 9b4c8abb8af495c2664d53b129fb7c338f6e8af3)

        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery.1.result
        • tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/SelfDescSchemaBuildPhase.java
        • CHANGES
        • tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery3.1.result
        • tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery2.1.result
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-0.11.0-build #77 (See https://builds.apache.org/job/Tajo-0.11.0-build/77/ ) TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables. (jihoonson: rev 9b4c8abb8af495c2664d53b129fb7c338f6e8af3) tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery.1.result tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/SelfDescSchemaBuildPhase.java CHANGES tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery3.1.result tajo-core-tests/src/test/resources/results/TestQueryOnSelfDescTable/testTableSubquery2.1.result
        Hide
        hyunsik Hyunsik Choi added a comment -

        The unit tests included in this patch seem to need the determinant result with ORDERBY clause.
        https://builds.apache.org/job/Tajo-master-build/912/console

        Failed tests: 
          TestQueryOnSelfDescTable.testTableSubquery3:130->QueryTestCaseBase.runSimpleTests:617 Result Verification for: 1 th test expected:<...-------------------
        [example glossary,1,null,SGML,ISO 8879:1986
        ]> but was:<...-------------------
        []>
        
        Show
        hyunsik Hyunsik Choi added a comment - The unit tests included in this patch seem to need the determinant result with ORDERBY clause. https://builds.apache.org/job/Tajo-master-build/912/console Failed tests: TestQueryOnSelfDescTable.testTableSubquery3:130->QueryTestCaseBase.runSimpleTests:617 Result Verification for: 1 th test expected:<...------------------- [example glossary,1,null,SGML,ISO 8879:1986 ]> but was:<...------------------- []>
        Hide
        jihoonson Jihoon Son added a comment -

        This is the problem of wrong query rather than its result.
        It is my fault. Sorry.
        I will fix the query simply.

        Show
        jihoonson Jihoon Son added a comment - This is the problem of wrong query rather than its result. It is my fault. Sorry. I will fix the query simply.
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-CODEGEN-build #545 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/545/)
        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables. (fix wrong query) (jihoonson: rev 3035b0143d1900439ac186480a748f36556aa72c)

        • tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-CODEGEN-build #545 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/545/ ) TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables. (fix wrong query) (jihoonson: rev 3035b0143d1900439ac186480a748f36556aa72c) tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-0.11.0-build #79 (See https://builds.apache.org/job/Tajo-0.11.0-build/79/)
        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables. (fix wrong query) (jihoonson: rev 3d0e9833c64365d6f3d4fc507a70dcd9bdb0ac63)

        • tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-0.11.0-build #79 (See https://builds.apache.org/job/Tajo-0.11.0-build/79/ ) TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables. (fix wrong query) (jihoonson: rev 3d0e9833c64365d6f3d4fc507a70dcd9bdb0ac63) tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #913 (See https://builds.apache.org/job/Tajo-master-build/913/)
        TAJO-1889: UndefinedColumnException when a query with table subquery is executed on self-describing tables. (fix wrong query) (jihoonson: rev 3035b0143d1900439ac186480a748f36556aa72c)

        • tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #913 (See https://builds.apache.org/job/Tajo-master-build/913/ ) TAJO-1889 : UndefinedColumnException when a query with table subquery is executed on self-describing tables. (fix wrong query) (jihoonson: rev 3035b0143d1900439ac186480a748f36556aa72c) tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestQueryOnSelfDescTable.java

          People

          • Assignee:
            jihoonson Jihoon Son
            Reporter:
            jihoonson Jihoon Son
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development