Re: Phoenix Storage Not Working on AWS EMR 5.8.0

2017-08-24 Thread Steve Terrell
Just to close the loop on this... Did not have time to experiment with other EMR versions, so just going with emr-4.9.2 for the near future since Pig Phoenix storage works as expected when running the script from the command line. However, made an action item for a future date to try submitting

Re: Delay between put from HBase shell and result in SELECT from Phoenix

2017-08-24 Thread Batyrshin Alexander
Here is example: CREATE TABLE IF NOT EXISTS test ( k VARCHAR NOT NULL, v VARCHAR, CONSTRAINT my_pk PRIMARY KEY (k) ); 0: jdbc:phoenix:> upsert into test(k,v) values ('1', 'a'); 1 row affected (0.042 seconds) 0: jdbc:phoenix:> select * from test; +++ | K | V | +++ | 1 | a

Delay between put from HBase shell and result in SELECT from Phoenix

2017-08-24 Thread Batyrshin Alexander
Hello, How to decrease or even eliminate delay between direct HBase put (for example from HBase shell) and SELECT from Phoenix? My table has only 1 VERSION and do not use any block cache ( {NAME => 'invoice', COMPRESSION => 'LZO', BLOCKCACHE => 'false'} ), so i do not understand where