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

Implicit column aliases are converted to lowercase

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 2.3.0, Impala 2.5.0, Impala 2.4.0, Impala 2.6.0, Impala 2.7.0, Impala 2.8.0
    • Fix Version/s: None
    • Component/s: Backend

      Description

      When I run a to_utc_timestamp conversion, the query result shows the function but the time zone value is displayed as lower case, which is not a valid time zone.

      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 16:15:34.101000000                      |
      +----------------------------------------------------+
      
      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

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                blue_impala_48d6 Ryan Blue
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: