# Dremio not create CTA with array fields

**URL:** <https://community.dremio.com/t/dremio-not-create-cta-with-array-fields/13161>\
**Category:** Uncategorized\
**Created:** [August 9, 2025, 11:49pm UTC](https://community.dremio.com/t/dremio-not-create-cta-with-array-fields/13161 "2025-08-09T23:49:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dacopan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dacopan/32/4289_2.png) [@dacopan](https://community.dremio.com/u/dacopan)\
**Post date:** [August 9, 2025, 11:49pm UTC](https://community.dremio.com/t/dremio-not-create-cta-with-array-fields/13161/1 "2025-08-09T23:49:12Z")

</div>

Hello, we have a dremio to dremio connection in dremio1 we have a table that has array field that for strange reason are recognized as string as show here [Dremio to Dremio with array column in table](https://community.dremio.com/t/dremio-to-dremio-with-array-column-in-table/13160) so we want create a new table first converting to array, but the select works but saving with CTA not work, I attach both profiles.

[16c25cf8-9480-4400-a17e-2c69bdba4817-ok.zip](https://community.dremio.com/uploads/short-url/iNLUdbaxCVRCzoLKTPfGsoNIAFu.zip) (16,6 KB)

[bb84fd68-0376-488f-9830-e91c2bd52097-error.zip](https://community.dremio.com/uploads/short-url/gCc3NouGk2Vq8PHUwwS0ZpI68n2.zip) (11,2 KB)

---

<div class="post-metadata">

**Author:** ![dacopan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dacopan/32/4289_2.png) [@dacopan](https://community.dremio.com/u/dacopan)\
**Post date:** [August 16, 2025, 2:09pm UTC](https://community.dremio.com/t/dremio-not-create-cta-with-array-fields/13161/2 "2025-08-16T14:09:11Z")

</div>

@dch or @balaji.ramaswamy can you help me please?

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [September 2, 2025, 5:45pm UTC](https://community.dremio.com/t/dremio-not-create-cta-with-array-fields/13161/3 "2025-09-02T17:45:38Z")

</div>

@dacopan Same issue that @dch responded?

> [@Dremio to Dremio with array column in table](https://community.dremio.com/t/dremio-to-dremio-with-array-column-in-table/13160/3):
>
> No, it’s a documented limitation: [Dremio Cluster | Dremio Documentation](https://docs.dremio.com/current/data-sources/databases/dremio/#limitation)

---

<div class="post-metadata">

**Author:** ![dacopan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dacopan/32/4289_2.png) [@dacopan](https://community.dremio.com/u/dacopan)\
**Post date:** [September 2, 2025, 7:32pm UTC](https://community.dremio.com/t/dremio-not-create-cta-with-array-fields/13161/4 "2025-09-02T19:32:03Z")

</div>

Hello @balaji.ramaswamy not is not the same, because select works but CTA not work

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [September 4, 2025, 9:32pm UTC](https://community.dremio.com/t/dremio-not-create-cta-with-array-fields/13161/5 "2025-09-04T21:32:41Z")

</div>

@dacopan If the CTAS works without the VERBS field being selected then it seems like the limitation,

Does the CTAS work without the `CONVERT_FROM_JSON`?

If it does, then you can create the table as VERBS as type VARCHAR and then do the convert\_from locally?

```auto
convert_from(VERBS, 'JSON') AS VERBS

```