PDA

View Full Version : HBase data read with contains clause in key



rajpal
05-10-2012, 03:22 PM
For HBase input, does "Start Key Value for table scan" under configure query tab applies "contains" clause? For example, I have record with keys "AA-BB-CC-DD" , "AB-BB-BD-DD" and "BB-AA-CC-DD". How to configure query such that all the records with key starting with "A" could be read from HBase? Similarly, how all records whose key contains 'BB".
I tried with "A" in the start key but didn't yield the expected result.

I'm using CE 4.3 preview.

UPDATE: PDI works as I initially thought i.e. its matches the starting part of key with the string provided in "Start Key Value" field. Mistake is on my part to miss it first attempt.

Still unable to make it work with wildcard i.e reading records with matching multiple key patterns i.e. A[AB]


Thanks,

evan_cao
05-12-2016, 10:44 PM
i see the some problem,i think its the table in hbase have more then one region