Search found 4 matches
- Tue Oct 18, 2016 2:47 pm
- Forum: Vertica SQL
- Topic: How to DROP more than one PARTITIONS at a time
- Replies: 3
- Views: 19158
Re: How to DROP more than one PARTITIONS at a time
Thank You Jim Knicely!
- Fri Oct 14, 2016 6:51 pm
- Forum: Vertica SQL
- Topic: How to DROP more than one PARTITIONS at a time
- Replies: 3
- Views: 19158
How to DROP more than one PARTITIONS at a time
Hi , Is there any way to DROP more than one PARTITIONS at a time. I know that we can drop the partition using DROP_PARTITION function, but we can drop one partition at a time and not able to drop more than one partition at a time. Or is there any way that we can DROP PARTITONS which is greater than ...
- Tue Mar 08, 2016 11:38 am
- Forum: General
- Topic: How to create projections by joining two flex tables
- Replies: 1
- Views: 5681
Re: How to create projections by joining two flex tables
Hi,
As per the question from your subject, we can't create Pre Join projection on flex tables , instead you can create View by joining two flex tables.
Or
You can create projections on individual flex table and create a View by joining two Projections.
-Sasi
As per the question from your subject, we can't create Pre Join projection on flex tables , instead you can create View by joining two flex tables.
Or
You can create projections on individual flex table and create a View by joining two Projections.
-Sasi
- Wed Feb 20, 2013 11:11 am
- Forum: New to Vertica
- Topic: Informatica and Vertica Connection Error
- Replies: 1
- Views: 5391
Informatica and Vertica Connection Error
Hi, Getting below error when trying to write data to Vertica database using Informatica VerticaConnection . I m able to write the data using ODBC connection, but getting error with VerticaConnection. Message Code: VERTICA_WRITER_1762 Message: [ERROR] Vertica client error: 28000:1:210:FATAL: No Verti...