kudu-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "445484859@qq.com" <445484...@qq.com>
Subject Fw: Re: kudu-user - Google Groups: Message Pending [{IOvAyOaAr6f8MSoCaXQwADHiJQdpgUvR0}]
Date Tue, 14 Jun 2016 08:06:06 GMT

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 <kudu-user+msgappr@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 <kudu-user@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'
);


Mime
View raw message