[
https://issues.apache.org/jira/browse/IMPALA-8909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16919016#comment-16919016
]
Tim Armstrong commented on IMPALA-8909:
---------------------------------------
On a release build I see
{noformat}
[localhost:21000] default> insert into temp.t_one( id, test_time, name )
select '1' as id,concat(cdate,ctime) as test_time,'gogogo' as name
from temp.t_two;
Query: insert into temp.t_one( id, test_time, name )
select '1' as id,concat(cdate,ctime) as test_time,'gogogo' as name
from temp.t_two
Query submitted at: 2019-08-29 15:34:34 (Coordinator:
http://tarmstrong-box:25000)
Query progress can be monitored at:
http://tarmstrong-box:25000/query_plan?query_id=99415d592b420465:8aef4cff00000000
ERROR: Invalid TimestampValue:
{noformat}
> Timestamp timezone conversion causes impalad crash
> --------------------------------------------------
>
> Key: IMPALA-8909
> URL: https://issues.apache.org/jira/browse/IMPALA-8909
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.12.0
> Environment: centos 7.5
> Reporter: qi
> Priority: Blocker
> Labels: crash
>
> step1: create two tables
> {code:java}
> CREATE TABLE temp.t_one
> (
> id string,
> test_time timestamp,
> name string,
> PRIMARY KEY(id,test_time)
> )
> PARTITION BY HASH (id) PARTITIONS 8,
> RANGE(test_time)
> (
> PARTITION VALUES < '2011-01-01 00:00:00',
> PARTITION '2011-01-01 00:00:00' <= VALUES < '2021-01-01 00:00:00',
> PARTITION '2021-01-01 00:00:00' <= VALUES
> )
> STORED AS KUDU;
> CREATE TABLE temp.t_two
> (
> cdate string,
> ctime string
> );
> {code}
> step2:insert some data into t_two
> {code:java}
> insert into temp.t_two values('20190101','00:00:00');
> {code}
> step3:insert data into t_one from t_two,*{color:#FF0000}cause impalad
> crash!!{color}*{color:#172b4d}{color}
> {code:java}
> insert into temp.t_one( id, test_time, name )
> select '1' as id,concat(cdate,ctime) as test_time,'gogogo' as name
> from temp.t_two;
> {code}
>
> impalad.ERROR
> {code:java}
> terminate called after throwing an instance of
> 'boost::exception_detail::clone_impl<boost::exception_detail::error_info_injector<boost::gregorian::bad_year>
> >'
> what(): Year is out of valid range: 1400..10000
> {code}
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
