phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Serhiy Bilousov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-1714) WHERE part for CREATE VIEW ... AS SELECT ... does not work for the quoted CF
Date Mon, 09 Mar 2015 04:52:38 GMT

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

Serhiy Bilousov updated PHOENIX-1714:
-------------------------------------
    Description: 
I was trying to build some views on top of HBase table but have very little luck with where
part I would like to put inside the view. 

in HBase shell
{noformat} 
disable 't1'
drop 't1'

create 't1', {NAME => 'f1'}
put 't1','r1','f1:B','r1f1b'
put 't1','r1','f1:C','r1f1c'
put 't1','r2','f1:C','r2f1c'
put 't1','r3','f1:D','r3f1d'
scan 't1'
{noformat} 

in sqlline
{noformat} 
DROP VIEW IF EXISTS dev.v_t1; 
create view dev.v_t1(a VARCHAR PRIMARY KEY, "f1".b VARCHAR, "f1".c VARCHAR, "f1".d VARCHAR)

as select * from "t1" ;
select * from dev.v_t1;

+-----------+-----------+-------------+-------------+
|      A    |        B  |         C   |         D   |
+-----------+-----------+-------------+-------------+
| r1        | r1f1b     | r1f1c       | null        |
| r2        | null      | r2f1c       | null        |
| r3        | null      | null        | r3f1d       |
+-----------+-----------+-------------+-------------+
3 rows selected (0.201 seconds)


DROP VIEW IF EXISTS dev.v_t1_b; 
create view dev.v_t1_b(a VARCHAR PRIMARY KEY, "f1".b VARCHAR) 
as select * from "t1" where "f1".b IS NOT NULL;
select * from dev.v_t1_b;
Error: ERROR 1001 (42I01): Undefined column family. familyName=F1.null (state=42I01,code=1001)
{noformat} 

It seems working as expected with unquoted CF. (HBase table created with all capital letters)
but it's not my case.

  was:
I was trying to build some views on top of HBase table but have very little luck with where
part I would like to put inside the view. 

in HBase shell
{noformat} 
disable 't1'
drop 't1'

create 't1', {NAME => 'f1'}
put 't1','r1','f1:B','r1f1b'
put 't1','r1','f1:C','r1f1c'
put 't1','r2','f1:C','r2f1c'
put 't1','r3','f1:D','r3f1d'
scan 't1'
{noformat} 

in sqlline
{noformat} 
DROP VIEW IF EXISTS dev.v_t1; 
create view dev.v_t1(a VARCHAR PRIMARY KEY, "f1".b VARCHAR, "f1".c VARCHAR, "f1".d VARCHAR)
as select * from "t1" ;
select * from dev.v_t1;

+-----------+-----------+-------------+-------------+
|      A    |        B  |         C   |         D   |
+-----------+-----------+-------------+-------------+
| r1        | r1f1b     | r1f1c       | null        |
| r2        | null      | r2f1c       | null        |
| r3        | null      | null        | r3f1d       |
+-----------+-----------+-------------+-------------+
3 rows selected (0.201 seconds)


DROP VIEW IF EXISTS dev.v_t1_b; 
create view dev.v_t1_b(a VARCHAR PRIMARY KEY, "f1".b VARCHAR) as select * from "t1" where
"f1".b IS NOT NULL;
select * from dev.v_t1_b;
Error: ERROR 1001 (42I01): Undefined column family. familyName=F1.null (state=42I01,code=1001)
{noformat} 

It seems working as expected with unquoted CF. (HBase table created with all capital letters)
but it's not my case.


> WHERE part for CREATE VIEW ... AS SELECT ... does not work for the quoted CF
> ----------------------------------------------------------------------------
>
>                 Key: PHOENIX-1714
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1714
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Serhiy Bilousov
>            Priority: Critical
>
> I was trying to build some views on top of HBase table but have very little luck with
where part I would like to put inside the view. 
> in HBase shell
> {noformat} 
> disable 't1'
> drop 't1'
> create 't1', {NAME => 'f1'}
> put 't1','r1','f1:B','r1f1b'
> put 't1','r1','f1:C','r1f1c'
> put 't1','r2','f1:C','r2f1c'
> put 't1','r3','f1:D','r3f1d'
> scan 't1'
> {noformat} 
> in sqlline
> {noformat} 
> DROP VIEW IF EXISTS dev.v_t1; 
> create view dev.v_t1(a VARCHAR PRIMARY KEY, "f1".b VARCHAR, "f1".c VARCHAR, "f1".d VARCHAR)

> as select * from "t1" ;
> select * from dev.v_t1;
> +-----------+-----------+-------------+-------------+
> |      A    |        B  |         C   |         D   |
> +-----------+-----------+-------------+-------------+
> | r1        | r1f1b     | r1f1c       | null        |
> | r2        | null      | r2f1c       | null        |
> | r3        | null      | null        | r3f1d       |
> +-----------+-----------+-------------+-------------+
> 3 rows selected (0.201 seconds)
> DROP VIEW IF EXISTS dev.v_t1_b; 
> create view dev.v_t1_b(a VARCHAR PRIMARY KEY, "f1".b VARCHAR) 
> as select * from "t1" where "f1".b IS NOT NULL;
> select * from dev.v_t1_b;
> Error: ERROR 1001 (42I01): Undefined column family. familyName=F1.null (state=42I01,code=1001)
> {noformat} 
> It seems working as expected with unquoted CF. (HBase table created with all capital
letters) but it's not my case.



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

Mime
View raw message