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<float>,
      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<float>,
         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.apache.hive.hcatalog.data.JsonSerDe'