Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Spark-vertica connector adding 4hr to timestamp value.

I am fetching data from soucre (UTC+4) to spark (UTC), till here there is no change in timestamp value but when writing same data on Vertica (UTC+4), it is adding 4hr.

We can't change the timezone for whole vertica cluster.

Answers

  • For fetching data from source i am using plain jdbc and for load in to vertica i am using spark-vertica connector (V2).

  • SruthiASruthiA Employee

    @rj4rahuljha Could you please share sample spark program demonstrating the issue?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.