ADD JAR /hadoop/json-serde-1.3.8-SNAPSHOT-jar-with-dependencies.jar; create table tweets ( created_at string, id bigint, id_str string, text string, source string, truncated boolean, in_reply_to_screen_name string, in_reply_to_status_id bigint, in_reply_to_status_id_str string, in_reply_to_user_id int, in_reply_to_user_id_str string, userprofile struct < id: int, id_str: binary, name: string, screen_name: string, location: string, url: string, description: string, protected: boolean, verified: boolean, followers_count: int, friends_count: int, listed_count: int, favourites_count: int, statuses_count: int, created_at: string, utc_offset: int, time_zone: string, geo_enabled: boolean, lang: string, contributors_enabled: boolean, is_translator: boolean, profile_background_color: string, profile_background_image_url: string, profile_background_image_url_https: string, profile_background_tile: boolean, profile_link_color: string, profile_sidebar_border_color: string, profile_sidebar_fill_color: string, profile_text_color: string, profile_use_background_image: boolean, profile_image_url: string, profile_image_url_https: string, default_profile: boolean, default_profile_image: boolean, followingtweet: boolean, follow_request_sent: int, notifications: int >, geo struct < coordinates: array, type: string >, retweeted_status struct < created_at: string, entities: struct < hashtags: array< struct< text: string>>, media: array< struct< media_url: string, media_url_https: string, url: string>>, user_mentions: array< struct< name: string, screen_name: string>>, geo: struct < coordinates: array, type: string>, id: bigint, id_str: string, in_reply_to_screen_name: string, in_reply_to_status_id: bigint, in_reply_to_status_id_str: string, in_reply_to_user_id: int, in_reply_to_user_id_str: string, source: string, text: string, usertweet: struct < id: int, id_str: string, name: string, profile_image_url_https: string, protected: boolean, screen_name: string, verified: boolean> >> ) ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' STORED AS TEXTFILE;