[IMPALA-7108] IllegalStateException hit during CardinalityCheckNode.<init>

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 3.1.0
• Fix Version/s: Impala 2.13.0, Impala 3.1.0
• Component/s: Frontend
• Epic Color: ghx-label-1
• Assignee: Zoltán Borók-Nagy
• Reporter: Vincent Tran
• Created: 01/Jun/18 16:29
• Updated: 11/Jun/18 16:41
• Resolved: 11/Jun/18 08:48

Description

The following query produces an IllegalStateException:

[localhost:21000] tpch300_parquet> select i.* from lineitem i 
where i.l_orderkey = ( select t.o_orderkey from ( select * from customer join orders on customer.c_custkey = orders.o_custkey order by 1 limit 1)  t );

Could be related to the change in IMPALA-6314

I0601 12:24:52.200441  6760 Frontend.java:997] Analyzing query: select i.* from lineitem i where i.l_orderkey = ( select t.o_orderkey from ( select * from customer join orders on customer.c_custkey = orders.o_custkey order by 1 limit 1) t )
I0601 12:24:52.206576  6760 Frontend.java:1009] Analysis finished.
I0601 12:24:52.210525  6760 jni-util.cc:230] java.lang.IllegalStateException
	at com.google.common.base.Preconditions.checkState(Preconditions.java:129)
	at org.apache.impala.planner.CardinalityCheckNode.<init>(CardinalityCheckNode.java:45)
	at org.apache.impala.planner.SingleNodePlanner.createInlineViewPlan(SingleNodePlanner.java:1104)
	at org.apache.impala.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:1525)
	at org.apache.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:776)
	at org.apache.impala.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:614)
	at org.apache.impala.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:257)
	at org.apache.impala.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:147)
	at org.apache.impala.planner.Planner.createPlan(Planner.java:101)
	at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:941)
	at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1062)
	at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:156)
I0601 12:24:52.274375  6760 status.cc:125] IllegalStateException: null
    @          0x1891f69  impala::Status::Status()
    @          0x1e70be6  impala::JniUtil::GetJniExceptionMsg()
    @          0x1d2e909  impala::JniUtil::CallJniMethod<>()
    @          0x1d2b563  impala::Frontend::GetExecRequest()
    @          0x1d4d552  impala::ImpalaServer::ExecuteInternal()
    @          0x1d4d09a  impala::ImpalaServer::Execute()
    @          0x1db742c  impala::ImpalaServer::query()
    @          0x2f0641e  beeswax::BeeswaxServiceProcessor::process_query()
    @          0x2f0616c  beeswax::BeeswaxServiceProcessor::dispatchCall()
    @          0x2edfc2d  impala::ImpalaServiceProcessor::dispatchCall()
    @          0x18502f0  apache::thrift::TDispatchProcessor::process()
    @          0x1bb1ac9  apache::thrift::server::TAcceptQueueServer::Task::run()
    @          0x1ba90a9  impala::ThriftThread::RunRunnable()
    @          0x1baa7ad  boost::_mfi::mf2<>::operator()()
    @          0x1baa643  boost::_bi::list3<>::operator()<>()
    @          0x1baa38f  boost::_bi::bind_t<>::operator()()
    @          0x1baa2a2  boost::detail::function::void_function_obj_invoker0<>::invoke()
    @          0x1bef122  boost::function0<>::operator()()
    @          0x1eda873  impala::Thread::SuperviseThread()
    @          0x1ee2a0f  boost::_bi::list5<>::operator()<>()
    @          0x1ee2933  boost::_bi::bind_t<>::operator()()
    @          0x1ee28f6  boost::detail::thread_data<>::run()
    @          0x31ddbca  thread_proxy
    @     0x7f1d612256ba  start_thread
    @     0x7f1d60f5b41d  clone
I0601 12:24:52.274433  6760 impala-server.cc:1011] UnregisterQuery(): query_id=b64705fe2b9d154b:e7592d7800000000
I0601 12:24:52.274439  6760 impala-server.cc:1098] Cancel(): query_id=b64705fe2b9d154b:e7592d7800000000