[teiid-issues] [JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling
Steven Hawkins (JIRA)
issues at jboss.org
Fri Oct 24 08:33:35 EDT 2014
[ https://issues.jboss.org/browse/TEIID-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13014882#comment-13014882 ]
Steven Hawkins commented on TEIID-3133:
---------------------------------------
If you are going to reopen this one, it needs a public comment. Also, the exception shown is different than the original issue - that is the original issue was an unsupported type for the driver, and this appears to be a conversion that impala does not support TIMESTAMP to DATE. It can be worked under this issue if you want though.
> 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
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.9
>
>
> Impala supports only TIMESTAMP datatype (see here http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/Impala/Installing-and-Using-Impala/ciiu_porting.html)
> 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/latest/Impala/Installing-and-Using-Impala/ciiu_datetime_functions.html
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
More information about the teiid-issues
mailing list