Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] [Logic Bug] "SELECT <column> FROM <table>" by JDBC brings Error #1237

Open
qwebug opened this issue Sep 20, 2023 · 0 comments
Open

[BUG] [Logic Bug] "SELECT <column> FROM <table>" by JDBC brings Error #1237

qwebug opened this issue Sep 20, 2023 · 0 comments
Labels
bug Something isn't working needs triage Awaiting triage by a dask-sql maintainer

Comments

@qwebug
Copy link

qwebug commented Sep 20, 2023

What happened:

Using "SELECT <column> FROM <table>" by JDBC brings different results, when using CPU and GPU.

However, it is the same result, when using this sql by python.

What you expected to happen:

It is the same result, when using CPU and GPU.

Minimal Complete Verifiable Example:

Query by JDBC:

DROP SCHEMA IF EXISTS database0;
CREATE SCHEMA IF NOT EXISTS database0;
USE SCHEMA database0;
CREATE TABLE t0 WITH ( location = '/tmp/t0.csv', format = 'csv', gpu = FALSE );
CREATE TABLE t0_gpu WITH ( location = '/tmp/t0.csv', format = 'csv', gpu = TRUE );

t0.csv:

c0,c1,c2
',?', 'E', True

SQL:

SELECT t0.c2 FROM t0;

Result:

  c2   
-------
  True 
(1 row)

SQL:

SELECT t0_gpu.c2 FROM t0_gpu;

Result:

  c2  
------
  'E' 
(1 row)

Query by python:

import pandas as pd
import dask.dataframe as dd
from dask_sql import Context

c = Context()

df = pd.DataFrame({
    'c0': [',?'],
    'c1': ['E'],
    'c2': [True],
})
t0 = dd.from_pandas(df, npartitions=1)

c.create_table('t0', t0, gpu=False)
c.create_table('t0_gpu', t0, gpu=True)

print('CPU Result:')
result1= c.sql("SELECT t0.c2 FROM t0").compute()
print(result1)

print('GPU Result:')
result2= c.sql("SELECT t0_gpu.c2 FROM t0_gpu").compute()
print(result2)

Result:

INFO:numba.cuda.cudadrv.driver:init
CPU Result:
     c2
0  True
GPU Result:
     c2
0  True

Anything else we need to know?:

Environment:

@qwebug qwebug added bug Something isn't working needs triage Awaiting triage by a dask-sql maintainer labels Sep 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working needs triage Awaiting triage by a dask-sql maintainer
Projects
None yet
Development

No branches or pull requests

1 participant