Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

problem in handling twitter data with jsonserde api org.apache.hive.hcatalog.data.JsonSerDe

avatar

i have imported twitter data using flume and stored in hdfs

now i want to analyse it using hive

i have created a table as follows

 

Table:create external table jsons(id bigint,text string) row format serde 'org.apache.hive.hcatalog.data.JsonSerDe' location '/user/verax/vamsicp/tw';

 

Now if i query this table

 

select * from jsons;

i am getting following error

 

error:Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: org.codehaus.jackson.JsonParseException: Unexpected character ('O' (code 79)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: java.io.ByteArrayInputStream@afaf7f2; line: 1, column: 2]

 

plese any one solve this issue

 

thanks

Who agreed with this topic