CREATE EXTERNAL TABLE tweets (
 entities STRUCT<
   urls:ARRAY<STRING>,
   user_mentions:ARRAY<STRING>,
   hashtags:ARRAY<STRUCT<text:STRING,indicies:STRING>>>
)
ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
LOCATION '/path/to/your/twitter-json/';