Re: Create View of Existing HBase table

2017-06-19 Thread Randy Hu
t; >>>>>> > >>>>>> 0: jdbc:phoenix:pocc2.net:2181> CREATE VIEW "bro" (pk VARCHAR > >> PRIMARY > >>>>>> KEY, "bm"."id.orig_h" VARCHAR, "bm"."id.orig_p" VARCHAR, > >>>

Re: Create View of Existing HBase table

2017-06-19 Thread M. Aaron Bossert
t;>> ue', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'} >>>>>> >>>>>> >>>>>> >>>>>> {NAME => 'uid', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY

Re: Create View of Existing HBase table

2017-06-17 Thread Randy Hu
27;FALSE', DATA_BLOCK_ENCODING => > 'NONE', > >> TTL > >>>> => 'FOREVER', COMPRESSION => 'LZ4', MIN_VERSIONS => '0', BLOCKCACHE > => > >> 't > >>>> > >>>> rue', BLOCKS

Re: Create View of Existing HBase table

2017-06-17 Thread M. Aaron Bossert
;> rue', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'} >>>> >>>> >>>> >>>> 2 row(s) in 0.0300 seconds >>>> >>>> >>>> *When I try to create a Phoenix VIEW (Phoenix 4.7) as such:* >

Re: Create View of Existing HBase table

2017-06-17 Thread M. Aaron Bossert
5536', REPLICATION_SCOPE => '0'} >>>> >>>> >>>> >>>> 2 row(s) in 0.0300 seconds >>>> >>>> >>>> *When I try to create a Phoenix VIEW (Phoenix 4.7) as such:* >>>> >>>> >>>> 0: jdb

Re: Create View of Existing HBase table

2017-06-17 Thread Randy Hu
; >> > >> > >> 0: jdbc:phoenix:pocc2.net:2181> CREATE VIEW "bro" (pk VARCHAR PRIMARY > >> KEY, "bm"."id.orig_h" VARCHAR, "bm"."id.orig_p" VARCHAR, > "bm"."id_resp_h" > >> VARCHAR,

Re: Create View of Existing HBase table

2017-06-17 Thread M. Aaron Bossert
; >> VARCHAR, "bm"."id_resp_p" VARCHAR, "bm"."proto" VARCHAR) AS SELECT * FROM >> "bro"; >> >> No rows affected (0.019 seconds) >> >> >> *I see no errors at all, but when I try to query, there are no results. I

Re: Create View of Existing HBase table

2017-06-17 Thread Randy Hu
conds) > > > *I see no errors at all, but when I try to query, there are no results. I > verified that the columns in question are entered using the > Bytes.toBytes(String) method in my code, thus my choice of VARCHAR.* > > > 0: jdbc:phoenix:pocc2.net:2181> select * from "bro"; > > *+--

Create View of Existing HBase table

2017-06-16 Thread M. Aaron Bossert
*I have an existing HBase table with the following characteristics:* hbase(main):032:0> describe 'bro' Table bro is ENABLED bro, {TABLE_ATTRIBUTES => {coprocessor$1 => '|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|', coprocessor$2 => '|org.apache.phoenix.coprocessor.UngroupedAg