Cluster configuration: Phoenix 4.0.2 with Hbase 0.98 HDP 2.1 One of our table has a primary key (customerId int, timestamp BigInt, transactionId varchar). One of our use cases is to retrieve records by customerId and transactionID.
select * from my_table where cid = ? and tid = ? looking at the explain plan, it resulted in a range scan on customerID with a filter on transactionID. I tried to create an index on (CustomerID, transactionID) but didn't result any change in the explain plan. Trying to understand if there is a better way to handle this. In Hbase, there is a fuzzyRowKeyFilter which allows to query on parts on the key. Would appreciate if someone can point me in the right direction. thanks, Vijay
