Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Thanks
Kiran Kumar
Kuman check Gysbert's response here: Table viewer showing negative values as number of rows
Today i learn something new , well asked !!
Thanks @sunindia
We should all thanks gwassenaar
Yes thanks gwassenaar
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
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.
Yes Marcus ,
the table contains timestamps in the dates table and my next step is making them dates only, thanks for the link.
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.