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

[Jan Stastny (JIRA)]

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

Jan Stastny commented on TEIID-4455:
------------------------------------

> By default the values are considered to be in UTC timezone
Sorry, that's not true for Hive. It returns local timezone based timestamp.

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? 

> 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)