Member since
01-10-2022
2
Posts
0
Kudos Received
0
Solutions
02-26-2022
05:19 PM
Creating table like this: create table testexplode(name string, childs array<string>, amap map<string, string>)
row format delimited
fields terminated by '\t'
collection items terminated by ','
map keys terminated by ':'
lines terminated by '\n'
stored as textfile; Inserting date sets zhangsan child1,child2,child3,child4 k1:v1,k2:v2
lisi child5,child6,child7,child8 k3:v3,k4:v4 Querying like this: select explode(childs) from testexplode; This query is fine in hive CLI, but in Beeline, it returns error. Why it fails in Beeline? Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.
... View more
Labels:
- Labels:
-
Apache Hive