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 ","
;