Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2539

tuple.h:140] Check failed: offset != -1

    Details

      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
      

        Attachments

          Activity

            People

            • Assignee:
              alex.behm Alexander Behm
              Reporter:
              caseyc casey
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: