title: Select query in json serde returns Null value
body: <p>My log file contains a part of log in input_to_log.txt as below:</p>
  
  <pre><code>{"agent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36",
  "context":{"course_id":"edx/AN101/2014_T1","module":{"display_name":"Multiple Choice Questions"},"org_id":"edx","user_id":9999999}}
  </code></pre>
  
  <p>My query in hive shell:</p>
  
  <pre><code>ADD JAR /usr/lib/hive/apache-hive-0.13.0-bin/lib/hive-serde-0.13.0.jar;
  
  CREATE EXTERNAL TABLE edx_lg ( agent STRING,context STRUCT&lt;course_id:STRING,module:STRUCT&lt;display_name:STRING&gt;,org_id:STRING,user_id:INT&gt;)ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.JsonSerde' WITH SERDEPROPERTIES("agent"="$.agent","context"="$.context.course_id,$.context.module.display_name,$.context.org_id,$.context.user_id");
  
  load data local inpath '/home/hduser/input_to_log.txt' into table edx_lg;
  
  select agent,context.course_id,context.module.display_name,context.org_id,context.user_id from edx_lg;
  </code></pre>
  
  <p>My output:</p>
  
  <pre><code>Total jobs = 1
  Launching Job 1 out of 1
  Number of reduce tasks is set to 0 since there's no reduce operator
  Starting Job = job_201406102148_0019, Tracking URL = http://x.x.x.x:50030/jobdetails.jsp?jobid=job_201406102148_0019
  Kill Command = /usr/local/hadoop/libexec/../bin/hadoop job  -kill job_201406102148_0019
  Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
  2014-06-12 03:00:42,300 Stage-1 map = 0%,  reduce = 0%
  2014-06-12 03:00:44,311 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 0.72 sec
  2014-06-12 03:00:46,324 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 0.72 sec
  MapReduce Total cumulative CPU time: 720 msec
  Ended Job = job_201406102148_0019
  </code></pre>
  
  <p>MapReduce Jobs Launched: </p>
  
  <pre><code>Job 0: Map: 1   Cumulative CPU: 0.72 sec   HDFS Read: 467 HDFS Write: 30 SUCCESS
  Total MapReduce CPU Time Spent: 720 msec
  OK
  NULL    NULL    NULL    NULL    NULL
  NULL    NULL    NULL    NULL    NULL
  Time taken: 11.278 seconds, Fetched: 2 row(s)
  </code></pre>
  
  <p>Select statement is returning Null values.What should i do to get the data in my table?</p>