[teiid-issues] [JBoss JIRA] (TEIID-4455) Impala Translator - Change planning step for from_unixtime() pushdown
[
https://issues.jboss.org/browse/TEIID-4455?page=com.atlassian.jira.plugin...
]
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)