How to create an Array in dremio DB

How to deal with arrays in dremio DB like creating an array, applying various array related functions?

@Vijay1 Dremio is not a database but a Lakehouse engine that runs queries against your data sources like S3/HDFS/Oracle etc. Dremio does read arrays. Are you trying to create a table in Dremio based of a SQL?

yes sir, i am trying to create a table in dremio based on SQL. How can i do that?