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)
);
posted @ 2020-09-16 10:24  ytsee  阅读(16)  评论(0)    收藏  举报