在《鲨鱼》里,当我奔跑时:
CREATE EXTERNAL TABLE test (
memberId STRING,
category STRING,
message STRING,
source STRING,
event_type STRING,
log_level STRING,
path STRING,
host STRING,
event_timestamp STRING,
eventFields MAP<STRING,STRING>
)
PARTITIONED BY (datePart STRING)
ROW FORMAT SERDE 'com.company.eventserde.EventSerde'
LOCATION '/user/ubuntu/test';
我得到:
[Hive Error]: Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Time taken (including network latency): 0.05 seconds
错误日志显示:
35.526: [Full GC 112196K->28191K(1013632K), 0.1913800 secs]
FAILED: Error in metadata: MetaException(message:file:/user/ubuntu/events is not a directory or unable to create one)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
FAILED: Error in metadata: MetaException(message:file:/user/ubuntu/test is not a directory or unable to create one)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
有人知道为什么shark不在hadoop中创建表吗?
1条答案
按热度按时间7y4bm7vi1#
尝试为位置指定完整的hdfs uri,如下所示: