[ https://issues.apache.org/jira/browse/PHOENIX-1102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sam John updated PHOENIX-1102: ------------------------------------ Attachment: PHOENIX-1102_V3.patch > 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_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)