Create a Table with Array Columns

With LeanXcale, creating a table with array columns is straightforward. You can define an array column in your create table statement using the array data type, allowing you to store collections of values in a single column.

createTable = ‘CREATE TABLE tarry ("
		id INT,
		longs BIGINT ARRAY,
		doubles DOUBLE ARRAY,
		strings VARCHAR ARRAY,
		PRIMARY KEY(id))’;
try:
    cursor = conn.cursor()
    cursor.execute(createTable)
    conn.commit()
except Exception as e:
    print("Error:", e)
finally:
    cursor.close()