You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@impala.apache.org by chaitra shivakumar <ch...@gmail.com> on 2017/11/08 08:48:50 UTC

Error Invalid TimestampValue - Timestamp converstion errror Imapala kudu

Hi,

We recently upgraded to kudu 1.5 and impala 2.10 on cloudera  CDH 5.13

I am trying to merge data from one table into another and using left outer
join.

Half way through the merge I get a error which really does not point me to
the  problematic row.
Error seen is

   - Query Status: Invalid TimestampValue: -16532:15:03.600000000

I can see the error could be because of some conversion issues, but I  was
trying to dig a little deeper into the logs to pin point what  exactly
causes this problem
and all I could find was this

cc:55

Invalid TimestampValue: -16532:15:03.600000000
    @           0x83d85a  impala::Status::Status()
    @           0x8415e2  impala::WriteKuduTimestampValue()
    @           0x842437  impala::WriteKuduValue()
    @           0xce2900  impala::KuduTableSink::Send()
    @           0xa50fc4  impala::FragmentInstanceState::ExecInternal()
    @           0xa543b9  impala::FragmentInstanceState::Exec()
    @           0xa30b38  impala::QueryState::ExecFInstance()
    @           0xbd4722  impala::Thread::SuperviseThread()
    @           0xbd4e84  boost::detail::thread_data<>::run()
    @           0xe6113a  (unknown)
    @     0x7f56b4210dc5  start_thread
    @     0x7f56b3f3dced  __clone

Data set has a few 100 thousand rows of data so It hard to pinpoint manually.

Is there a way to get a more concrete error to pinpoint the problem,
or some resources on how to resolve it.









-- 
regards
Chaitra