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
[BUG][GPU Logic Bug] "SELECT ( (CASE (CASE (<number>) WHEN <column> THEN (<number>) END ) WHEN <number> THEN (<number>) ELSE <column> END )) FROM <table>" brings Error
#1235
Open
qwebug opened this issue
Sep 20, 2023
· 0 comments
"SELECT ( (CASE (CASE (<number>) WHEN <column> THEN (<number>) END ) WHEN <number> THEN (<number>) ELSE <column> 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({
'c1': [0.6926717947094722],
'c2': [True],
})
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 (CASE (1) WHEN t0.c1 THEN (1.0) END ) WHEN 0.1 THEN (47) ELSE t0.c1 END )) FROM t0").compute()
print(result1)
print('GPU Result:')
result2=c.sql("SELECT ( (CASE (CASE (1) WHEN t0_gpu.c1 THEN (1.0) END ) WHEN 0.1 THEN (47) ELSE t0_gpu.c1 END )) FROM t0_gpu").compute()
print(result2)
Result:
INFO:numba.cuda.cudadrv.driver:init
CPU Result:
CASE CASE Int64(1) WHEN t0.c1 THEN Float64(1) END WHEN Float64(0.1) THEN Int64(47) ELSE t0.c1 END
0 0.692672
GPU Result:
CASE CASE Int64(1) WHEN t0_gpu.c1 THEN Float64(1) END WHEN Float64(0.1) THEN Int64(47) ELSE t0_gpu.c1 END
0 47.0
INFO:numba.cuda.cudadrv.driver:add pending dealloc: module_unload ? bytes
qwebug
changed the title
[BUG][Logic Bug] "SELECT ( (CASE (CASE (<number>) WHEN <column> THEN (<number>) END ) WHEN <number> THEN (<number>) ELSE <column> END )) FROM <table>" brings Error
[BUG][GPU Logic Bug] "SELECT ( (CASE (CASE (<number>) WHEN <column> THEN (<number>) END ) WHEN <number> THEN (<number>) ELSE <column> END )) FROM <table>" brings Error
Jan 22, 2024
What happened:
"SELECT ( (CASE (CASE (<number>) WHEN <column> THEN (<number>) END ) WHEN <number> THEN (<number>) ELSE <column> 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:
INFO:numba.cuda.cudadrv.driver:init CPU Result: CASE CASE Int64(1) WHEN t0.c1 THEN Float64(1) END WHEN Float64(0.1) THEN Int64(47) ELSE t0.c1 END 0 0.692672 GPU Result: CASE CASE Int64(1) WHEN t0_gpu.c1 THEN Float64(1) END WHEN Float64(0.1) THEN Int64(47) ELSE t0_gpu.c1 END 0 47.0 INFO:numba.cuda.cudadrv.driver:add pending dealloc: module_unload ? bytes
Anything else we need to know?:
Environment:
The text was updated successfully, but these errors were encountered: