Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: HBase data read with contains clause in key

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Apr 2012

    Default 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.