title: How to combine 'NESTED PATH` values using JSON_TABLE to fetch a nested JSON array?
body: <p>I have a Json array while looks as below</p>
  <pre><code>[{&quot;keyId&quot;: &quot;aded5b0107bb5a936604bcb6f&quot;, &quot;keyNames&quot;: [&quot;abc1, abc2&quot;], &quot;keyDesc&quot;: &quot;test&quot;}]
  </code></pre>
  <p>I am using JSON_TABLE to fetch all the values and I have written the following query:</p>
  <pre><code>SELECT j.keyId, j.keyNames, j.keyDesc
  FROM asknow a, JSON_TABLE(value, '$[*]' 
      COLUMNS(
        keyId TEXT PATH '$.keyId',
        NESTED PATH '$.keyNames[*]' COLUMNS (keyNames TEXT PATH '$'),
        keyDesc TEXT PATH '$.keyDesc')
      ) AS j;
  </code></pre>
  <p>I am getting following output:</p>
  <pre><code>keyId                        keyNames   keyDesc
  aded5b0107bb5a936604bcb6f    abc1       test
  aded5b0107bb5a936604bcb6f    abc2       test
  </code></pre>
  <p>How to modify the query so as to combine the values into a single string <code>&quot;abc1, abc2&quot;</code>?</p>
  <blockquote>
  <p>Desired Output:</p>
  </blockquote>
  <pre><code>keyId                        keyNames   keyDesc
  aded5b0107bb5a936604bcb6f    abc1, abc2       test
  </code></pre>