[jira] [Created] (PHOENIX-1102) Query Finds No Rows When Using Multiple Column Families

["James Taylor (JIRA)" <ji...@apache.org>]

James Taylor created PHOENIX-1102:
-------------------------------------

             Summary: Query Finds No Rows When Using Multiple Column Families
                 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


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)