BlazingDB / blazingsql

BlazingSQL is a lightweight, GPU accelerated, SQL engine for Python. Built on RAPIDS cuDF.
https://blazingsql.com
Apache License 2.0
1.93k stars 183 forks source link

[BUG] e2e crash running concatSuite #1583

Closed gcca closed 3 years ago

gcca commented 3 years ago

When the e2e concatSuite runs we obtain the following error message:


===================================================
==>> Run query for test case concatSuite
PLAN:
LogicalProject(c_name=[$4], o_orderkey=[$0], o_orderstatus=[$2])
  PartwiseJoin(condition=[=($1, $3)], joinType=[inner])
    BindableTableScan(table=[[main, orders]], projects=[[0, 1, 2]], aliases=[[o_orderkey, o_custkey, o_orderstatus]])
    BindableTableScan(table=[[main, customer]], filters=[[LIKE(CONCAT('Customer#000000', CAST($0):VARCHAR), 'Customer#0000001')]], projects=[[0, 1]], aliases=[[c_custkey, c_name]])

select c.c_name, o.o_orderkey, o.o_orderstatus
            from orders o
            inner join customer c on o.o_custkey = c.c_custkey
            where CONCAT('Customer#000000', c.c_custkey) like
            'Customer#0000001'

=============== New query: TEST_13 - orc (concatSuite)=================
Steps Complete 0/4|       [20:41:27.258] [error] |||ERROR in kernel::process trying to do do_process. Kernel name is: BindableTableScan Kernel id is: 3|||||                                                    |  0% (00:00 elapsed)
[20:41:27.258] [error] |||ERROR in graph::execute. What: Ral failure at: /blazingsql/sqp/blazingsql-pub/engine/src/execution_kernels/LogicalFilter.cpp:49: Expression does not evaluate to a boolean mask|||||
[20:41:27.265] [error] |||ERROR in graph::execute. What: Ral failure at: /blazingsql/sqp/blazingsql-pub/engine/src/execution_kernels/BatchJoinProcessing.cpp:292: In PartwiseJoin: The right input cache data cannot be null|||||
[20:41:27.265] [error] |||ERROR in graph::execute. What: Ral failure at: /blazingsql/sqp/blazingsql-pub/engine/src/execution_kernels/BatchProcessing.cpp:392: ERROR: Projection::run() first input CacheData was nullptr|||||
Steps Complete 4/4|█████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████|100% (00:00 elapsed)
Total Batches Processed: 2
[20:41:27.272] [error] 1877255986|||In get_execute_graph_results. What: Ral failure at: /blazingsql/sqp/blazingsql-pub/engine/src/execution_kernels/LogicalFilter.cpp:49: Expression does not evaluate to a boolean mask|||||
==>> Run query for test case concatSuite
PLAN:
LogicalProject(EXPR$0=[CONCAT($2, ' - ', $4)], o_orderstatus=[$1])
  PartwiseJoin(condition=[=($0, $3)], joinType=[inner])
    LogicalProject(o_custkey=[$0], o_orderstatus=[$1], CASE=[CASE(IS NULL($2), 'V1', 'V2')])
      BindableTableScan(table=[[main, orders]], projects=[[1, 2, 0]], aliases=[[o_custkey, o_orderstatus, CASE]])
    BindableTableScan(table=[[main, customer]], filters=[[<($0, 10)]], projects=[[0, 1]], aliases=[[c_custkey, c_name]])

select CONCAT(case when o.o_orderkey is null then 'V1'  else 'V2' end , ' - ', c.c_name),
                  o.o_orderstatus
              from orders o
              inner join customer c on o.o_custkey = c.c_custkey
              where c.c_custkey < 10

=============== New query: TEST_14 - orc (concatSuite)=================
[20:41:27.284] [error] |||ERROR in kernel::process trying to do do_process. Kernel name is: BindableTableScan Kernel id is: 3|||||
[20:41:27.410] [error] |||ERROR in graph::execute. What: Ral failure at: /blazingsql/sqp/blazingsql-pub/engine/src/execution_kernels/LogicalFilter.cpp:49: Expression does not evaluate to a boolean mask|||||
Steps Complete 1/5|█████████████████████████████████████▊```