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/'
;