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 table and using left
outer join.
pl. note both the tables have the same field types. problem happens when we
try to insert timestamp field of table1 into timestamp filed of table2.
both table 1 and table 2 are kudu tables with external impala tables.
I am running the query from impala.
Half way through the merge I get a error which really does not point me to
the problematic row.
Error seen is
- Query Status: RUNTIME ERROR, 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.
Has anyone encountered this problem earlier. Is there a way to get a
more concrete error to pinpoint the problem, or some resources on how
to resolve it.
On Wed, Nov 8, 2017 at 10:48 AM, chaitra shivakumar <
chaitra.shivaku...@gmail.com> wrote:
>
> 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
>
--
regards
Chaitra
