HBase data read with contains clause in key
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]
Last edited by rajpal; 05-10-2012 at 04:40 PM.