phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ben Cohen (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5894) Table versus Table Full Outer join on Salted tables not working
Date Wed, 13 May 2020 22:30:00 GMT
Ben Cohen created PHOENIX-5894:
----------------------------------

             Summary: 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
         Attachments: 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)

Mime
View raw message