Does hive over hbase support wildcard query?

to create new topics or reply. | New User Registration

This topic contains 2 replies, has 2 voices, and was last updated by  Maharshi Jha 9 months, 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 to reply to this topic. | Create Account

  • 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)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.