Hello,
I'm following this
url http://blog.cloudera.com/blog/2013/03/how-to-analyze-twitter-data-with-hue/
to analyze twitter data, but i'm stuck with this query
CREATE EXTERNAL TABLE tweets (
id BIGINT,
created_at STRING,
source STRING,
favorited BOOLEAN,
retweet_count INT,
retweeted_status STRUCT<
text:STRING,
user:STRUCT>,
entities STRUCT<
urls:ARRAY>,
user_mentions:ARRAY>,
hashtags:ARRAY>>,
text STRING,
user STRUCT<
screen_name:STRING,
name:STRING,
friends_count:INT,
followers_count:INT,
statuses_count:INT,
verified:BOOLEAN,
utc_offset:INT,
time_zone:STRING>,
in_reply_to_screen_name STRING
)
PARTITIONED BY (datehour INT)
ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
LOCATION '/user/flume/tweets'
everytime i execute it said error
==================================================================================================================
Your query has the following error(s):
OK converting to local hdfs://single.example.com:8020/user/flume/flume-sources-1.0-SNAPSHOT.jar Added /tmp/hue/hive_resources/flume-sources-1.0-SNAPSHOT.jar to class path Added resource: /tmp/hue/hive_resources/flume-sources-1.0-SNAPSHOT.jar FAILED: ParseException line 9:25 mismatched input '>' expecting < near 'STRUCT' in struct type
==================================================================================================================
I have try to add "<" folowing the error, but still not works, can anybody help me to resolved this problem?
