Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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

New Contributor

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