How to create hive table on many .gz compressed .json files?
<p>I have directory on hdfs with .json files, .gz compressed ( almost 1k of them). I want to create hive table using those files (Cloudera environment). I tried many ways, for example:</p>

<pre><code>CREATE EXTERNAL TABLE `my_data_table`(
    `timestamp` timestamp,
    `ip` string,
    `name` string,
    `id` string,
    `job` string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT
   'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
   'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
   'hdfs://my/files/location'
</code></pre>

<p>But table shows cell values as well as tags. (example:</p>

<blockquote>
  <p>"name":"John"</p>
</blockquote>

<p>instead of </p>

<blockquote>
  <p>John</p>
</blockquote>

<p>)  Data in .json looks like below (1 line of many, just for example):</p>

<pre><code>{"timestamp":"2015-05-09T04:24:58Z","ip":"123.321.12.123","name":"John","id":"EX291236","job":"Programmer","phone":["number:2874723467","model:Alcatel","os:Android"]}
</code></pre>

<p>I was also wondering how to include "phone" data which needs to be handled some special way, obviously. Hope you guys can help me with that.</p>