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

Issue with hive literal timestamps

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.12.3, 8.13
    • 8.11
    • Misc. Connectors
    • None

    Description

      With testing TEIID-3847 Hive 1.2.1 failed to compare appropriately with a timestamp string literal in the source sql containing .0 fractional seconds:

      t = '2000-01-01 12:00:00.0' – did not work
      But the following does
      t = '2000-01-01 12:00:00'
      t = cast('2000-01-01 12:00:00.0' as timestamp)

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: