impala-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 俊杰陈 <cjjnj...@gmail.com>
Subject Get No data to read exception.
Date Wed, 30 Aug 2017 02:19:22 GMT
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

Mime
View raw message