输入“>”不匹配，在结构类型中应为

Question

失败：ParseException行1：161输入“>”不匹配，在结构类型HIVE>创建外部表user1（id BIGINT,created_at STRING,source STRING,favorited BOOLEAN,retweet_count INT,retweeted_status struct sreen_name:STRING,name:STRING>>,entities struct ,user_mentions:array>,hashtags：array>>,text STRING,user：struct,name:STRING>)行格式分隔的字段以“,”终止；

请问我如何解决这个问题？

Answer 1

CREATE EXTERNAL TABLE user1 
(
    id                      BIGINT
   ,created_at              STRING
   ,source                  STRING
   ,favorited               BOOLEAN
   ,retweet_count           INT

   ,retweeted_status        STRUCT
                            <
                                text:STRING

                               ,user:STRUCT
                                <
                                    sreen_name  :STRING
                                   ,name        :STRING
                                >
                            >

   ,entities                STRUCT
                            <
                                urls            :ARRAY<STRING>
                               ,user_mentions   :ARRAY<STRING>
                               ,hashtags        :ARRAY<STRING>
                            >

   ,text                    STRING
   ,user                    STRING
   ,in_reply_to_screen_name STRING
) 
    ROW FORMAT DELIMITED 
    FIELDS TERMINATED BY ","
;