Home Forums HBase Does hive over hbase support wildcard query?

This topic contains 2 replies, has 2 voices, and was last updated by  Maharshi Jha 1 month, 1 week ago.

  • Creator
    Topic
  • #55735

    Amy Liu
    Participant

    Does hive over hbase support wildcard query?
    I have tried “select * from foo where a like ‘%sth%’”. It failed with the following:
    Job Submission failed with exception ‘java.lang.RuntimeException(Unexpected residual predicate (data like ’1′))’

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #57362

    Maharshi Jha
    Participant

    That means you may write query such a way that it can support RLike function.
    i.e Col_Name rlike ‘.*whatever.*’..

    Collapse
    #57361

    Maharshi Jha
    Participant

    Hi

    You can try to use RLike function for this.

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)