Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
Impala 2.3.0
-
None
-
This was running on a mini cluster on a randomly generated dataset.
I can give access to the machine where this happened.
Description
The NullPointerException occurs every time the query is executed.
Query:
SELECT
t10.int_col,
COALESCE(t1.field_17, t1.field_18, t10.int_col) AS int_col,
AVG(COALESCE(-504, COALESCE(-497, -110, -415), -791)) OVER (PARTITION BY COALESCE(t1.field_17, t10.int_col, t1.field_21)) AS float_col,
(t1.field_19) * (t10.int_col) AS int_col_1,
COALESCE(t1.field_17, t10.int_col, t1.field_21) AS int_col_2
FROM table_1 t1
INNER JOIN (
SELECT
LAG(921, 26) OVER (ORDER BY (t8.pos) <= (t7.int_col_1)) AS int_col,
(t8.pos) <= (t7.int_col_1) AS boolean_col
FROM t1.field_20 t2
INNER JOIN (
SELECT
GREATEST(COALESCE(t4.pos, -969), COALESCE(t5.pos, -166)) AS int_col,
MIN((t3.pos) - (t4.pos)) AS int_col_1,
(t3.pos) - (t4.pos) AS int_col_2,
(EXTRACT(SECOND FROM CAST('2002-01-09 00:00:00' AS TIMESTAMP))) * (LEAD(-374) OVER (PARTITION BY t6.pos ORDER BY t6.pos, GREATEST(COALESCE(t4.pos, -969), COALESCE(t5.pos, -166)) ASC)) AS int_col_3,
t6.pos
FROM t2.value t3
INNER JOIN t2.value t4 ON (((t4.pos) = (t3.pos)) AND ((t4.pos) = (t3.pos))) AND ((t4.pos) = (t3.pos))
INNER JOIN t2.value t5 ON (((t5.pos) = (t4.pos)) AND ((t5.pos) = (t4.item))) AND ((t5.pos) = (t4.pos))
INNER JOIN t2.value t6 ON (t6.pos) = (t4.item)
GROUP BY
GREATEST(COALESCE(t4.pos, -969), COALESCE(t5.pos, -166)),
(t3.pos) - (t4.pos),
t6.pos
) t7
INNER JOIN t2.value t8
INNER JOIN t1.field_23 t9 ON (((t9.value.field_29) = (t7.pos)) AND ((t9.value.field_29) = (t7.int_col_3))) AND ((t9.value.field_29) = (t7.int_col_2))
WHERE
(t8.pos) > (t8.pos)
) t10
INNER JOIN t1.field_20 t11
FE Stack Trace:
I0923 14:32:37.360023 10333 jni-util.cc:177] java.lang.NullPointerException
at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:187)
at com.cloudera.impala.planner.AnalyticPlanner.computeInputPartitionExprs(AnalyticPlanner.java:209)
at com.cloudera.impala.planner.AnalyticPlanner.createSingleNodePlan(AnalyticPlanner.java:111)
at com.cloudera.impala.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:209)
at com.cloudera.impala.planner.SingleNodePlanner.createInlineViewPlan(SingleNodePlanner.java:1040)
at com.cloudera.impala.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:1409)
at com.cloudera.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:761)
at com.cloudera.impala.planner.SingleNodePlanner.createSubplan(SingleNodePlanner.java:832)
at com.cloudera.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:763)
at com.cloudera.impala.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:599)
at com.cloudera.impala.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:200)
at com.cloudera.impala.planner.SingleNodePlanner.createInlineViewPlan(SingleNodePlanner.java:1040)
at com.cloudera.impala.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:1409)
at com.cloudera.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:761)
at com.cloudera.impala.planner.SingleNodePlanner.createSubplan(SingleNodePlanner.java:832)
at com.cloudera.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:763)
at com.cloudera.impala.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:599)
at com.cloudera.impala.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:200)
at com.cloudera.impala.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:135)
at com.cloudera.impala.planner.Planner.createPlan(Planner.java:58)
at com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:897)
at com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:147)
BE Stack Trace:
I0923 14:15:12.426978 10331 status.cc:112] NullPointerException: null @ 0xfa61c3 impala::Status::Status() @ 0x14168cc impala::JniUtil::GetJniExceptionMsg() @ 0x12bed89 impala::JniUtil::CallJniMethod<>() @ 0x12bb79b impala::Frontend::GetExecRequest() @ 0x12d87b1 impala::ImpalaServer::ExecuteInternal() @ 0x12d8319 impala::ImpalaServer::Execute() @ 0x13492b4 impala::ImpalaServer::query() @ 0x14e5b67 beeswax::BeeswaxServiceProcessor::process_query() @ 0x14e5878 beeswax::BeeswaxServiceProcessor::dispatchCall() @ 0x14cece1 impala::ImpalaServiceProcessor::dispatchCall() @ 0x12e609d apache::thrift::TDispatchProcessor::process() @ 0x20b662a apache::thrift::server::TThreadPoolServer::Task::run() @ 0x20a2d6f apache::thrift::concurrency::ThreadManager::Task::run() @ 0x20a59da apache::thrift::concurrency::ThreadManager::Worker::run() @ 0x121153f impala::ThriftThread::RunRunnable() @ 0x1212d07 boost::_mfi::mf2<>::operator()() @ 0x1212b62 boost::_bi::list3<>::operator()<>() @ 0x12128f3 boost::_bi::bind_t<>::operator()() @ 0x1212814 boost::detail::function::void_function_obj_invoker0<>::invoke() @ 0x1247ba6 boost::function0<>::operator()() @ 0x14577af impala::Thread::SuperviseThread() @ 0x14609e5 boost::_bi::list4<>::operator()<>() @ 0x146092f boost::_bi::bind_t<>::operator()() @ 0x14608f4 boost::detail::thread_data<>::run() @ 0x7f8c40e3fa4a (unknown) @ 0x7f8c402ec182 start_thread @ 0x7f8c3df3947d (unknown)