antonmks / Alenka

GPU database engine
Other
1.17k stars 120 forks source link

Joins fail silently on 10 GB dataset #50

Closed Randolph42 closed 10 years ago

Randolph42 commented 10 years ago

GeForce GTX 650 Ti : 1032.500 Mhz (Ordinal 0) 4 SMs enabled. Compute Capability sm_30 FreeMem: 916MB TotalMem: 1023MB. Mem Clock: 2700.000 Mhz x 128 bits (86.400 GB/s) ECC Disabled

Process count = 5000000 BINARY LOAD: L lineitem Reading 600037902 records segment sorted on 0 INLINE FILTER L BINARY LOAD: S supplier Reading 1000000 records BINARY LOAD: C customer Reading 15000000 records BINARY LOAD: N nation Reading 25 records INLINE FILTER N BINARY LOAD: N1 nation Reading 25 records INLINE FILTER N1 BINARY LOAD: O orders Reading 150000000 records JOIN SN s_nationkey n_nationkey1 900325376

join count 0 join time 0 880271360 JOIN LJ1 c_nationkey n_nationkey 900325376

join count 0 join time 0 880271360 JOIN LJ2 o_custkey c_custkey 900325376 Join result LJ : 0 JOIN LS l_suppkey s_suppkey 900325376 Join result LS : 0 SELECT T count : 0, Mem 900325376 SELECT G count : 0, Mem 900325376 STORE: GO mytest.txt | SQL scan parse worked tot disk time 0 cycle time 0.11

(Note: mytest.txt is null ) I'm on Centos 6.4 with GCC 4.8.1, Cuda 5.5