SQL
This document contains all custom SQL options defined by the TileDB Presto connector.
Create Table
The following properties can be configured for creating a TileDB array in Presto.
This document contains all custom SQL options defined by the TileDB Presto connector.
The following properties can be configured for creating a TileDB array in Presto.
Property | Description | Default Value | Possible Values | Required |
---|---|---|---|---|
Property | Description | Default Value | Possible Values | Required |
---|---|---|---|---|
uri
URI for array to be created at
""
*
Yes
type
Array Type
SPARSE
SPARSE, DENSE
No
cell_order
Cell order for array
ROW_MAJOR
ROW_MAJOR, COL_MAJOR, GLOBAL_ORDER
No
tile_order
Tile order for array
ROW_MAJOR
ROW_MAJOR, COL_MAJOR, GLOBAL_ORDER
No
capacity
Capacity of sparse array
10000L
>0
No
dimension
Is column a dimension
False
True, False
No
lower_bound
Domain Lower Bound
0L
Any Long Value
No
upper_bound
Domain Upper Bound
Long.MAX_VALUE
Any Long Value
No
extent
Dimension Extent
10L
Any Long Value
No