FAQ
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?

Search Discussions

  • Darren Lo at Mar 26, 2013 at 4:13 pm
    Hi Hendra,
    (bcc scm-users)

    The cdh-user mailing list should be able to help you out.

    On Tue, Mar 26, 2013 at 2:50 AM, Hendra Budiawan wrote:

    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?

    --
    Thanks,
    Darren

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedMar 26, '13 at 9:50a
activeMar 26, '13 at 4:13p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Darren Lo: 1 post Hendra Budiawan: 1 post

People

Translate

site design / logo © 2022 Grokbase