Search found 4 matches

by sasikari
Tue Oct 18, 2016 2:47 pm
Forum: Vertica SQL
Topic: How to DROP more than one PARTITIONS at a time
Replies: 3
Views: 1110

Re: How to DROP more than one PARTITIONS at a time

Thank You Jim Knicely!
by sasikari
Fri Oct 14, 2016 6:51 pm
Forum: Vertica SQL
Topic: How to DROP more than one PARTITIONS at a time
Replies: 3
Views: 1110

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 ...
by sasikari
Tue Mar 08, 2016 11:38 am
Forum: General
Topic: How to create projections by joining two flex tables
Replies: 1
Views: 1021

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
by sasikari
Wed Feb 20, 2013 11:11 am
Forum: New to Vertica
Topic: Informatica and Vertica Connection Error
Replies: 1
Views: 1070

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

Go to advanced search