hive array类型字段 建表

-- test_databases.test_imp07 definition

CREATE EXTERNAL TABLE `test_databases.test_imp07`(
  `exps` array<struct<id:string,l:string>> COMMENT 'ceshi')
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' 
WITH SERDEPROPERTIES ( 
  'collection.delim'=',', 
  'field.delim'='\t', 
  'mapkey.delim'=':', 
  'serialization.format'='\t') 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'oss://oss-cdp2dev-deloitte/raw/spark/db/test7'
TBLPROPERTIES (
  'bucketing_version'='2', 
  'transient_lastDdlTime'='1630401177');

INSERT INTO test_databases.test_imp07 (exps) VALUES ([{"id":"exp6","l":"layer_3"},{"id":"exp7","l":"layer_4"}]);