@SmartSi 2016-07-23 02:25 采纳率: 12.5%
浏览 2796

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条回答

      报告相同问题?

      相关推荐 更多相似问题

      悬赏问题

      • ¥15 template模板的参数问题
      • ¥15 C++程序设计 搭建项目框架
      • ¥50 搭建青柚H5过程中出现的问题
      • ¥15 查找处理学生信息问题,含多个文件,显示问题是无法调用其中一个文件
      • ¥15 simulink生成代码后提示告警
      • ¥16 jieba提取高频词,生成文件是空的
      • ¥15 怎么读取服务器中的文件去配置mongo的连接
      • ¥20 Python如何统计文本中两字及以上的词语个数
      • ¥15 MapReduce自定义对象怎么写
      • ¥15 看下哪里错了,程序应该没错