Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kkkumar82
Specialist III
Specialist III

What happens in Qlikview if a table crosses 2147483647 rows

Hi all,

Today while performing a join among two tables the result gave a bigger table with more than 2147483647 rows and the table in the table viewer showed negative number when I hovered the mouse.

I am actually trying to solve the number of rows issues but I want to how or what happens when we have that many rows.

First of all am I correct in that number(2147483647)

New Bitmap Image.bmp

Thanks

Kiran Kumar

8 Replies
sunny_talwar

Kuman check Gysbert's response here:  Table viewer showing negative values as number of rows

agni_gold
Specialist III
Specialist III

Today i learn something new , well asked !!

Thanks @sunindia

sunny_talwar

We should all thanks gwassenaar

agni_gold
Specialist III
Specialist III

Yes thanks gwassenaar

marcus_sommer

Your table is named "Dates" but I have the feeling that couldn't be only dates else timestamps and especially by such a large table should be considered to split them in dates and time, see also: The Importance Of Being Distinct.

- Marcus

ThornOfCrowns
Specialist II
Specialist II

How many rows did you have in your tables before the join? It looks like you've made a Cartesian Product and hit a stack overflow.

Not applicable

Yes Marcus ,

the table contains timestamps in the dates table and my next step is making them dates only, thanks for the link.

Not applicable

Yes James,

The resultant table which I got was a cartesian product , that table contains nearly I+ Cr rows and I have join it with a 236 rows tables after that I have to apply the conditions because there are no common columns common to them,

it was a equi join.