[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=13625202#comment-13625202 ] 

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

> So is it expected that when user invokes from_unixtime against teiid instance, it may serve different results based on what source is this pushed against?

Ideally the driver will make the connection timezone the same as the Teiid server timezone.  However if that is not occurring then yes you could get two different values.

> 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, 8.12.15.6_4
>
>
> 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
(v7.5.0#75005)