[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:comment-tabpanel&focusedCommentId=13474140#comment-13474140 ] 

Steven Hawkins commented on TEIID-4711:
---------------------------------------

IS DISTINCT FROM - added general engine support and pushdown.  I'll still get this into 10.0 as we will need to do a CR2 to pick up WildFly 11 Final
RLIKE - will be supported via LIKE_REGEX pushdown as well.
ILIKE / IREGEXP / RLIKE - added source system functions, e.g. ILIKE(string, pattern) which the translator will change into the infix form.

> 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.5.0#75005)