Re: Potential causes for very slow DELETEs?

Hi Pedro, Usually that kind of behavior should be reflected in the region server logs. Try to turn DEBUG level and check what exactly RS is doing during that time. Also you may check the thread dump of RS during the execution and see what are rpc handlers are doing. One thing that should be

Query using IN clause and Binary field types (JDBC)

Hey folks, Note: using Phoenix 4.7 on CDH I've got a table defined similar to this: CREATE TABLE IF NOT EXISTS my_tbl ( my_id BINARY NOT NULL PRIMARY KEY, name VARCHAR ) COMPRESSION='SNAPPY'; I am trying to create a prepared statement like: val sqlString = "SELECT name from my_tbl where

Re: Phoenix Storage Not Working on AWS EMR 5.8.0

More info... By trial and error, I tested different EMR versions and made a little incomplete list of which ones support Pig Phoenix storage and which ones don't: emr-5.8.0 JacksonJaxbJsonProvider error emr-5.6.0 JacksonJaxbJsonProvider error emr-5.4.0 JacksonJaxbJsonProvider error emr-5.3.1

Potential causes for very slow DELETEs?

Hi all, We have two HBase 1.0 clusters running the same process in parallel -effectively keeps the same data in both Phoenix tables- This process feeds data into Phoenix 4.5 via HFile and once the data is loaded a Spark process deletes a few thousand rows from the tables -secondary indexing is