CREATE TABLE tweets ( contributors string, coordinates array<array<array<double>, created_at string, entities structhashtags:arraystructindices:arrayint>, text:string>, media:arraystructdisplay_url:string, expanded_url:string, id:int, id_str:string, indices:arrayint>, media_url:string, media_url_https:string, sizes:structlarge:structh:int, resize:string, w:int>, medium:structh:int, resize:string, w:int>, small:structh:int, resize:string, w:int>, thumb:structh:int, resize:string, w:int>, source_status_id:int, source_status_id_str:string, source_user_id:int, source_user_id_str:string, type:string, url:string>, symbols:arraystructindices:arrayint>, text:string>, urls:arraystructdisplay_url:string, expanded_url:string, indices:arrayint>, url:string>, user_mentions:arraystructid:int, id_str:string, indices:arrayint>, name:string, screen_name:string>, extended_entities struct<media:array<struct<additional_media_info:struct<call_to_actions:struct<watch_now:struct<url:string>, description:string, embeddable:boolean, monetizable:boolean, source_user:structcontributors_enabled:boolean, created_at:string, default_profile:boolean, default_profile_image:boolean, description:string, entities:struct<description:struct<urls:array<struct<display_url:string, expanded_url:string, indices:arrayint>, url:string>, url:struct<urls:array<struct<display_url:string, expanded_url:string, indices:arrayint>, url:string>, favourites_count:int, follow_request_sent:boolean, followers_count:int, `following`:boolean, friends_count:int, geo_enabled:boolean, has_extended_profile:boolean, id:int, id_str:string, is_translation_enabled:boolean, is_translator:boolean, lang:string, listed_count:int, location:string, name:string, notifications:boolean, profile_background_color:string, profile_background_image_url:string, profile_background_image_url_https:string, profile_background_tile:boolean, profile_banner_url:string, profile_image_url:string, profile_image_url_https:string, profile_link_color:string, profile_sidebar_border_color:string, profile_sidebar_fill_color:string, profile_text_color:string, profile_use_background_image:boolean, protected:boolean, screen_name:string, statuses_count:int, time_zone:string, translator_type:string, url:string, utc_offset:string, verified:boolean>, title:string>, display_url:string, expanded_url:string, id:int, id_str:string, indices:arrayint>, media_url:string, media_url_https:string, sizes:structlarge:structh:int, resize:string, w:int>, medium:structh:int, resize:string, w:int>, small:structh:int, resize:string, w:int>, thumb:structh:int, resize:string, w:int>, source_status_id:int, source_status_id_str:string, source_user_id:int, source_user_id_str:string, type:string, url:string, video_info:structaspect_ratio:arrayint>, duration_millis:int, variants:arraystructcontent_type:string, url:string>, favorite_countint, favorited boolean, geo string, id int, id_str string, in_reply_to_screen_name string, in_reply_to_status_idint, in_reply_to_status_id_str string, in_reply_to_user_idint, in_reply_to_user_id_str string, is_quote_statusboolean, lang string, place struct<bounding_box:struct<coordinates:array<array<array<double>, type:string>, contained_within:arrayint>, country:string, country_code:string, full_name:string, id:string, name:string, place_type:string, url:string>, possibly_sensitiveboolean, possibly_sensitive_appealableboolean, retweet_countint, retweeted boolean, retweeted_statusstructcontributors:string, coordinates:array<array<array<double>, created_at:string, entities:structhashtags:arraystructindices:arrayint>, text:string>, media:arraystructdisplay_url:string, expanded_url:string, id:int, id_str:string, indices:arrayint>, media_url:string, media_url_https:string, sizes:structlarge:structh:int, resize:string, w:int>, medium:structh:int, resize:string, w:int>, small:structh:int, resize:string, w:int>, thumb:structh:int, resize:string, w:int>, type:string, url:string>, symbols:arraystructindices:arrayint>, text:string>, urls:arraystructdisplay_url:string, expanded_url:string, indices:arrayint>, url:string>, user_mentions:arraystructid:int, id_str:string, indices:arrayint>, name:string, screen_name:string>, extended_entities:struct<media:array<struct<additional_media_info:struct<call_to_actions:struct<watch_now:struct<url:string>, description:string, embeddable:boolean, monetizable:boolean, title:string>, display_url:string, expanded_url:string, id:int, id_str:string, indices:arrayint>, media_url:string, media_url_https:string, sizes:structlarge:structh:int, resize:string, w:int>, medium:structh:int, resize:string, w:int>, small:structh:int, resize:string, w:int>, thumb:structh:int, resize:string, w:int>, type:string, url:string, video_info:structaspect_ratio:arrayint>, duration_millis:int, variants:arraystructcontent_type:string, url:string>, favorite_count:int, favorited:boolean, geo:string, id:int, id_str:string, in_reply_to_screen_name:string, in_reply_to_status_id:int, in_reply_to_status_id_str:string, in_reply_to_user_id:int, in_reply_to_user_id_str:string, is_quote_status:boolean, lang:string, place:struct<bounding_box:struct<coordinates:array<array<array<double>, type:string>, contained_within:arrayint>, country:string, country_code:string, full_name:string, id:string, name:string, place_type:string, url:string>, possibly_sensitive:boolean, possibly_sensitive_appealable:boolean, retweet_count:int, retweeted:boolean, source:string, text:string, truncated:boolean, `user`:structcontributors_enabled:boolean, created_at:string, default_profile:boolean, default_profile_image:boolean, description:string, entities:struct<description:struct<urls:array<struct<display_url:string, expanded_url:string, indices:arrayint>, url:string>, url:struct<urls:array<struct<display_url:string, expanded_url:string, indices:arrayint>, url:string>, favourites_count:int, follow_request_sent:boolean, followers_count:int, `following`:boolean, friends_count:int, geo_enabled:boolean, has_extended_profile:boolean, id:int, id_str:string, is_translation_enabled:boolean, is_translator:boolean, lang:string, listed_count:int, location:string, name:string, notifications:boolean, profile_background_color:string, profile_background_image_url:string, profile_background_image_url_https:string, profile_background_tile:boolean, profile_banner_url:string, profile_image_url:string, profile_image_url_https:string, profile_link_color:string, profile_sidebar_border_color:string, profile_sidebar_fill_color:string, profile_text_color:string, profile_use_background_image:boolean, protected:boolean, screen_name:string, statuses_count:int, time_zone:string, translator_type:string, url:string, utc_offset:string, verified:boolean>, source string, text string, truncated boolean, `user` structcontributors_enabled:boolean, created_at:string, default_profile:boolean, default_profile_image:boolean, description:string, entities:struct<description:struct<urls:array<struct<display_url:string, expanded_url:string, indices:arrayint>, url:string>, favourites_count:int, follow_request_sent:boolean, followers_count:int, `following`:boolean, friends_count:int, geo_enabled:boolean, has_extended_profile:boolean, id:int, id_str:string, is_translation_enabled:boolean, is_translator:boolean, lang:string, listed_count:int, location:string, name:string, notifications:boolean, profile_background_color:string, profile_background_image_url:string, profile_background_image_url_https:string, profile_background_tile:boolean, profile_banner_url:string, profile_image_url:string, profile_image_url_https:string, profile_link_color:string, profile_sidebar_border_color:string, profile_sidebar_fill_color:string, profile_text_color:string, profile_use_background_image:boolean, protected:boolean, screen_name:string, statuses_count:int, time_zone:string, translator_type:string, url:string, utc_offset:int, verified:boolean>)ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe';