Search found 15 matches
- Thu May 07, 2015 7:04 pm
- Forum: General
- Topic: Future of Vertica?
- Replies: 6
- Views: 14775
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.
- Thu May 07, 2015 7:02 pm
- Forum: Tableau
- Topic: Vertica-Tableau error Multiple commands cannot be active
- Replies: 1
- Views: 23863
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?
- Fri Mar 06, 2015 8:18 pm
- Forum: Vertica Error Codes
- Topic: Frustrating issue (DB Users issue)
- Replies: 1
- Views: 36482
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...
- Mon Dec 01, 2014 4:04 pm
- Forum: Vertica Data Load
- Topic: Copy Rejected Data
- Replies: 17
- Views: 54539
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.
- 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: 17632
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.
Thank you.
- 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: 17632
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.
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.
- 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: 18429
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;
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;