Hi,
you can also use the CsvTableSource and read the DateTime fields as String.
This will directly give you a table. You can implement a user-defined
scalar function [1] to parse the String into a DateTime type.
The benefit is that you stay in the Table API / SQL and don't have to deal
with the D
Hello Timo,
Thanks for the clarification.
This means that I *cannot use CsvTableSource*, as I have, in the example.
Instead, I should:
* Write custom Scalar function to convert STRINGs to other datatypes as
required
* Read the file as CsvInput, with all fields as STRINGs
* Apply the Sca
Hi,
java.sql.Timestamps have to have a format like " -mm-dd
hh:mm:ss.[fff...]". In your case you need to parse this as a String and
write your own scalar function for parsing.
Regards,
Timo
Am 04/02/17 um 17:46 schrieb nsengupta:
"4/1/2014 0:11:00",40.769,-73.9549,"B02512"