Number of rows returned in Vertica

[mavericky10]

Hi,
I am joining 3 tables where 1 table has more than 1 million records and rest two have more than 100000 records. The result does not display, Vertica gets hanged. Can anyone let me know what is the maximum number of records that can be displayed by a sql query in Vertica?

[JimKnicely]

Hi,

Welcome to http://vertica-forums.com!

Which version of Vertica are you running? Can you post the query and explain plan for it?

[mavericky10]

version 2.3.1


select m.MEMID, m.YR, m.MTH, m.REFDATE, m.MM, c.PROCDRUGDESC, c.SERVICEDATE, c.CLMTYPE, m.ELIGFROM, m.ELIGTO, e.TOTPAIDAMT,e.MEDPAIDAMT, e.RXPAIDAMT
from s0971001_B.co_mmbymempermonth m join s0971001_B.co_memexpensesbymth e
on m.MEMID = e.MEMID
join s0971001_B.co_claims c
on m.MEMID = c.MEMID

[NorbertKrupa]

Can you please confirm your Vertica version? The one you provided doesn't sound correct. The current version is 7.1.1.

Where are you running this query? A client tool (i.e. DBVisualizer), through an application, or through vsql?

[id10t]

Hi!

[DELETED]

[mavericky10]

Hi,
norbertk and id10t,
I am using vertica version - 6.1.3.
I am querying in DBeaver version - 2.3.1. I am querying in its sql editor. So DBeaver gets hanged or very slow when I join with my tables which have large number of records.

- Is there a way I can get my results in DBeaver no matter however large they maybe.
- Can I apply indexing to the tables of vertica database in DBeaver?

[id10t]

Hi!

[DELETED]