title: Collecting data from JSON array into ClickHouse table
body: <p>I have some raw JSON data in ClickHouse table (actually, netflow V9 from netflow collector)
  it looks like this:</p>
  <pre><code>{&quot;AgentID&quot;:&quot;10.1.8.1&quot;,
         &quot;Header&quot;:{&quot;Version&quot;:9,&quot;Count&quot;:2},
         &quot;DataSets&quot;:[
              [{&quot;I&quot;:2,&quot;V&quot;:&quot;231&quot;},{&quot;I&quot;:3,&quot;V&quot;:&quot;151&quot;},{&quot;I&quot;:8,&quot;V&quot;:&quot;109.195.122.130&quot;}],
              [{&quot;I&quot;:2,&quot;V&quot;:&quot;341&quot;},{&quot;I&quot;:3,&quot;V&quot;:&quot;221&quot;},{&quot;I&quot;:8,&quot;V&quot;:&quot;109.195.122.233&quot;}]
         
         ]}'
  </code></pre>
  <p>My task is to convert DataSets arrays into another ClickHouse table in the following way:</p>
  <pre><code>I2     I3    I8
  -----------------------------
  231    151   109.195.122.130
  341    221   109.195.122.233
  ...
   
  </code></pre>