HadoopExam Learning Resources

HadoopExam Training, Interview Questions, Certifications, Projects, POC and Hands On exercise access

    40000+ Learners upgraded/switched career    Testimonials

Access denied when “LOAD DATA” in hive

I have read access to an HDFS path 'XXX', when I execute some statements like "LOAD DATA INPATH 'XXX' into table YYY ..."

An error occurs:

ERROR: AuthorizationException: User 'ZZZ' does not have privileges to access: 'XXX'

Why a "LOAD DATA" statement need more privileges than "READ"?

Issue is that the LOAD DATA command physically moves the file from the path you specify in the INPATH to the location specified when creating the table. Now if it has to move the data it need RW permissions on the source folder & hence the error.

Search here for LOAD DATA : Apache Docs


Because you could do an Insert overwrite on the table. Did you try declaring the table as external? 
Yes, the table is declared external. Actually I just want copy the data in 'XXX' into my table.

Visit Home Page : http://hadoopexam.com for more detail . As you are not blacklisted user.

You are here: Home Question & Answer Hadoop Questions Access denied when “LOAD DATA” in hive