Problem with group by with parallel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 11

Thread: Problem with group by with parallel

Threaded View

  1. #1
    Join Date
    Sep 2005
    Posts
    278

    Problem with group by Clause

    There is strange problem with group by results
    when running in parallel

    the table recs have nearly 180 million records

    insert into tab1
    select /*+parallel(a,8)*/
    transcode, filename, rectype, count(*), sum(charge), sum(units)
    from recs
    group by transcode, filename, rectype

    the above is giving some strange reults for some files

    for example the output of filename "XYZ" is
    DBFG, XYZ, 10, 2000, 3000, 10000
    DBFG, XYZ, 20, 2000, 3000, 10000
    DBFG, XYZ, 30, 2000, 3000, 10000

    when executed as

    insert into tab1
    select /*+parallel(a,8)*/
    transcode, filename, rectype, count(*), sum(charge), sum(units)
    from recs
    where recs.filename = 'XYZ'
    group by transcode, filename, rectype

    the output is

    DBFG, XYZ, 10, 3000, 6000, 12000
    DBFG, XYZ, 20, 5000, 7345, 13467
    DBFG, XYZ, 30, 2000, 3000, 10000

    this output is correct when comparing to the previous one

    I could not able to recognize the actual problem, please can someone help me
    Last edited by tabreaz; 02-08-2006 at 11:24 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width