You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kudu.apache.org by "445484859@qq.com" <44...@qq.com> on 2016/06/14 08:06:06 UTC
Fw: Re: kudu-user - Google Groups: Message Pending [{IOvAyOaAr6f8MSoCaXQwADHiJQdpgUvR0}]
Google Groups: Message Pending [{IOvAyOaAr6f8MSoCaXQwADHiJQdpgUvR0}]
Jerry Fan
445484859@qq.com
From: Mike Percy
Date: 2016-06-14 12:06
To: 445484859
Subject: Re: kudu-user - Google Groups: Message Pending [{IOvAyOaAr6f8MSoCaXQwADHiJQdpgUvR0}]
Hi, please send this message to user@kudu.incubator.apache.org
This mailing list has been retired.
Thanks,
Mike
--
Mike Percy
Software Engineer, Cloudera
On Mon, Jun 13, 2016 at 7:35 PM, kudu-user <ku...@googlegroups.com> wrote:
A message has been sent to the kudu-user group and is awaiting approval. We've included this message for your review.
The message requires moderation because the user does not have permission to post.
You can approve or reject this message or you can approve this message by replying to this email.
Start your own group, visit the help center, or report abuse.
---------- Forwarded message ----------
From: 445484859@qq.com
To: kudu-user <ku...@googlegroups.com>
Cc:
Date: Mon, 13 Jun 2016 19:35:26 -0700 (PDT)
Subject: all tablet servers down when run the 6th query of TPC-H
the query is:
select
sum(l_extendedprice*l_discount) as revenue
from
lineitem_new
where
l_shipdate >= '1994-01-01'
and l_shipdate < '1995-01-01'
and l_discount >= 0.05 and l_discount <= 0.07
and l_quantity < 24;
When i use impala to run this query, all tablet servers will be down.
And get warnings:
Unable to open scanner: Timed out: GetTableLocations(lineitem_new, bucket=207, int64 l_orderkey=-9223372036854775808, int32 l_linenumber=-2147483648, 1) failed: GetTableLocations RPC to 10.128.3.99:7051 timed out after 0.038s
Unable to open scanner: Timed out: GetTableLocations(lineitem_new, bucket=96, int64 l_orderkey=-9223372036854775808, int32 l_linenumber=-2147483648, 1) failed: GetTableLocations RPC to 10.128.3.99:7051 timed out after 0.023s
Unable to open scanner: Timed out: GetTableLocations(lineitem_new, bucket=38, int64 l_orderkey=-9223372036854775808, int32 l_linenumber=-2147483648, 1) failed: GetTableLocations RPC to 10.128.3.99:7051 timed out after 0.028s
Unable to open scanner: Timed out: GetTableLocations(lineitem_new, bucket=61, int64 l_orderkey=-9223372036854775808, int32 l_linenumber=-2147483648, 1) failed: GetTableLocations RPC to 10.128.3.99:7051 timed out after 0.083s
Unable to open scanner: Timed out: GetTableLocations(lineitem_new, bucket=56, int64 l_orderkey=-9223372036854775808, int32 l_linenumber=-2147483648, 1) failed: GetTableLocations RPC to 10.128.3.99:7051 timed out after 0.045s
Unable to open scanner: Timed out: GetTableLocations(lineitem_new, bucket=227, int64 l_orderkey=-9223372036854775808, int32 l_linenumber=-2147483648, 1) failed: GetTableLocations RPC to 10.128.3.99:7051 timed out after 0.056s
and in the error log:
F0614 09:39:49.236127 1207 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236134 1204 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236117 1194 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236143 1212 key_util.cc:229] Unable to handle type 11 in row keysF0F0614 09:39:49.236163 1203 key_util.cc:229] 6Unable to handle type 14 1^@ in row keys9:39:49.236150 1201 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236173 1205 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236189 1210 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236202 1193 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236213 1198 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236232 1211 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236246 1192 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236251 1208 key_util.cc:229] Unable to handle type 11 in row keysF0614 09:39:49.236258 1209 key_util.cc:229] Unable to handle type 11 in row keys
*** Check failure stack trace: ***
@ 0x79b53d google::LogMessage::Fail()
@ 0x79d43d google::LogMessage::SendToLog()
@ 0x79b079 google::LogMessage::Flush()
@ 0x79dedf google::LogMessageFatal::~LogMessageFatal()
@ 0x16b0b21 kudu::key_util::IncrementCell()
@ 0x169a8af kudu::ColumnPredicate::InclusiveRange()
@ 0x75513f kudu::tserver::SetupScanSpec()
@ 0x758c59 kudu::tserver::TabletServiceImpl::HandleNewScanRequest()
@ 0x75b73b kudu::tserver::TabletServiceImpl::Scan()
@ 0x7e935c kudu::tserver::TabletServerServiceIf::Handle()
the table is：
CREATE TABLE lineitem_new (
l_orderkey BIGINT,
l_linenumber INT,
l_partkey BIGINT,
l_suppkey BIGINT,
l_quantity DOUBLE,
l_extendedprice DOUBLE,
l_discount DOUBLE,
l_tax DOUBLE,
l_returnflag STRING,
l_linestatus STRING
l_shipdate STRING,
l_commitdate STRING,
l_receiptdate STRING,
l_shipinstruct STRING,
l_shipmode STRING,
l_comment STRING)
TBLPROPERTIES (
'kudu.master_addresses'='host4.local:7051',
'kudu.key_columns'='l_orderkey, l_linenumber',
'kudu.table_name'='lineitem_new',
'transient_lastDdlTime'='1465803814', 'storage_handler'='com.cloudera.kudu.hive.KuduStorageHandler'
);