[ 
https://issues.apache.org/jira/browse/PHOENIX-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rajeshbabu Chintaguntla updated PHOENIX-3635:
---------------------------------------------
    Attachment: PHOENIX-3635.patch

Here is the patch fixes the issue. Basically from calcite we try to check any 
subschemas exist for each identifier. But PhoenixSchema#getSubSchema returning 
a subschema for each identifier so from that subschema we are failing to 
resolve the table names. 
 Please review [~maryannxue] [~jamestaylor].

> Many tests failing for not resolving table name properly in Phoenix-Calcite
> ---------------------------------------------------------------------------
>
>                 Key: PHOENIX-3635
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3635
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Rajeshbabu Chintaguntla
>              Labels: calcite
>         Attachments: PHOENIX-3635.patch
>
>
> There are around 2000 tests failing to resolve the table name and failing 
> with below kind of error.
> {noformat}
> additionOnDescCompositePK(org.apache.phoenix.end2end.SortOrderIT)  Time 
> elapsed: 1.267 sec  <<< ERROR!
> java.sql.SQLException: Error while preparing statement [UPSERT INTO T000161 
> (n1,n2,n3,d1) VALUES(?,?,?,?)]
>       at 
> org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:613)
>       at 
> org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:586)
>       at 
> org.apache.phoenix.end2end.SortOrderIT.additionOnDescCompositePK(SortOrderIT.java:391)
> Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, 
> column 13 to line 1, column 19: Object 'T000161' not found
>       at 
> org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:613)
>       at 
> org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:586)
>       at 
> org.apache.phoenix.end2end.SortOrderIT.additionOnDescCompositePK(SortOrderIT.java:391)
> Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 
> 'T000161' not found
>       at 
> org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:613)
>       at 
> org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:586)
>       at 
> org.apache.phoenix.end2end.SortOrderIT.additionOnDescCompositePK(SortOrderIT.java:391)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to