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...

Hi,
Is there a way to backup a Vertica database and restore it in SQL Server ? Or is there a way I can access a Vertica database from SQLServer?

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 = ...

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?