Skip to content

Instantly share code, notes, and snippets.

@yoni
Created August 22, 2012 14:33
Show Gist options
  • Save yoni/3426147 to your computer and use it in GitHub Desktop.
Save yoni/3426147 to your computer and use it in GitHub Desktop.
Hive "drop table" permissions error.
Contents of data.csv:
--------------------
joe.schmoe,73
bill.foo,31
john.smith,2
Contents of Hive script:
-----------------------
CREATE TABLE some_database.ages (
name STRING,
age INT
)
ROW FORMAT
DELIMITED FIELDS
TERMINATED BY ","
;
LOAD DATA LOCAL
INPATH './data.csv'
OVERWRITE INTO TABLE some_database.ages
;
DROP TABLE some_database.ages; # Causes a permissions error
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment