[GitHub] [incubator-doris] chaoyli edited a comment on issue #4427: Rollup SQL in TPCDS encounter the wrong answer.

[GitBox <gi...@apache.org>]

chaoyli edited a comment on issue #4427:
URL: https://github.com/apache/incubator-doris/issues/4427#issuecomment-678609293


   You can reproduce the bug using TPCDS(v2.13) qualification test.
   ```
   This document is for qualification test.
   It's different with performance test.
   
   1. Generate query for qualification.
      The query_templates for qualification should be
      modified by Appendix B.
      I have modified it already, you can replace it.
   
   dsqgen -DIRECTORY ../query_templates
     -INPUT ../query_templates/templates.lst
     -VERBOSE Y -QUALIFY Y
     -SCALE 1GB
     -DIALECT ansi
     -OUTPUT_DIR /home/disk1/chaoyli/tpcds
   
   2. Generate data with 10 parallelism degree
   for((i=1;i<=10;i++))
   do
       ./dsdgen -SCALE 1G -PARALLEL 10 -CHILD $i -TERMINATE N
   done
   
   3. Customer table ISO/IEC 8859-1 encoding, doris not support this encoding,
      should convert it to UTF-8
      iconv -f ascii -t utf-8 "$file" -o "${file%.txt}.utf8.txt"
   
   4. Create table using DDL in create_table.sql
   
   5. Load data into database using load.sh
   
   6. Qualify the results with answer_sets.
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org