TIMESTAMP with microsecond precision because zero value is outside the scope of the parquet type - error while fetching data from SingleStore to Parquet

Help
1

I am using SELECT * FROM … INTO S3 … FORMAT PARQUET query to fetch data out of SingleStore into S3. For one of the tables, I am getting following error:

failed to format to PARQUET: failed to convert value “0000-00-00 00:00:00.000000” at row #550 col #39 (“READY_TO_ORDER_DATE”) for parquet (coldef={Name:READY_TO_ORDER_DATE CharSet:63 Length:26 FieldType:12 Flags:128 Decimals:6}): “0000-00-00 00:00:00.000000” can not be saved as TIMESTAMP with microsecond precision because zero value is outside the scope of the parquet type; consider casting this column to INT64.

I am dynamically generating SELECT query, therefore I don’t have column names with me. Is there way to use “set” with SELECT query here?

2

What is the default value set for the column READY_TO_ORDER_DATE ?

3

It is NULL. Is_NULLable = Yes.

4

Consider listing out all the columns you want instead of using select * except for the offending column, use a CASE expression so if the value is all 0s, replace it with the minimum legal value or NULL, otherwise return the value as is.