Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-636

The number of TPC-H 10 query results are wrong.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Cannot Reproduce
    • None
    • None
    • None
    • None

    Description

      I testes bellowing TPC-H Q10 query(dData scale=100GB). The result of Tajo is 3,884,217 while the results of Hive is 3,884,218

      select c_custkey, c_name, sum(l_extendedprice * (1 - l_discount)) as revenue, c_acctbal, n_name, c_address, c_phone, c_comment 
      from customer  c 
      join nation n on c.c_nationkey = n.n_nationkey 
      join orders o on c.c_custkey = o.o_custkey 
           and o.o_orderdate >= '1993-10-01' and o.o_orderdate < '1994-01-01' 
      join lineitem_100 l on l.l_orderkey = o.o_orderkey and l.l_returnflag = 'R' 
      group by c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment order by revenue desc
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              hjkim Hyoungjun Kim
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: