Thanks Miklos, will that be available in Hive 4.0.0? On Sun, Apr 19, 2020 at 9:30 PM Miklos Gergely <mgerg...@cloudera.com> wrote:
> Hi Xi, > > In case of SHOW FUNCTIONS it is an SQL like regular exception, i.e. '%' > means any number of characters of any kind, and '_' means one character of > any kind. > In case of SHOW DATABASES though currently it is different, '*' means any > number of characters of any kind, like in a glob. > > I've created a jira (https://issues.apache.org/jira/browse/HIVE-23243) to > fix that. > > Thank you for calling my attention to this issue. > Miklos > > On Sun, Apr 19, 2020 at 9:54 AM Xi Chen <bargittac...@gmail.com> wrote: > >> Hi, >> >> I find that hive support pattern matching in several DDLs like >> SHOW FUNCTIONS [LIKE "<pattern>"]; >> SHOW DATABASES [LIKE "<pattern>"]; >> >> Does "pattern" mean any regular expression? Is there any spec of that? >> I went through the language manual, but still didn't find any spec about >> that. >> >> Thanks, >> Bargitta >> > > > -- > *Miklós Gergely* | Staff Software Engineer > t. +36 (30) 579-6433 <0000000000> > cloudera.com <https://www.cloudera.com/> > [image: Cloudera] <https://www.cloudera.com/> > > [image: Cloudera on Twitter] <https://twitter.com/cloudera> [image: > Cloudera on Facebook] <https://www.facebook.com/cloudera> [image: > Cloudera on LinkedIn] <https://www.linkedin.com/company/cloudera> > ------------------------------ >
