Which option defines the column type when data is unloaded into Parquet-formatted files?
Use CAST or the :: cast operator in the COPY INTO <location> query to convert a table column to an explicit data type, thereby selecting its Parquet column type. Options such as BINARY_AS_TEXT, EMPTY_FIELD_AS_NULL, and SINGLE do not define Parquet column data types.
CAST
::
COPY INTO <location>
BINARY_AS_TEXT
EMPTY_FIELD_AS_NULL
SINGLE
Community Discussion