[
https://issues.apache.org/jira/browse/TAJO-1889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14907450#comment-14907450
]
ASF GitHub Bot commented on TAJO-1889:
--------------------------------------
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 <[email protected]>
Date: 2015-09-24T09:39:43Z
TAJO-1889
commit 1a7cde2c40d0e64444a1f788d7fada4a10f80922
Author: Jihoon Son <[email protected]>
Date: 2015-09-24T12:56:12Z
Fix one more case
commit d8b99cc989079ca4c969a33a8c4998c1df94874b
Author: Hyunsik Choi <[email protected]>
Date: 2015-09-24T14:33:08Z
TAJO-1886: Set compilerSourceVM and compilerTargetVM to web.xml.
Closes #781
commit bf04b56c52a53d6465d0eff97eef3dcf9b0187e3
Author: JaeHwa Jung <[email protected]>
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 <[email protected]>
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 <[email protected]>
Date: 2015-09-25T02:10:07Z
Fix one more case
commit 165b94e6e70cc86ff972cf0f31f190259dd62b54
Author: Jihoon Son <[email protected]>
Date: 2015-09-25T02:12:48Z
Add missing test result
----
> UndefinedColumnException when a query with table subquery is executed on
> self-describing tables
> -----------------------------------------------------------------------------------------------
>
> Key: TAJO-1889
> URL: https://issues.apache.org/jira/browse/TAJO-1889
> Project: Tajo
> Issue Type: Bug
> Components: Planner/Optimizer
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Priority: Critical
> Fix For: 0.11.0
>
> Attachments: TAJO-1889.patch
>
>
> Here is the log.
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
