You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@impala.apache.org by 俊杰陈 <cj...@gmail.com> on 2017/08/30 02:19:22 UTC
Get No data to read exception.
Hi all
I'm running impala-tpcds-kit and get error when load store_sales table.
Please see follow log.
And then I tried to run "select count(*)" and "compute stats" from external
tables, all queries failed. But I can run query "select * from table limit
num" success.
Can anyone help on this? Thanks in advance.
Plus:
impalad version 2.8.0-SNAPSHOT DEBUG (build
7d9e76620743cced2c09e03cbc7ee9e4b4d7380b)
Built on Tue Aug 29 17:18:04 CST 2017
I0830 10:38:27.834795 76090 Frontend.java:832] Requesting prioritized load
of table(s): tpcds_parquet.store_sales
I0830 10:38:29.544564 76233 impala-server.cc:1289] Catalog topic entry
deletion: TABLE:tpcds_parquet.store_sales
I0830 10:38:31.561718 76090 Frontend.java:927] Compiled query.
I0830 10:38:31.578698 76090 admission-controller.cc:440] Schedule for
id=b4250f83ca73eec:914b08700000000 in pool_name=default-pool
cluster_mem_needed=55.16 GB PoolConfig: max_requests=-1 max_queued=200
max_mem=-1.00 B
I0830 10:38:31.578786 76090 admission-controller.cc:445] Stats:
agg_num_running=0, agg_num_queued=0, agg_mem_reserved=0,
local_host(local_mem_admitted=0, num_admitted_running=0, num_queued=0,
backend_mem_reserved=0)
I0830 10:38:31.578807 76090 admission-controller.cc:451] Admitted query
id=b4250f83ca73eec:914b08700000000
I0830 10:38:31.579042 76090 coordinator.cc:447] Exec()
query_id=b4250f83ca73eec:914b08700000000 stmt=insert overwrite table
store_sales
partition(ss_sold_date_sk) [shuffle]
select
ss_sold_time_sk,
ss_item_sk,
ss_customer_sk,
ss_cdemo_sk,
ss_hdemo_sk,
ss_addr_sk,
ss_store_sk,
ss_promo_sk,
ss_ticket_number,
ss_quantity,
ss_wholesale_cost,
ss_list_price,
ss_sales_price,
ss_ext_discount_amt,
ss_ext_sales_price,
ss_ext_wholesale_cost,
ss_ext_list_price,
ss_ext_tax,
ss_coupon_amt,
ss_net_paid,
ss_net_paid_inc_tax,
ss_net_profit,
ss_sold_date_sk
from et_store_sales
where ss_sold_date_sk
between 2450816 and 2450894
I0830 10:38:31.579722 76090 coordinator.cc:602] starting 10 fragment
instances for query b4250f83ca73eec:914b08700000000
I0830 10:38:31.582734 76033 client-cache.h:260] client 0x9f2d240 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.582773 76033 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n4:22000
I0830 10:38:31.582837 76034 client-cache.h:260] client 0x9f2c9c0 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.582890 76034 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n1:22000
I0830 10:38:31.582967 76042 client-cache.h:260] client 0x9f2d940 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.583077 76042 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n2:22000
I0830 10:38:31.583365 76035 client-cache.h:260] client 0x9f2c180 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.583400 76035 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n3:22000
I0830 10:38:31.583484 76037 client-cache.h:260] client 0x9f2dd80 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.583518 76037 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe722n4:22000
I0830 10:38:31.583706 76031 client-cache.h:260] client 0x9f2c6c0 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.583822 76031 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n1:22000
I0830 10:38:31.583915 76032 client-cache.h:260] client 0xb9ed540 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.583961 76032 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n4:22000
I0830 10:38:31.584661 76041 client-cache.h:260] client 0x9a56100 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.584687 76041 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n2:22000
I0830 10:38:31.585295 76038 client-cache.h:260] client 0xb9ed380 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.585355 76038 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe722n4:22000
I0830 10:38:31.590809 76039 client-cache.h:260] client 0x9a56080 unexpected
exception: No more data to read.,
type=N6apache6thrift9transport19TTransportExceptionE
I0830 10:38:31.590837 76039 client-cache.cc:81] ReopenClient(): re-creating
client for bdpe611n3:22000
I0830 10:38:31.678892 76037 status.cc:47] RPC Error: No more data to read.
@ 0x7fcdfcd331c0 impala::Status::Status()
@ 0x7fcdfc3c8154 impala::ClientConnection<>::DoRpc<>()
@ 0x7fcdfc3a6c09 impala::Coordinator::ExecRemoteFInstance()
@ 0x7fcdfc40c732 std::_Mem_fn<>::operator()<>()
@ 0x7fcdfc40719c
_ZNSt5_BindIFSt7_Mem_fnIMN6impala11CoordinatorEFvRKNS1_19FInstanceExecParamsEPKNS1_12DebugOptionsEEEPS2_St17reference_wrapperIS4_EPS6_EE6__callIvIEILm0ELm1ELm2EEEET_OSt5tupleIIDpT0_EESt12_Index_tupleIIXspT1_EEE
@ 0x7fcdfc3ff608 std::_Bind<>::operator()<>()
@ 0x7fcdfc3ef89d
boost::detail::function::void_function_obj_invoker0<>::invoke()
@ 0x7fcdfc955efc boost::function0<>::operator()()
@ 0x7fcdfc484451 impala::CallableThreadPool::Worker()
@ 0x7fcdfc48a2a5
boost::detail::function::void_function_invoker2<>::invoke()
@ 0x7fcdfc48855d boost::function2<>::operator()()
@ 0x7fcdfc486761 impala::ThreadPool<>::WorkerThread()
@ 0x7fcdfc48edc7 boost::_mfi::mf1<>::operator()()
@ 0x7fcdfc48e495 boost::_bi::list2<>::operator()<>()
@ 0x7fcdfc48d7c7 boost::_bi::bind_t<>::operator()()
@ 0x7fcdfc48ca7b
boost::detail::function::void_function_obj_invoker0<>::invoke()
@ 0x7fcdfc955efc boost::function0<>::operator()()
@ 0x7fcdfc9554a3 impala::Thread::SuperviseThread()
@ 0x7fcdfc95cd9a boost::_bi::list4<>::operator()<>()
@ 0x7fcdfc95ccdd boost::_bi::bind_t<>::operator()()
@ 0x7fcdfc95cc38 boost::detail::thread_data<>::run()
@ 0x872c9a thread_proxy
@ 0x7fcdf6b59dc5 start_thread
@ 0x7fcdf688873d __clone
--
Thanks & Best Regards