You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
"SELECT (CASE (<column>) WHEN <number> THEN <number> END) FROM <table>" brings different results, when using CPU and GPU.
What you expected to happen:
It is the same result, when using CPU and GPU.
Minimal Complete Verifiable Example:
importpandasaspdimportdask.dataframeasddfromdask_sqlimportContextc=Context()
df0=pd.DataFrame({
'c0': [0.898116830962538],
})
t0=dd.from_pandas(df0, npartitions=1)
c.create_table('t0', t0, gpu=False)
c.create_table('t0_gpu', t0, gpu=True)
print('CPU Result:')
result1=c.sql("SELECT (CASE (t0.c0) WHEN 1 THEN 1 END) FROM t0").compute()
print(result1)
print('GPU Result:')
result2=c.sql("SELECT (CASE (t0_gpu.c0) WHEN 1 THEN 1 END) FROM t0_gpu").compute()
print(result2)
Result:
INFO:numba.cuda.cudadrv.driver:init
CPU Result:
CASE t0.c0 WHEN Int64(1) THEN Int64(1) END
0 NaN
GPU Result:
CASE t0_gpu.c0 WHEN Int64(1) THEN Int64(1) END
0 <NA>
INFO:numba.cuda.cudadrv.driver:add pending dealloc: module_unload ? bytes
qwebug
changed the title
[BUG][Logic Bug] "SELECT (CASE (<column>) WHEN <number> THEN <number> END) FROM <table>" brings Error
[BUG][GPU Logic Bug] "SELECT (CASE (<column>) WHEN <number> THEN <number> END) FROM <table>" brings Error
Jan 22, 2024
What happened:
"SELECT (CASE (<column>) WHEN <number> THEN <number> END) FROM <table>" brings different results, when using CPU and GPU.
What you expected to happen:
It is the same result, when using CPU and GPU.
Minimal Complete Verifiable Example:
Result:
Anything else we need to know?:
Environment:
The text was updated successfully, but these errors were encountered: