hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Simanchal Das (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-15229) 'like any' and 'like all' operators in hive
Date Mon, 21 Nov 2016 12:42:59 GMT

     [ https://issues.apache.org/jira/browse/HIVE-15229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Simanchal Das updated HIVE-15229:
---------------------------------
    Status: Patch Available  (was: Open)

> 'like any' and 'like all' operators in hive
> -------------------------------------------
>
>                 Key: HIVE-15229
>                 URL: https://issues.apache.org/jira/browse/HIVE-15229
>             Project: Hive
>          Issue Type: New Feature
>          Components: Operators
>            Reporter: Simanchal Das
>            Assignee: Simanchal Das
>            Priority: Minor
>         Attachments: HIVE-15229.1.patch, HIVE-15229.2.patch
>
>
> In Teradata 'like any' and 'like all' operators are mostly used when we are matching
a text field with numbers of patterns.
> 'like any' and 'like all' operator are equivalents of multiple like operator like example
below.
> {noformat}
> --like any
> select col1 from table1 where col2 like any ('%accountant%', '%accounting%', '%retail%',
'%bank%', '%insurance%');
> --Can be written using multiple like condition 
> select col1 from table1 where col2 like '%accountant%' or col2 like '%accounting%' or
col2 like '%retail%' or col2 like '%bank%' or col2 like '%insurance%' ;
> --like all
> select col1 from table1 where col2 like all ('%accountant%', '%accounting%', '%retail%',
'%bank%', '%insurance%');
> --Can be written using multiple like operator 
> select col1 from table1 where col2 like '%accountant%' and col2 like '%accounting%' and
col2 like '%retail%' and col2 like '%bank%' and col2 like '%insurance%' ;
> {noformat}
> Problem statement:
> Now a days so many data warehouse projects are being migrated from Teradata to Hive.
> Always Data engineer and Business analyst are searching for these two operator.
> If we introduce these two operator in hive then so many scripts will be migrated smoothly
instead of converting these operators to multiple like operators.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message