Re: Table API: java.sql.DateTime is not supported;

2017-02-06 Thread Fabian Hueske
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

Re: Table API: java.sql.DateTime is not supported;

2017-02-06 Thread nsengupta
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

Re: Table API: java.sql.DateTime is not supported;

2017-02-06 Thread Timo Walther
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"