search

exasol / cloud-storage-extension

Exasol Cloud Storage Extension for accessing formatted data Avro, Orc and Parquet, on public cloud storage systems
MIT License
7 stars 11 forks source link

Set default timezone to UTC in importer #194

Closed morazow closed 2 years ago

morazow commented 2 years ago

Situation

Currently, when importing timestamp values using java.sql.Timestamp, they are converted to the timezone of the database nodes (DBTIMEZONE setting). This leads to the wrong expectations, since Timestamp is always UTC.

Until this this feature is introduced https://github.com/exasol/script-languages-release/issues/539, set the UDF application timezone to UTC using:

TimeZone.setDefault(TimeZone.getTimeZone("UTC"))

Acceptance Criteria

morazow commented 2 years ago

Check that EXPORT is also fixed and behaves similarly.

morazow commented 2 years ago

As discussed with @allipatev, we should enable this with user parameter first so that users are not faced with sudden behavior change.