[teiid-issues] [JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling
[
https://issues.jboss.org/browse/TEIID-3133?page=com.atlassian.jira.plugin...
]
Filip Nguyen commented on TEIID-3133:
-------------------------------------
Good.
Btw the only (end very ugly) workaround to achieve the extraction of TIME on view layer
has been this:
{noformat}
convert(PARSETIMESTAMP(convert(Source.smalla.TIMEVALUE, string), 'yyyy-MM-dd
hh:mm:ss'), time) AS TIMEVALUE
{noformat}
Impala Time/Date/Timestamp handling
-----------------------------------
Key: TEIID-3133
URL: https://issues.jboss.org/browse/TEIID-3133
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7.1
Reporter: Van Halbert
Impala supports only TIMESTAMP datatype (see here
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates...)
Converted everything into timestamp and now I am trying to get Date and Time parts of the
timestamp in Teiid e.g.
SELECT DISTINCT convert(Source.SmallA.TimeValue, time) as TimeValue FROM Source.SmallA
ORDER BY TimeValue
But I get TranslatorException: Unexpected exception while translating results: Method not
supported
Tried to workaround this but with limited success. For Date it is possible to use to_date
function that returns string reprsentation of the date part. For Time I wasn't able to
find the solution (have not yet figured out how to use extract function through Teiid).
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates...
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)