28806
DISCUSSIONS
102200
MEMBERS
3161
ARTICLES
Created 01-25-2017 11:21 PM
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