Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2546

Invalid time zones are ignored but should be rejected

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      Invalid time zone values are ignored, but should be rejected. Users shouldn't be able to ignore warnings and get back incorrectly translated times.

      Query: select to_utc_timestamp('2015-10-13 09:15:34.101', 'pdt')
+----------------------------------------------------+
| to_utc_timestamp('2015-10-13 09:15:34.101', 'pdt') |
+----------------------------------------------------+
| 2015-10-13 09:15:34.101000000                      |
+----------------------------------------------------+
WARNINGS: UDF WARNING: Unknown timezone 'pdt'

      Attachments

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. IMPALA-2542 PDT and PST use the same offset

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. IMPALA-3169 to_utc_timestamp blank value

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. IMPALA-2544 Implicit column aliases are converted to lowercase

        • Major - Major loss of function.
        • Open
        relates to

        Bug - A problem which impairs or prevents the functions of the product. IMPALA-5203 from_utc_timestamp inconsistent how it handles daily savings time

        • Major - Major loss of function.
        • Resolved

        Bug - A problem which impairs or prevents the functions of the product. IMPALA-4250 from_utc_time function issue for CET daylight savings

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Resolved

        Bug - A problem which impairs or prevents the functions of the product. IMPALA-5563 Timezone lookup may be ambiguous

        • Major - Major loss of function.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bikramjeet.vig Bikramjeet Vig
            blue_impala_48d6 Ryan Blue
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment