@SmartSi 2016-07-23 02:25 采纳率: 0%
浏览 2799

Hive LOAD DATA 错误

Hive表:

 create table if not exists employee3(
   name string comment 'employee name',
   salary float comment 'employee salary',
   subordinates array<string> comment 'names of subordinates',
   deductions map<string,float> comment 'keys are deductions values are percentages',
   address struct<street:string, city:string, state:string, zip:int> comment 'home address'
)
PARTITIONED BY (country string, state string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\001'
COLLECTION ITEMS TERMINATED BY '\002'
MAP KEYS TERMINATED BY '\003'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

load data:

 LOAD DATA LOCAL INPATH '/home/xiaosi/hive/input/employeeData.txt'
OVERWRITE INTO TABLE employee3
PARTITION (country='China',state='BeiJing');

错误:

 Failed with exception org.apache.hadoop.hive.ql.metadata.HiveException: Unable to alter partition. For direct MetaStore DB connections, we don't support retries at the client level.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

  • 写回答

1条回答 默认 最新

  • devmiao 2016-07-23 16:16
    关注
    评论

    报告相同问题?

    悬赏问题

    • ¥30 c++ http服务器
    • ¥15 express连接mssql,每条额外附加了语句
    • ¥20 IQOO12如何有效ADB方法
    • ¥15 ios如何获取用户的订阅情况
    • ¥15 复杂表达式求值程序里的函数优先级问题
    • ¥15 求密码学的客成社记ji着用
    • ¥35 POI导入树状结构excle
    • ¥15 初学者c语言题目解答
    • ¥15 div editable中的光标问题
    • ¥15 mysql报错1415Not allowed to return a result set from a trigger 不知如何修改