[teiid-issues] [JBoss JIRA] (TEIID-4711) Add multiple operator supports to Impala translator (case insensitive ilike, iregex, etc))

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins reassigned TEIID-4711:
-------------------------------------

    Fix Version/s: 10.0
         Assignee:     (was: Steven Hawkins)


IS DISTINCT FROM has some support in Teiid, but would need additional logic to support pushdown.  The other constructs could be worked around by adding source functions.  As first class concepts we would likely want to add engine support as well.

> Add multiple operator supports to Impala translator (case insensitive ilike, iregex, etc))
> ------------------------------------------------------------------------------------------
>
>                 Key: TEIID-4711
>                 URL: https://issues.jboss.org/browse/TEIID-4711
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>    Affects Versions: 9.1.1
>            Reporter: Don Krapohl
>              Labels: Impala_Translator
>             Fix For: 10.0
>
>
> Per https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_operators.html Impala post-2.5 supports several operations that should be pushed down.
> As a user I would like to be able to use the following SQL operations and have them pushed down in my queries using the Impala translator:
> ILIKE
> IREGEXP
> IS DISTINCT FROM
> RLIKE



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)