我已在网上搜索并尝试了所有解决方案,在尝试在配置单元中创建外部表时,似乎遇到了相同的错误:
失败:执行错误,从org.apache.hadoop.hive.ql.exec.ddltask返回代码1。org/apache/hadoop/hive/serde2/serde
我正在尝试创建一个外部表,用我使用flume从twitter中提取的数据填充它。我提取的数据位于hdfs存储系统中: /user/hadoop/twitter_data
.
我做了以下工作:
已下载 hive-serdes-1.0-SNAPSHOT.jar
来自cloudera。
添加jar /home/hadoop/Desktop/Flume_cheat/twitter/hive-serdes-1.0-SNAPSHOT.jar
.
create external table Twitter_Flume3 (id BIGINT,created_at STRING,source STRING,favorited BOOLEAN,retweet_count INT,retweeted_status STRUCT<text:STRING,user1:STRUCT<screen_name:STRING,name:STRING>>,entities STRUCT<urls:ARRAY<STRUCT<expanded_url:STRING>>,user2_mentions:ARRAY<STRUCT<screen_name:STRING,name:STRING>>,hashtags:ARRAY<STRUCTtext:STRING>>,text STRING,user3 STRUCT<screen_name:STRING,name:STRING,friends_count:INT,followers_count:INT,statuses_count:INT,verified:BOOLEAN,utc_offset:INT,time_zone:STRING>,in_reply_to_screen_name STRING) ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe' LOCATION '/user/training/flume_result'; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hive/serde2/SerDe
版本
hadoop版本3.2.1
配置单元版本3.1.2
暂无答案!
目前还没有任何答案,快来回答吧!