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

Crash in analytic function with non-deterministic order by

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • Impala 2.8.0
    • None
    • Backend

    Description

      I ran the query: with t1 as (select random() r from t) select r, lag(r, 1) over (order by random()) from t1 limit 5;
      and impalad crashed with a SIGFPE (FPE_INTDIV) in the following stack:

      #6  0x0000000000dc58cc in impala::Sorter::Run::Run(impala::Sorter*, impala::TupleDescriptor*, bool) ()
      #7  0x0000000000dc7e7f in impala::Sorter::Init() ()
      #8  0x0000000000ca30e5 in impala::SortNode::Prepare(impala::RuntimeState*) ()
      #9  0x0000000000dc0163 in impala::PlanFragmentExecutor::PrepareInternal(impala::QueryState*, impala::TDescriptorTable const&, impala::TPlanFragmentCtx const&, impala::TPlanFragmentInstanceCtx const&) ()
      

      It reproduces reliably. 't' here is a table with ~1.2M rows.

      Attachments

        Activity

          People

            Unassigned Unassigned
            tlipcon Todd Lipcon
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: