Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-10150

delete from acidTbl where a in(select a from nonAcidOrcTbl) fails

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.1.0
    • Fix Version/s: 1.2.0
    • Labels:
      None

      Description

      this query raises an error
      "10297,FAILED: SemanticException [Error 10297]: Attempt to do update or delete on table nonAcidOrcTbl that does not use an AcidOutputFormat or is not bucketed"

      even though nonAcidOrcTbl is only being read, not written.

      select b from " + Table.ACIDTBL + " where a in (select b from " + Table.NONACIDORCTBL + ")
      runs fine.

      There doesn't seem to be any logical reason why we should rise the error here.

      Same for 'update' statement.

        Attachments

        1. HIVE-10050.patch
          9 kB
          Eugene Koifman

          Issue Links

            Activity

              People

              • Assignee:
                ekoifman Eugene Koifman
                Reporter:
                ekoifman Eugene Koifman
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: