Describe:
SELECT <agg_func> FROM <table> brings different results, when using CPU-only configurations and GPU-used configurations.
SQL with CPU-only Config:
CREATE TABLE t0(c0 DOUBLE);
INSERT INTO t0(c0) VALUES('Infinity');
ALTER SESSION SET EXECUTOR_DEVICE='CPU';
SELECT SUM(CAST(t0.c0 AS INT)) FROM t0;
Result:
SQL with GPU-used Config:
ALTER SESSION SET EXECUTOR_DEVICE='GPU';
SELECT SUM(CAST(t0.c0 AS INT)) FROM t0;
Result:
Environment:
Docker Deployment
https://hub.docker.com/layers/heavyai/heavyai-ee-cuda/latest/images/sha256-5af3ad3a00cbc5ce09c299b8b81cda96521a27373dbb1e59209c02358cfd9b1f?context=explore
Docker DIGEST: sha256:5af3ad3a00cbc5ce09c299b8b81cda96521a27373dbb1e59209c02358cfd9b1f
HeavyDB Version: 7.1.0-20230821-eae9ec17da
HeavyDB license: Free Edition
Describe:
SELECT <agg_func> FROM <table> brings different results, when using CPU-only configurations and GPU-used configurations.
SQL with CPU-only Config:
Result:
EXPR$0 NULLSQL with GPU-used Config:
Result:
EXPR$0 2147483647Environment:
Docker Deployment
https://hub.docker.com/layers/heavyai/heavyai-ee-cuda/latest/images/sha256-5af3ad3a00cbc5ce09c299b8b81cda96521a27373dbb1e59209c02358cfd9b1f?context=explore
Docker DIGEST: sha256:5af3ad3a00cbc5ce09c299b8b81cda96521a27373dbb1e59209c02358cfd9b1f
HeavyDB Version: 7.1.0-20230821-eae9ec17da
HeavyDB license: Free Edition