blazingdb / blazingsql-testing-files Goto Github PK

queryId = "TEST_06"
query = """select SUM(COALESCE(n2.n_nationkey, 100)),
        COUNT(DISTINCT(COALESCE(n1.n_nationkey,32))),
        n2.n_regionkey as n1key from nation as n1
        full outer join nation as n2
        on n1.n_nationkey = n2.n_nationkey + 6
        GROUP BY n2.n_regionkey"""

queryId = 'TEST_09'
query = """select SUM(COALESCE(n2.n_nationkey, 100)),
      COUNT(DISTINCT(COALESCE(n1.n_nationkey,32))),
      COALESCE(n2.n_regionkey, 100) as n1key from nation as n1
      full outer join nation as n2
      on n1.n_nationkey = n2.n_nationkey + 6
      GROUP BY COALESCE(n2.n_regionkey, 100)"""

ERROR: Different values

==============================
Coalesce
==============================
select SUM(COALESCE(n2.n_nationkey, 100)),
                    COUNT(DISTINCT(COALESCE(n1.n_nationkey,32))),
                    n2.n_regionkey as n1key from nation as n1
                    full outer join nation as n2
                    on n1.n_nationkey = n2.n_nationkey + 6
                    GROUP BY n2.n_regionkey

=============== New query: TEST_06 - parquet =================
                           #BLZ:                                                                                                                   
   EXPR$0  EXPR$1  n1key   
0    47.0     5.0    1.0
1    50.0     5.0    0.0
1    58.0     5.0    4.0
2    68.0     5.0    2.0
0    77.0     4.0    3.0
3   600.0     6.0    NaN
#DRILL:
   EXPR$0  EXPR$1  n1key
1    47.0     5.0    1.0
0    50.0     5.0    0.0
2    58.0     5.0    4.0
4    68.0     5.0    2.0
3    77.0     3.0    3.0
5   600.0     6.0    NaN
TEST_06 Test Coalesce - parquet
#QUERY:
select SUM(COALESCE(n2.n_nationkey, 100)),
                    COUNT(DISTINCT(COALESCE(n1.n_nationkey,32))),
                    n2.n_regionkey as n1key from nation as n1
                    full outer join nation as n2
                    on n1.n_nationkey = n2.n_nationkey + 6
                    GROUP BY n2.n_regionkey
RESULT:
ERROR:
Different values
Fail
TOTAL TIME: 
541.649341583252
CRASHED NODES: 
TOTAL NODES: 
===================================================
select SUM(COALESCE(n2.n_nationkey, 100)),
                  COUNT(DISTINCT(COALESCE(n1.n_nationkey,32))),
                  COALESCE(n2.n_regionkey, 100) as n1key from nation as n1
                  full outer join nation as n2
                  on n1.n_nationkey = n2.n_nationkey + 6
                  GROUP BY COALESCE(n2.n_regionkey, 100)

=============== New query: TEST_09 - parquet =================
                           #BLZ:                                                                                                                   
   EXPR$0  EXPR$1  n1key   
0    47.0     5.0    1.0
1    50.0     5.0    0.0
0    58.0     5.0    4.0
2    68.0     5.0    2.0
1    77.0     4.0    3.0
2   600.0     6.0  100.0
#DRILL:
   EXPR$0  EXPR$1  n1key
1    47.0     5.0    1.0
0    50.0     5.0    0.0
2    58.0     5.0    4.0
4    68.0     5.0    2.0
3    77.0     3.0    3.0
5   600.0     6.0  100.0
TEST_09 Test Coalesce - parquet
#QUERY:
select SUM(COALESCE(n2.n_nationkey, 100)),
                  COUNT(DISTINCT(COALESCE(n1.n_nationkey,32))),
                  COALESCE(n2.n_regionkey, 100) as n1key from nation as n1
                  full outer join nation as n2
                  on n1.n_nationkey = n2.n_nationkey + 6
                  GROUP BY COALESCE(n2.n_regionkey, 100)
RESULT:
ERROR:
Different values
Fail
TOTAL TIME: 
415.5755043029785
CRASHED NODES: 
TOTAL NODES: 
===================================================