search

antonmks / Alenka

GPU database engine
Other
1.17k stars 120 forks source link

DISTINCT on int #46

Closed wanahmadzainie closed 10 years ago

wanahmadzainie commented 10 years ago

Hi.

I try to run Alenka with DISTINCT int, but failed.

Thank you.

File q2-distinct.sql

P := LOAD 'part' BINARY AS (p_partkey{1}:int, p_mfgr{3}:varchar(25), p_type{5}:varchar(25), p_size{6}:int);
Q := SELECT DISTINCT p_size AS mypsize FROM P; 
STORE Q INTO 'mytest6distinct.txt' USING ('|');
$ LD_LIBRARY_PATH=/workspace/alenka-devel/alenka-master/cudpp_src_2.0/lib /workspace/alenka-devel/alenka-master/alenka q2-distinct.sql 
Tesla C2075 : 1147.000 Mhz   (Ordinal 0)
14 SMs enabled. Compute Capability sm_20
FreeMem:   5305MB   TotalMem:   5375MB.
Mem Clock: 1566.000 Mhz x 384 bits   (150.336 GB/s)
ECC Enabled

Process count = 6200000 
BINARY LOAD: P part 
Reading 1000000 records
opening part.sort
SELECT Q P 5563211776
terminate called after throwing an instance of 'thrust::system::system_error'
  what():  invalid argument
Aborted 0 select mem 5546958848
antonmks commented 10 years ago

Alenka does not support distinct for now.