Re: Does pattern mean "regular expression" in hive DDL?

[Miklos Gergely]

Yes.

On Tue, Apr 21, 2020 at 11:32 AM Xi Chen  wrote:

> Thanks Miklos, will that be available in Hive 4.0.0?
>
> On Sun, Apr 19, 2020 at 9:30 PM Miklos Gergely 
> 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  wrote:
>>
>>> Hi,
>>>
>>> I find that hive support pattern matching in several DDLs like
>>> SHOW FUNCTIONS [LIKE ""];
>>> SHOW DATABASES [LIKE ""];
>>>
>>> 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 <00>
>> cloudera.com 
>> [image: Cloudera] 
>>
>> [image: Cloudera on Twitter]  [image:
>> Cloudera on Facebook]  [image:
>> Cloudera on LinkedIn] 
>> --
>>
>

-- 
*Miklós Gergely* | Staff Software Engineer
t. +36 (30) 579-6433 <00>
cloudera.com 
[image: Cloudera] 

[image: Cloudera on Twitter]  [image:
Cloudera on Facebook]  [image: Cloudera
on LinkedIn] 
--

Re: Does pattern mean "regular expression" in hive DDL?

[Xi Chen]

Thanks Miklos, will that be available in Hive 4.0.0?

On Sun, Apr 19, 2020 at 9:30 PM Miklos Gergely 
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  wrote:
>
>> Hi,
>>
>> I find that hive support pattern matching in several DDLs like
>> SHOW FUNCTIONS [LIKE ""];
>> SHOW DATABASES [LIKE ""];
>>
>> 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 <00>
> cloudera.com 
> [image: Cloudera] 
>
> [image: Cloudera on Twitter]  [image:
> Cloudera on Facebook]  [image:
> Cloudera on LinkedIn] 
> --
>

Re: Does pattern mean "regular expression" in hive DDL?

[Miklos Gergely]

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  wrote:

> Hi,
>
> I find that hive support pattern matching in several DDLs like
> SHOW FUNCTIONS [LIKE ""];
> SHOW DATABASES [LIKE ""];
>
> 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 <00>
cloudera.com 
[image: Cloudera] 

[image: Cloudera on Twitter]  [image:
Cloudera on Facebook]  [image: Cloudera
on LinkedIn] 
--