[
https://issues.apache.org/jira/browse/PHOENIX-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17107550#comment-17107550
]
Hadoop QA commented on PHOENIX-5894:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/13002970/PHOENIX-5894.patch
against master branch at commit 49599fd89b6cfa9cab9d7d3f6dcf4bdc5428915a.
ATTACHMENT ID: 13002970
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:green}+1 tests included{color}. The patch appears to include 1 new
or modified tests.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:green}+1 release audit{color}. The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 lineLengths{color}. The patch does not introduce lines
longer than 100
{color:red}-1 core tests{color}. The patch failed these unit tests:
org.apache.phoenix.compile.QueryCompilerTest
Test results:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/3855//testReport/
Code Coverage results:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/3855//artifact/phoenix-core/target/site/jacoco/index.html
Console output:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/3855//console
This message is automatically generated.
> Table versus Table Full Outer join on Salted tables not working
> ---------------------------------------------------------------
>
> Key: PHOENIX-5894
> URL: https://issues.apache.org/jira/browse/PHOENIX-5894
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Affects Versions: 5.0.0
> Reporter: Ben Cohen
> Assignee: Rajeshbabu Chintaguntla
> Priority: Major
> Fix For: 5.1.0, 4.16.0
>
> Attachments: PHOENIX-5894.patch,
> Salt_Bucketed_Table_Full_Outer_Join_Issue.docx
>
>
> Trying to do a Full Outer Join on two tables. The operation works when the
> tables are not salted but fails with an exception related to casting when
> performed on the salted versions of the tables. Here is the exceptions:
> "java.lang.ClassCastException: org.apache.phoenix.schema.PColumnImpl cannot
> be cast to org.apache.phoenix.schema.ProjectedColumn
> at
> org.apache.phoenix.compile.JoinCompiler.joinProjectedTables(JoinCompiler.java:1256)
> at
> org.apache.phoenix.compile.QueryCompiler.compileJoinQuery(QueryCompiler.java:425)
> at
> org.apache.phoenix.compile.QueryCompiler.compileJoinQuery(QueryCompiler.java:228)
> at
> org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:191)
> at
> org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:153)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:490)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:456)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:302)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:291)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:290)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:283)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1830)
> at sqlline.Commands.execute(Commands.java:822)
> at sqlline.Commands.sql(Commands.java:732)
> at sqlline.SqlLine.dispatch(SqlLine.java:813)
> at sqlline.SqlLine.begin(SqlLine.java:686)
> at sqlline.SqlLine.start(SqlLine.java:398)
> at sqlline.SqlLine.main(SqlLine.java:291)"
> I have attached a word document with the complete list of queries and their
> results, along with commands to recreate the data.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
