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

Query completed without error but incorrectly returned no results

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • Impala 2.3.0
    • None
    • None
    • impalad version 2.3.0-cdh5-INTERNAL DEBUG (build acd68caf7dd931fbc3edf8965298b57297a82aa0)
      Built on Thu, 10 Sep 2015 22:51:08 PST

    Description

      This has come up several times in the stress test. I'm still investigating but I'm pretty sure this is a bug. Some times a query will complete successfully with either (1) no results or (2) an incorrect result set. I suspect these may be the same issue where a partial result set is returned and #1 is a special case of #2.

      From the profile archive

      Query State FINISHED
      Query Status OK
      
      Operator              #Hosts   Avg Time   Max Time  #Rows  Est. #Rows   Peak Mem  Est. Peak Mem  Detail
      --------------------------------------------------------------------------------------------------------------------------------
      17:MERGING-EXCHANGE        1   12.372ms   12.372ms      0         100          0        -1.00 B  UNPARTITIONED
      11:TOP-N                   4    65.30ms  102.316ms      0         100   52.00 KB       15.32 KB
      10:SELECT                  4   168.58us  183.383us      0     171.11K   20.00 KB              0
      09:ANALYTIC                4  129.650ms  166.328ms      0       1.71M    8.02 MB              0
      08:SORT                    4  319.956us  355.990us      0       1.71M   24.01 MB       64.00 MB
      16:AGGREGATE               4    9s951ms   13s251ms      0       1.71M    3.26 MB      122.01 MB  FINALIZE
      15:EXCHANGE                4   17.852us   18.716us      0       1.71M          0              0  HASH(i_category,i_brand,s_s...
      07:AGGREGATE               4   14s260ms   17s713ms      0       1.71M   16.30 MB      252.88 MB
      06:HASH JOIN               4  795.488ms    1s016ms      0       1.71M   13.02 MB        1.76 KB  INNER JOIN, BROADCAST
      |--14:EXCHANGE             4   19.917us   21.137us      0          32          0              0  BROADCAST
      |  03:SCAN HDFS            1   44s726ms   44s726ms      0          32   86.00 KB       48.00 MB  tpcds_3_decimal_parquet.store
      05:HASH JOIN               4  847.780ms   942.83ms  2.85K       1.66M   15.01 MB        71.00 B  INNER JOIN, BROADCAST
      |--13:EXCHANGE             4  125.696us  127.781us    366           4          0              0  BROADCAST
      |  02:SCAN HDFS            1   47s818ms   47s818ms    366           4    1.80 MB       48.00 MB  tpcds_3_decimal_parquet.dat...
      04:HASH JOIN               4    1s015ms    2s301ms  2.85K       1.66M    3.11 MB       54.09 KB  INNER JOIN, BROADCAST
      |--12:EXCHANGE             4    2.817ms    9.445ms  2.67K         587          0              0  BROADCAST
      |  00:SCAN HDFS            1   27s847ms   27s847ms  2.67K         587    1.02 MB       64.00 MB  tpcds_3_decimal_parquet.item
      01:SCAN HDFS               4       3m5s         6m  8.17K       1.66M  450.28 KB       48.00 MB  tpcds_3_decimal_parquet.sto...
      

      The query should return 100 rows but returned none.

      The query id is 7046b44020e587a1:8075419ca9e03797. A log grep and serialized profile are attached. The full log file was too big to upload (17mb compressed). The cluster is still up. The coordinator is impala-stress-4.vpc.cloudera.com.

      Attachments

        1. tpch_query15.sql.1.out
          108 kB
          Mostafa Mokhtar
        2. tpch_query15.sql.2.out
          108 kB
          Mostafa Mokhtar
        3. diff_results.txt
          13 kB
          casey
        4. log_grep.txt
          8 kB
          casey
        5. query_profile_archive
          18 kB
          casey

        Issue Links

          Activity

            People

              skye Skye Wanderman-Milne
              caseyc casey
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: