Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5908

Issue with "timestamp with timezone" redshift data type

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 16.0
    • None
    • JDBC Connector
    • None

    Description

      Our data source is redshift and we are using redshift translator in JDV.
      The source table has a couple of fields with data type "timestamp with timezone". This is field is mapped to Teiid source model with a data type timestamp. For some reason we are receiving following error when running a query on the table with this field in VDB.

      "SQL Error [30504] [50000]: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 SRC_RS_HYDRA: 22003 Unexpected exception while translating results: [Amazon][JDBC](10140) Error converting value to Timestamp"

      The fields which have source data type of "timestamp without timezone" mapped to teiid data type of timestamp work just fine.

      Please let me know if you have any questions.

      Thanks,
      Chandra

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-5949 SQLServer DateTimeOffset datatype is read as object(34)

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              cakkinep@redhat.com Chandra Akkinepalli
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: