title: Hive error - Select * from table ;
body: <p>I created one external table in hive which was successfully created.</p>
  
  <pre><code>create external table load_tweets(id BIGINT,text STRING)
       ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
       LOCATION '/user/cloudera/data/tweets_raw';
  </code></pre>
  
  <p>But, when I did:</p>
  
  <pre><code>hive&gt; select * from load_tweets;
  </code></pre>
  
  <p>I got the below error:</p>
  
  <blockquote>
    <p>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@5dfb0646; line: 1, column: 2]**</p>
  </blockquote>
  
  <p>Please suggest me how to fix this. Is it the twitter o/p file which was created using flume was corrupted or anything else?</p>