Hive
  1. Hive
  2. HIVE-2133

DROP TABLE IF EXISTS should not fail if a view of that name exists

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.8.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      We should match MySQL behavior on this. Likewise for DROP VIEW IF EXISTS when a table of that name exists.

      Note that without IF EXISTS, we still want the statement to fail when the existing object type does not match.

        Activity

        John Sichi created issue -
        John Sichi made changes -
        Field Original Value New Value
        Attachment HIVE-2133.1.patch [ 12477459 ]
        John Sichi made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Fix Version/s 0.8.0 [ 12316178 ]
        Hide
        Carl Steinbach added a comment -

        +1. Will commit if tests pass.

        Show
        Carl Steinbach added a comment - +1. Will commit if tests pass.
        Hide
        Carl Steinbach added a comment -

        Committed to trunk. Thanks John!

        Show
        Carl Steinbach added a comment - Committed to trunk. Thanks John!
        Carl Steinbach made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Hadoop Flags [Reviewed]
        Resolution Fixed [ 1 ]
        Carl Steinbach made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Patch Available Patch Available
        2d 2h 13m 1 John Sichi 28/Apr/11 01:13
        Patch Available Patch Available Resolved Resolved
        1d 6h 6m 1 Carl Steinbach 29/Apr/11 07:19
        Resolved Resolved Closed Closed
        231d 16h 37m 1 Carl Steinbach 16/Dec/11 23:56

          People

          • Assignee:
            John Sichi
            Reporter:
            John Sichi
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development