Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
Impala 2.3.0
-
commit 1d305f5899d1fedecbdef39d85d5c15a09450a68
Description
The query below fails a check
use random_nested_db_1; SELECT (266) / (AVG(-961)) AS float_col FROM table_2.field_72.item t1 LEFT JOIN ( SELECT IF(True, t8.char_col, t8.char_col) AS char_col, t2.key AS char_col_t9, CAST(-559 AS STRING) AS char_col_t10, LEAD(CEIL((713.811952505) / (879)), 2) OVER (ORDER BY IF(True, t8.char_col, t8.char_col), t2.key DESC) AS float_col FROM t1.value t2 INNER JOIN ( SELECT CAST(863 AS STRING) AS char_col, CAST(584 AS STRING) AS char_col_t4 FROM t1.value t3 UNION ALL SELECT t5.key AS char_col, LEAD(COALESCE(CAST(985 AS STRING), '-616'), 65) OVER (ORDER BY t5.key) AS char_col_t7 FROM t1.value t5 LEFT JOIN t1.value t6 ON (((t6.key) = (t5.key)) AND ((t6.key) = (t5.key))) AND ((t6.key) = (t5.key)) WHERE (719) IN (609, 170) ) t8 ON (((t8.char_col_t4) = (t2.key)) AND ((t8.char_col_t4) = (t2.key))) AND ((t8.char_col_t4) = (t2.key)) ) t11
I didn't try to simplify the query.
stack trace
google::LogMessageFatal::~LogMessageFatal (this=0x7fed32ed0fc0, __in_chrg=) at src/logging.cc:1836 impala::Tuple::GetSlot (this=0x100d6060, offset=-1) at /home/dev/Impala/be/src/runtime/tuple.h:140 impala::HdfsParquetScanner::ScalarColumnReader::ReadValue (this=0xed76500, pool=0xc242b90, tuple=0x100d6060, conjuncts_passed=0x7fed32ed10ea) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:655 impala::HdfsParquetScanner::ScalarColumnReader::ReadValue (this=0xed76500, pool=0xc242b90, tuple=0x100d6060, conjuncts_passed=0x7fed32ed10ea) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:633 impala::HdfsParquetScanner::ReadRow (this=0xecb4b40, column_readers=..., tuple=0x100d6060, pool=0xc242b90, materialize_tuple=0x7fed32ed1240) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:1679 impala::HdfsParquetScanner::AssembleRows (this=0xecb4b40, tuple_desc=0xe12d8c0, column_readers=..., new_collection_rep_level=2, row_group_idx=-1, array_value_builder=0x7fed32ed1300) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:1618 impala::HdfsParquetScanner::CollectionColumnReader::ReadSlot (this=0xdd96ea0, slot=0xdf70028, pool=0xc242b90, conjuncts_passed=0x7fed32ed13fa) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:1388 impala::HdfsParquetScanner::CollectionColumnReader::ReadValue (this=0xdd96ea0, pool=0xc242b90, tuple=0xdf70000, conjuncts_passed=0x7fed32ed13fa) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:1360 impala::HdfsParquetScanner::ReadRow (this=0xecb4b40, column_readers=..., tuple=0xdf70000, pool=0xc242b90, materialize_tuple=0x7fed32ed14c0) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:1679 impala::HdfsParquetScanner::AssembleRows (this=0xecb4b40, tuple_desc=0xdf49680, column_readers=..., new_collection_rep_level=-1, row_group_idx=0, array_value_builder=0x0) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:1618 impala::HdfsParquetScanner::ProcessSplit (this=0xecb4b40) at /home/dev/Impala/be/src/exec/hdfs-parquet-scanner.cc:1535 impala::HdfsScanNode::ScannerThread (this=0xc588a00) at /home/dev/Impala/be/src/exec/hdfs-scan-node.cc:946 boost::_mfi::mf0::operator() (this=0x7fed32ed1e08, p=0xc588a00) at /usr/include/boost/bind/mem_fn_template.hpp:49 boost::_bi::list1 >::operator(), boost::_bi::list0> (this=0x7fed32ed1e18, f=..., a=...) at /usr/include/boost/bind/bind.hpp:253 boost::_bi::bind_t, boost::_bi::list1 > >::operator() (this=0x7fed32ed1e08) at /usr/include/boost/bind/bind_template.hpp:20 boost::detail::function::void_function_obj_invoker0, boost::_bi::list1 > >, void>::invoke (function_obj_ptr=...) at /usr/include/boost/function/function_template.hpp:153
This is from Taras's query gen setup running on docker.
To access:
$ ssh vd0206.halxg.cloudera.com $ ssh dev@192.168.123.64 # pw = cloudera $ cd Impala # proceed as usual