title: Hive external table with JSON SerDe fetching all NULL values
body: <p>My data is stored in HDFS at directory /tmp/kafka/alert in multiple files. Each file contain new-line separated JSON objects like following. </p>
  
  <pre><code>{"alertHistoryId":123456,"entityId":123,"deviceId":"123","alertTypeId":1,"AlertStartDate":"Dec 28, 2016 12:05:48 PM"}
  {"alertHistoryId":123456,"entityId":125,"deviceId":"125","alertTypeId":5,"AlertStartDate":"Dec 28, 2016 11:58:48 AM"}
  </code></pre>
  
  <p>I added hive JSON SerDe jar using below</p>
  
  <pre><code>ADD JAR /usr/local/downloads/hive-serdes-1.0-SNAPSHOT.jar;
  </code></pre>
  
  <p>I created table with following </p>
  
  <pre><code>CREATE EXTERNAL TABLE IF NOT EXISTS my_alert (
  alertHistoryId bigint, entityId bigint, deviceId string, alertTypeId int,  AlertStartDate string
  )
  ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
  LOCATION '/tmp/kafka/alert';
  </code></pre>
  
  <p>table created successfully. But when I fetched data, I got all null values. Anyone got any idea how to resolve this?</p>