|[geomesa-users] R: Error on import data from nifi|
thanks a lot Emilio! You saved my day. I didn't think about conversion in CSVReader and now, following what you have suggested, works all right.
Da: geomesa-users <geomesa-users-bounces@xxxxxxxxxxx> per conto di Emilio Lahr-Vivaz <elahrvivaz@xxxxxxxx>
Inviato: venerdì 21 maggio 2021 14:48
A: geomesa-users@xxxxxxxxxxx <geomesa-users@xxxxxxxxxxx>
Oggetto: Re: [geomesa-users] Error on import data from nifi
The default date column would just be configured with the name of your date attribute, i.e. "time" (although if you only have one date-type field then you can leave it empty). However, it doesn't automatically convert the attribute to a date-type field, that has to be done with the record reader you configure. If you're using TSV, presumably you're using the CSVReader controller service record reader with 'inferred schema'. In the configuration for the controller service, you need to make the 'Date Format' property match the format of the dates in your data, so that the reader infers that it's a date column. If you're using a different schema strategy or controller service, the exact steps would be different but the end goal would be the same: to make the record reader type that column as a date.
I opened a ticket here to automatically force the specified default date field into a date-type field, to make this easier in the future: https://geomesa.atlassian.net/browse/GEOMESA-3080
On 5/21/21 3:25 AM, Francesco Gusmeroli wrote:
Back to the top