Hive鍙互浣跨敤鍐呯疆鐨凧SON SerDe锛圫erializer/Deserializer锛夋潵璇诲彇JSON鏁扮粍鏁版嵁銆備互涓嬫槸涓€涓ず渚嬫楠わ細

1. 棣栧厛锛屽湪Hive涓垱寤轰竴涓閮ㄨ〃锛屾寚瀹氫娇鐢↗SON SerDe鏉ヨ鍙朖SON鏁版嵁銆備緥濡傦細

CREATE EXTERNAL TABLE json_array_table (
  id INT,
  names ARRAY<STRING>
)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
LOCATION '/path/to/json/array/data';

2. 鐒跺悗锛屽皢鍖呭惈JSON鏁扮粍鏁版嵁鐨凧SON鏂囦欢涓婁紶鍒版寚瀹氱殑鐩綍锛堜緥濡?code>/path/to/json/array/data锛変腑銆?/p>

3. 鏈€鍚庯紝浣跨敤Hive鐨凷ELECT璇彞鏌ヨJSON鏁扮粍鏁版嵁锛?/p>

SELECT id, names
FROM json_array_table;

杩欐牱灏卞彲浠ヨ鍙朖SON鏁扮粍鏁版嵁骞跺湪Hive涓繘琛屾搷浣滀簡銆傝娉ㄦ剰锛孞SON鏁扮粍鐨勬瘡涓厓绱犲皢琚В鏋愪负Hive涓殑涓€涓暟缁勭被鍨嬶紝鍙互浣跨敤Hive鐨勬暟缁勫嚱鏁拌繘琛岃繘涓€姝ュ鐞嗗拰鎿嶄綔銆?/p>