[ 
https://issues.apache.org/jira/browse/PHOENIX-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15838417#comment-15838417
 ] 

Maryann Xue commented on PHOENIX-3635:
--------------------------------------

[~rajeshbabu], I had this discussion before with [~jamestaylor]. I agree with 
you that eventually our sub-schema resolving should be changed according to 
your patch, but I assume that those test cases that do not "CREATE SCHEMA" 
explicitly would fail on looking up the sub-schema. Maybe we should wait till 
Phoenix master changes all test cases to explicit schema creation and then 
commit this patch?

> 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