[teiid-issues] [JBoss JIRA] (TEIID-4455) Impala Translator - Change planning step for from_unixtime() pushdown

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13306872#comment-13306872 ] 

Steven Hawkins commented on TEIID-4455:
---------------------------------------

Yes, this is a change in the engine logic starting in the QueryRewriter.  The rewriter is replacing from_unixtime with the timestampadd equivalent - that needs moved to be a much later operation probably in LanguageBridgeFactory based upon the actual support.  Also the logic for function support needs to be updated so that pushdown support for from_unixtime checks both for from_unixtime and timestampadd.  Finally from_unix time needs to be added as a SourceSystemFunction and added to the getSupportedFunctions list for hive/impala.

> Impala Translator - Change planning step for from_unixtime() pushdown
> ---------------------------------------------------------------------
>
>                 Key: TEIID-4455
>                 URL: https://issues.jboss.org/browse/TEIID-4455
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>            Reporter: Don Krapohl
>            Assignee: Kylin Soong
>            Priority: Minor
>              Labels: Impala_Translator
>             Fix For: 9.2
>
>
> Impala and Teiid both have from_unixtime() functions and per the forum reference the mapping to timestampadd() appears to come before the test for pushdown support of the impala native function.
> As a query request we require the impala from_unixtime() function be executed instead of the Teiid-native version.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)