You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (Jira)" <ji...@apache.org> on 2019/08/29 22:26:00 UTC
[jira] [Updated] (IMPALA-8909) Timestamp timezone conversion causes
impalad crash
[ https://issues.apache.org/jira/browse/IMPALA-8909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong updated IMPALA-8909:
----------------------------------
Description:
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}
was:
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 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}
> 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: Major
>
> 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org