title: Hive table with nested JSON as string value
body: <p>I am trying to create a table from nested json.<br>
  The second layer of the the JSON is very complex and I don't want to keep the schema of that JSON in the table definition with struct column. </p>
  
  <p>I am looking for solution that allow me to keep it as string.</p>
  
  <p>for example:</p>
  
  <pre><code>{
  "request_id": "3dbd4ee3-96fc-4342-bd62",
  "payload": { &lt; COMPLEX NESTED JSON &gt;  },
  "timestamp": 1569161622
  }
  </code></pre>
  
  <p>I was trying to use the following create statement:</p>
  
  <pre><code>CREATE EXTERNAL TABLE data (
  request_id string,
  payload string,
  `timestamp` int
  )
  ROW FORMAT  serde 'org.apache.hive.hcatalog.data.JsonSerDe'
  LOCATION 's3a://bucket'
  </code></pre>
  
  <p>Is there any <code>SerDe</code> property/mapping I can use to define the nested object as String?</p>