Search found 15 matches

by Benjamin_e
Thu May 07, 2015 7:04 pm
Forum: General
Topic: Future of Vertica?
Replies: 6
Views: 3028

Re: Future of Vertica?

I Agree with norbertk, I'm working with few more OLAPs and they are far less better then the vertica solution. but still all depends on what is your company needs.
by Benjamin_e
Thu May 07, 2015 7:02 pm
Forum: Tableau
Topic: Vertica-Tableau error Multiple commands cannot be active
Replies: 1
Views: 10385

Re: Vertica-Tableau error Multiple commands cannot be active

Getting the same issue here in other project I'm doing but still it's a web-gui interface. :/ any solution?
by Benjamin_e
Fri Mar 06, 2015 8:18 pm
Forum: Vertica Error Codes
Topic: Frustrating issue (DB Users issue)
Replies: 1
Views: 9746

Frustrating issue (DB Users issue)

Hey all and happy purim :) I have a VERTICA database installed on my machine, well all is working like a Swiss clock except 1 thing. My UID called bennydb. when i want to login into the database i do the follow: su - bennydb pwd line. then just vsql & password so all-right till here. now if I logged...
by Benjamin_e
Mon Dec 01, 2014 4:04 pm
Forum: Vertica Data Load
Topic: Copy Rejected Data
Replies: 17
Views: 7376

Re: Copy Rejected Data

In order toadd rejections and exceptions you must specified directories that already exsits . The copy not create the folders for you.. for bulk upload.
by Benjamin_e
Wed Nov 26, 2014 7:06 am
Forum: Vertica Data Load
Topic: 2.2 GB of inserts.sql How to insert them.
Replies: 3
Views: 1968

Re: 2.2 GB of inserts.sql How to insert them.

After review the docs a out transfering I Modify it. the script has 10m inserta. Its planty even to split them. I manipulate the file to cs file delimited by ',' now i will use the opy command to move it.


Thank you.
by Benjamin_e
Tue Nov 25, 2014 11:46 pm
Forum: Vertica Data Load
Topic: 2.2 GB of inserts.sql How to insert them.
Replies: 3
Views: 1968

2.2 GB of inserts.sql How to insert them.

Hey, I have 2.2GB sql file with planty of inserts.
How do I Move it into the table?
When i try \i x.sql i get the message that said the file is too large.
by Benjamin_e
Mon Nov 24, 2014 9:43 am
Forum: Vertica Data Load
Topic: How to ignore '\N' in some fields from csv file?
Replies: 3
Views: 2144

Re: How to ignore '\N' in some fields from csv file?

Hey norbertk!
Thank you for you great help! ...
Sharing info is awesome .. consider it next time.

Here is the solution:

copy xxx from '/tmp/data.csv' direct delimiter ',' null as '\N' abort on error;

Go to advanced search