Why is the table not created through Hive UI?

Question

SQL

Good afternoon.
Deployed hortonworks sandbox 2.3.2 on a virtual machine, launched it. I put the apache log file through the file browser in /usr/hue/test.
Next, I go to hive ui and try to execute the table creation script based on the file:
CREATE EXTERNAL TABLE apache_logs (
ip STRING,
human_time STRING,
url STRING,
response STRING,
referrer STRING,
user_agent STRING
)
ROW FORMAT SERDE 'org.apache.hadoop.hive. contrib.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
"input.regex" =
"([\\d\\.]+) - - \\[(.*?)\\] \"GET (.+?) HTTP. *?\" (\\d+?) \\d+? (\\S+?) \"(.+?)\"")
LOCATION '/usr/hue/test'
I get an error - Error occurred executing hive query: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [hue] does not have [READ] privilege on [hdfs://sandbox.hortonworks.com:8020/usr/hue /test].
Permissions on the folder with the file 777. Why does this error occur?

Answer 1

Is there anyone who can suggest how to solve the problem?

Answer 2

It looks like you don't have permission to write exactly the file on the hdfs file system. Access rights in hdfs are configured with a separate command (look towards hadoop fs -chmod...). Also try to create an hdfs user for the hue admin panel and log in under it. Yes, it looks strange, but the problem seems to be that there is no hue user in the system at all, and so you log in under an existing user (The hdfs user is the default for hdfs storage).
When trying to create a table, I advise you to look at various logs in the /var/log/* directory Yes, there are a lot of files there ... but you can always stumble upon the desired log through intuition (we are looking in the directories /var/log/hue, /var/ log/hadoop-hdfs, etc... ) and enumerate files in these directories. For myself, I chose an assembly from cloudera - a completely adequate solution in which all components (hive, spark streaming, hdfs, hue ..etc.) are implemented as a single whole.