Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: HBase data read with contains clause in key

  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.

  2. #2
    Join Date
    May 2016


    i see the some problem,i think its the table in hbase have more then one region

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.