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?

@Vijay1 You cannot do a create table wirh column names and data types, but as part of the CTAS job you can do things like to_char, to_date etc. So if your base data is a list, Dremio should honor that. If it is a string an you need to convert it to a list (or array), you can use convert_from