创建表时出现amazon athena“输入不匹配”错误

ezykj2lf  于 2021-06-26  发布在  Hive
关注(0)|答案(0)|浏览(172)

下面的查询正在运行!

CREATE EXTERNAL TABLE scalefreedwh.mc_lists_members_response_test (
  edwLoadDate timestamp, 
  edwRecordSource string, 
   data array<struct<edwSequence:string, id:string, email_address:string, unique_email_id:string, email_type:string, status:string, 
        merge_fields:struct<FNAME:string, LNAME:string, GREETING:string, LANGUAGE:string, COUNTRY:string>,
        stats:struct<avg_open_rate:string, avg_click_rate:string>, 
        ip_signup:string, timestamp_signup:string, ip_opt:string, timestamp_opt:string, member_rating:string, last_changed:string, language:string, vip:boolean, email_client:string, 
        location:struct<latitude:string, longitude:string, gmtoff:string, dstoff:string, country_code:string, timezone:string>,
        list_id:string, 
        `_links`:array<struct<rel:string, href:string, method:string, targetSchema:string, schema:string>>
    >>
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 's3://bucket/MAILCHIMP/01/__schema__3.0__Definitions__Lists__Members__Response/2017-05-30T17:38:53/'

原始错误:
不匹配的输入“<”应为{array','>}(服务:amazonathena;状态码:400;错误代码:invalidrequestexception;请求id:233d35b3-45f4-11e7-97fb-9173d48be436)

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题