[teiid-issues] [JBoss JIRA] (TEIID-3125) Netezza translator - add support for the LIKE_REGEX predicate.

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy updated TEIID-3125:
--------------------------------
    Description: 
With version 6 of Jboss DV the Netezza translator doesn't support the LIKE_REGEX predicate.

Netezza doesn't support regular expression by default, but with the installation of SQL Extensions toolkit this functionality is added. After installation Netezza provide the regular expression functions:
regexp_extract()
regexp_extract_all()
regexp_extract_all_sp()
regexp_extract_sp()
regexp_instr()
regexp_like()
regexp_match_count()
regexp_replace()
regexp_replace_sp()

IBM Netezza SQL Extensions toolkit is an optional package for IBM Netezza data warehouse appliances.

After installing this toolkit on Netezza and requires that regular expression in JBoss DV syntax are pushed down (delegated) to Netezza to prevent that filtering in the Jboss DV server most be done.

So please provide a configurable option in the Netezza translator of Jboss DV by which we can enable the LIKE_REGEX predicate for Netezza. This option when enabled will assume that the Netezza SQL extension toolkit is installed and the function regexp_like() is available.

  was:
With version 6 of Jboss DV the Netezza translator doesn't support the LIKE_REGEX predicate.

Netezza doesn't support regular expression by default, but with the installation of SQL Extensions toolkit this functionality is added. After installation Netezza provide the regular expression functions:
regexp_extract()
regexp_extract_all()
regexp_extract_all_sp()
regexp_extract_sp()
regexp_instr()
regexp_like()
regexp_match_count()
regexp_replace()
regexp_replace_sp()

IBM Netezza SQL Extensions toolkit is an optional package for IBM Netezza data warehouse appliances.

Our client (ASML) has installed this toolkit on Netezza and requires that regular expression in JBoss DV syntax are pushed down (delegated) to Netezza to prevent that filtering in the Jboss DV server most be done.

So please provide a configurable option in the Netezza translator of Jboss DV by which we can enable the LIKE_REGEX predicate for Netezza. This option when enabled will assume that the Netezza SQL extension toolkit is installed and the function regexp_like() is available.



> Netezza translator - add support for the LIKE_REGEX predicate.
> --------------------------------------------------------------
>
>                 Key: TEIID-3125
>                 URL: https://issues.jboss.org/browse/TEIID-3125
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> With version 6 of Jboss DV the Netezza translator doesn't support the LIKE_REGEX predicate.
> Netezza doesn't support regular expression by default, but with the installation of SQL Extensions toolkit this functionality is added. After installation Netezza provide the regular expression functions:
> regexp_extract()
> regexp_extract_all()
> regexp_extract_all_sp()
> regexp_extract_sp()
> regexp_instr()
> regexp_like()
> regexp_match_count()
> regexp_replace()
> regexp_replace_sp()
> IBM Netezza SQL Extensions toolkit is an optional package for IBM Netezza data warehouse appliances.
> After installing this toolkit on Netezza and requires that regular expression in JBoss DV syntax are pushed down (delegated) to Netezza to prevent that filtering in the Jboss DV server most be done.
> So please provide a configurable option in the Netezza translator of Jboss DV by which we can enable the LIKE_REGEX predicate for Netezza. This option when enabled will assume that the Netezza SQL extension toolkit is installed and the function regexp_like() is available.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)