How to create an Array?

Dremio University
1

In teradata we can create an array data type and can use it as data type in table for a column, like this is there anything in dremio db?

2

@Vijay1 You need to convert a string to struct? Are you trying to do a CTAS or a SELECT?

3

Didn’t get you?
How to insert a value like this (89, 78, 77, 66, 98, 73) in a column in single row as an array for example

4 
SELECT CONVERT_FROM('["1", "2", "3"]', 'json')
5

@balaji.ramaswamy CREATE TABLE sample_data.posts_array AS
select id,
title,
body,
CONVERT_FROM(tags, ‘json’) from DBShift.dbshift.sample_data.posts_val

when running select it running but with CTAS it is throughing error

[Code: 0, SQL State: ] UNSUPPORTED_OPERATION ERROR: Type conversion error for column EXPR$3

[Error Id: a125c8e0-090b-43dc-8d91-43d4dfd0622a on localcent.ss.local:31010]

(java.lang.UnsupportedOperationException) Unsupported arrow type : Null
com.dremio.exec.store.iceberg.SchemaConverter$1.visit():292
com.dremio.exec.store.iceberg.SchemaConverter$1.visit():289
org.apache.arrow.vector.types.pojo.ArrowType$Null.accept():286
com.dremio.exec.store.iceberg.SchemaConverter.toIcebergType():289
com.dremio.exec.store.iceberg.SchemaConverter.toIcebergColumn():275
com.dremio.exec.store.iceberg.SchemaConverter.toIcebergColumn():266
com.dremio.exec.store.iceberg.SchemaConverter.lambda$toIcebergSchema$3():246
java.util.stream.ReferencePipeline$3$1.accept():193
java.util.stream.ReferencePipeline$2$1.accept():175
java.util.ArrayList$ArrayListSpliterator.forEachRemaining():1384
java.util.stream.AbstractPipeline.copyInto():482
java.util.stream.AbstractPipeline.wrapAndCopyInto():472
java.util.stream.ReduceOps$ReduceOp.evaluateSequential():708
java.util.stream.AbstractPipeline.evaluate():234
java.util.stream.ReferencePipeline.collect():566
com.dremio.exec.store.iceberg.SchemaConverter.toIcebergSchema():247
com.dremio.exec.store.iceberg.SchemaConverter.toIcebergSchema():238
com.dremio.exec.store.iceberg.IcebergUtils.getIcebergPartitionSpecFromTransforms():472
com.dremio.exec.planner.sql.handlers.query.DataAdditionCmdHandler.convertToDrel():310
com.dremio.exec.planner.sql.handlers.query.DataAdditionCmdHandler.getPlan():196
com.dremio.exec.planner.sql.handlers.query.CreateTableHandler.doCtas():100
com.dremio.exec.planner.sql.handlers.query.CreateTableHandler.getPlan():69
com.dremio.exec.planner.sql.handlers.EnterpriseCreateTableHandler.getPlan():38
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():59
com.dremio.exec.work.foreman.AttemptManager.plan():502
com.dremio.exec.work.foreman.AttemptManager.lambda$run$4():400
com.dremio.service.commandpool.ReleasableBoundCommandPool.lambda$getWrappedCommand$3():137
com.dremio.service.commandpool.CommandWrapper.run():62
com.dremio.context.RequestContext.run():96
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():180
java.util.concurrent.Executors$RunnableAdapter.call():511
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():750