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

[DOC] Extend FROM_UNIXTIME() doc with Timezone offset behaviour.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Docs
    • Labels:
      None
    • Epic Color:
      ghx-label-8

      Description

      FROM_UNIXTIME() accepts a format parameter that is a string that represents how this function should format its output timestamp. This format parameter can contain a timezone offset, however even if we provide a TZ offset in the format parameter it won't be included in the result.

      The reason is that Impala stores Timestamp without timezone in UTC and has no information of the timezone offset.

      I think it would be nice to clarify this in the docs so that the users won't expect to get specific timezone offsets from this function as a result.

        Attachments

          Activity

            People

            • Assignee:
              shajini shajini thayasingh
              Reporter:
              gaborkaszab Gabor Kaszab
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: