Details
-
Type:
Bug
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 3.9.0
-
Fix Version/s: None
-
Component/s: con.hive, con.impala
-
Labels:None
-
Target Version:
Description
sample table schema (you can make it a regular non-external table)
CREATE EXTERNAL TABLE customers (
id INT,
name STRING,
addresses MAP<STRING, STRUCT<street_1:STRING, street_2:STRING, city:STRING, state:STRING, zip_code:STRING>>,
orders ARRAY<STRUCT<order_id:INT, order_date:STRING, items:ARRAY<STRUCT<product_id:INT, sku:STRING, name:STRING, price:DOUBLE, qty:INT>>>>
)
ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
LOCATION '/user/jennykim/customers';