Impala相关
CREATE TABLE `default`.customers (
id INT,
name STRING(32767),
email_preferences STRUCT<
EMAIL_FORMAT:STRING,
FREQUENCY:STRING,
CATEGORIES:STRUCT<
PROMOS:BOOLEAN,
SURVEYS:BOOLEAN
>
>(32767),
addresses MAP<STRING,STRUCT<
STREET_1:STRING,
STREET_2:STRING,
CITY:STRING,
STATE:STRING,
ZIP_CODE:STRING
>>(32767),
orders ARRAY<STRUCT<
ORDER_ID:STRING,
ORDER_DATE:STRING,
ITEMS:ARRAY<STRUCT<
PRODUCT_ID:INT,
SKU:STRING,
NAME:STRING,
PRICE:DOUBLE,
QTY:INT
>>
>>(32767)
);