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

Joins fail silently on 10 GB dataset #50

Closed
Randolph42 opened this issue Nov 26, 2013 · 0 comments
Closed

Joins fail silently on 10 GB dataset #50

Randolph42 opened this issue Nov 26, 2013 · 0 comments

Comments

@Randolph42
Copy link
Contributor

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

@antonmks antonmks closed this as completed Jan 9, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants