[teiid-issues] [JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling

[Van Halbert (JIRA)]

Van Halbert created TEIID-3133:
----------------------------------

             Summary: 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


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)