Hello,
I Imported my dataset from Excel. It contains only one
column which have in Excel a “Date” data type.
This column contains 3 values - two valid dates and one invalid.
I want to use “Split by Data Type…” functionality to split the dataset into
two columns: One column with valid dates of type “Timestamp” and the second on with invalid Dates as “Varchar”.
But I am getting
“No enum constant com.dremio.common.types.TypeProtos.MinorType.TIMESTAMPMILLI” error.
Data Types:
SELECT distinct typeof(Bestelldat) FROM s924_bestelldatum_2
EXPR$0
TIMESTAMPMILLI
VARCHAR