分隔符的当前文档存在问题。我以后再更新。
它实际上不是字段、集合项和Map键，而是嵌套级别1、2和3，并且还有其他级别没有被Map create table 语法。

create external table temp
(
    customer_id     int
   ,sales_item      array<struct<item_id:int,item_name:string,item_price:decimal(10,2)>>
)
row format delimited
fields terminated by ','
map keys terminated by '|'
;

select * from temp
;

+-------------+------------------------------------------------------+
| customer_id |                      sales_item                      |
+-------------+------------------------------------------------------+
|          10 | [{"item_id":1,"item_name":"watch","item_price":300}] |
+-------------+------------------------------------------------------+