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

Add functions to convert custom date strings with full precision

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: Impala 2.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:

      Description

      Impala can only convert custom-formatted date strings to a bigint of seconds (using UNIX_TIMESTAMP and FROM_UNIXTIME), which removes the fraction of the second from the result. This loss of precision does not meet the requirements of some applications.

      Impala could add functions to convert these strings directly to a timestamp and vice versa, for example:

      • to_date(date timestamp, format string), return type string
      • from_date(date string, format string), return type timestamp

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jbeard Jacob Evan Beard
              • Votes:
                2 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: