Skip to main content

kafka stream - target table default value issue

  • July 11, 2019
  • 2 replies
  • 5 views

nrkmahesh

we have configured(streams) automatically Copying Data From Kafka. continues data insertion happens on the table but default (system date) value inserted as '2000-01-01 00:00:00' not system date[basically to inserted timestamp of the record]. is it a issue in vertica or I have to do something else.

kindly note that the default value is properly set on the column. when I run 'update set

=default', it is properly updating current timestamp for al the records...

2 replies

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • July 11, 2019

Could you post more detail on the scheduler, such as target table definition, load-spec, and parser definitions? That will help identify where the wrong date is coming from.


Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • July 12, 2019

Hi, thanks for posting. I can reproduce the issue so I will forward to engineering for further advice.