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

Hive throws an ugly error exception when HDFS sticky bit is set

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Component/s: None
    • Labels:
    • Target Version/s:

      Description

      When calling LOAD DATA INPATH ... OVERWRITE INTO TABLE ... from a Hive user other than the HDFS file owner, and the HDFS sticky bit is set, then Hive will throw an error exception message that the file cannot be moved due to permission issues.
      Caused by: org.apache.hadoop.security.AccessControlException: Permission denied by sticky bit setting: user=hive, inode=sasdata-2016-04-20-17-13-43-630-e-00001.dlv.bk
      The permission denied is expected, but the error message does not make sense to users + the stack trace displayed is huge. We should display a better error message to users, and maybe provide with help information about how to fix it.

        Attachments

        1. HIVE16960.5.patch
          27 kB
          Janaki Lahorani
        2. HIVE16960.4.patch
          27 kB
          Janaki Lahorani
        3. HIVE16960.3.patch
          27 kB
          Janaki Lahorani
        4. HIVE16960.2.patch
          26 kB
          Janaki Lahorani
        5. HIVE16960.2.patch
          26 kB
          Janaki Lahorani
        6. HIVE16960.1.patch
          25 kB
          Janaki Lahorani

          Issue Links

            Activity

              People

              • Assignee:
                janulatha Janaki Lahorani
                Reporter:
                janulatha Janaki Lahorani
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: