[
https://issues.apache.org/jira/browse/PHOENIX-1102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14070593#comment-14070593
]
Hudson commented on PHOENIX-1102:
---------------------------------
SUCCESS: Integrated in Phoenix | 3.0 | Hadoop1 #145 (See
[https://builds.apache.org/job/Phoenix-3.0-hadoop1/145/])
PHOENIX-1102 Query Finds No Rows When Using Multiple Column Families in where
clause. (Anoop) (anoopsamjohn: rev 343d9262cda3a10461bb301ee0089e6df3867d99)
*
phoenix-core/src/main/java/org/apache/phoenix/filter/MultiCFCQKeyValueComparisonFilter.java
*
phoenix-core/src/main/java/org/apache/phoenix/filter/MultiKeyValueComparisonFilter.java
*
phoenix-core/src/main/java/org/apache/phoenix/filter/MultiCQKeyValueComparisonFilter.java
*
phoenix-core/src/it/java/org/apache/phoenix/end2end/ColumnProjectionOptimizationIT.java
* phoenix-core/src/test/java/org/apache/phoenix/query/BaseTest.java
> Query Finds No Rows When Using Multiple Column Families in where clause
> -----------------------------------------------------------------------
>
> Key: PHOENIX-1102
> URL: https://issues.apache.org/jira/browse/PHOENIX-1102
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0, 4.0.0, 5.0.0
> Reporter: James Taylor
> Assignee: Anoop Sam John
> Priority: Critical
> Fix For: 5.0.0, 3.1, 4.1
>
> Attachments: PHOENIX-1102.patch, PHOENIX-1102_3.0.patch,
> PHOENIX-1102_V2.patch, PHOENIX-1102_V3.patch
>
>
> When using multiple column families, query does not find all expected rows.
>
> My table schema:
> CREATE TABLE IF NOT EXISTS FAMILY_TEST (
> NUM1 INTEGER NOT NULL,
> AA.NUM2 INTEGER,
> BB.NUM3 INTEGER,
> CONSTRAINT my_pk PRIMARY KEY (NUM1));
> I populated it with one row, assigning 1 to each field. I can verify that
> the record is there, but I can not get a simple expression working that uses
> fields across two column families:
> SELECT * FROM FAMILY_TEST;
> NUM1 NUM2 NUM3
> ---------- ---------- ----------
> 1 1 1
> Time: 0.038 sec(s)
> SELECT * FROM FAMILY_TEST WHERE NUM2=1 AND NUM3=1;
> no rows selected
> Time: 0.039 sec(s)
> I understand that columns to be queried together should usually be in the
> same column family for efficiency, but I did not expect my second query to
> not work at all. Or if it is not supported, I would expect an error. I get
> the same results if I use AA.NUM2 and BB.NUM3 as well.
> I am using Phoenix 3.0.0.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
