https://community.databricks.com/t5/data-engineering/is-there-only-one-element-type-option-for-an-array/m-p/30498#M22116 <P>I'm creating an array which contains both string and double, just wondering if I can have multiple element type options for one array column? Thanks</P><P></P> Wed, 28 Sep 2022 01:01:43 GMT Panna 2022-09-28T01:01:43Z https://community.databricks.com/t5/data-engineering/is-there-only-one-element-type-option-for-an-array/m-p/30498#M22116 <P>I'm creating an array which contains both string and double, just wondering if I can have multiple element type options for one array column? Thanks</P><P></P> Wed, 28 Sep 2022 01:01:43 GMT https://community.databricks.com/t5/data-engineering/is-there-only-one-element-type-option-for-an-array/m-p/30498#M22116 Panna 2022-09-28T01:01:43Z https://community.databricks.com/t5/data-engineering/is-there-only-one-element-type-option-for-an-array/m-p/30499#M22117 <P>Elements of any type that share a least common type can be used, <A href="https://docs.databricks.com/sql/language-manual/functions/array.html#arguments" target="test_blank">https://docs.databricks.com/sql/language-manual/functions/array.html#arguments</A>.</P><P>Please correct me if I misunderstood to understand the requirement. </P> Wed, 28 Sep 2022 15:32:26 GMT https://community.databricks.com/t5/data-engineering/is-there-only-one-element-type-option-for-an-array/m-p/30499#M22117 Debayan 2022-09-28T15:32:26Z