Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-35662 Support Timestamp without time zone data type
  3. SPARK-36055

Assign pretty SQL string to TimestampNTZ literals

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.3.0
    • 3.3.0
    • SQL
    • None

    Description

      Currently the TimestampNTZ literals shows only long value instead of timestamp string in its SQL string and toString result.
      Before changes (with default timestamp type as TIMESTAMP_NTZ)
      ```
      – !query
      select timestamp '2019-01-01\t'
      – !query schema
      struct<1546300800000000:timestamp_ntz>
      ```

      After changes:
      – !query
      select timestamp '2019-01-01\t'
      – !query schema
      struct<TIMESTAMP_NTZ '2019-01-01 00:00:00':timestamp_ntz>

      Attachments

        Activity

          People

            Gengliang.Wang Gengliang Wang
            Gengliang.Wang Gengliang Wang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: