Apache Drill
  1. Apache Drill
  2. DRILL-691

Add function alias for casting to TIMESTAMPTZ data type

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None
    • Target Version/s:

      Description

      Currently Optiq does not have a TIMESTAMP with Time Zone data type. Add an alias function in Drill that allows casting easily to TIMESTAMP with Time Zone data type till we have complete support from Optiq.

      So the query to use timestamp with time zone would look like:

      Select timestamptztype(column_name) from foo;

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Patch Available Patch Available
        1m 33s 1 Mehant Baid 12/May/14 02:19
        Patch Available Patch Available Resolved Resolved
        1d 2h 29m 1 Jacques Nadeau 13/May/14 04:48
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12861608 ] Drill workflow [ 12933468 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.4.0 [ 12324963 ]
        Jacques Nadeau made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Hide
        Jacques Nadeau added a comment -

        resolved in a50ab2b

        Show
        Jacques Nadeau added a comment - resolved in a50ab2b
        Jacques Nadeau made changes -
        Target Version/s 1.0.0-rc1 [ 12324963 ]
        Mehant Baid made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Mehant Baid made changes -
        Field Original Value New Value
        Attachment DRILL-691.patch [ 12644365 ]
        Mehant Baid created issue -

          People

          • Assignee:
            Mehant Baid
            Reporter:
            Mehant Baid
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development