Trying to create an external table from JSON in hive
<pre><code>{"name":"Our Example","link_params":{"cid":"eml_mmj_{date('yyyyMMdd')}"},"template":"Great Example Television","day":"2016-10-02","list_name":"Example Television","id":5112652}
</code></pre>

<p>Here's an example row from the json file.</p>

<pre><code>CREATE TABLE company_analysis.extable (
    name string,
    link_params struct&lt;cid:STRING&gt;,
    template string,
    day string,
    list_name string,
    id string)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
STORED AS TEXTFILE
LOCATION '/analysis/company/extable';
</code></pre>

<p>This is the command I've been trying.</p>

<p>I'm getting a blank return when I select * from it.</p>

<p>Any ideas? This is my first time working with JSON and I'm not really a hive expert.</p>

<p>I added the json-serde-1.3.7-jar-with-dependencies.jar file here, not sure if that was the best/only route.</p>