Search found 11 matches

by sdorich
Thu Feb 13, 2014 2:08 pm
Forum: General
Topic: Best practice for external database transfer to Vertica
Replies: 0
Views: 3872

Best practice for external database transfer to Vertica

Hi, I know of a few ways to transfer an external db to Vertica however, I wanted to post this and hope I can get lots of replies. In your opinion, what is the best practice for transferring an external db over to Vertica. This external db could be an Oracle db, MySQL, whatever; I just want opinions ...
by sdorich
Thu Jan 09, 2014 8:33 pm
Forum: Vertica Tips, Lessons and Examples
Topic: Export query result from Vertica to R
Replies: 0
Views: 13407

Export query result from Vertica to R

Is there a way to export an a query result I produced in Vertica to R. I've been playing around with my data in R already using the RODBC connector however I got a query result using a Vertica-specific function and I'd like to export it to R so I can do a further analysis.
by sdorich
Thu Jan 09, 2014 3:56 pm
Forum: Vertica Analytics
Topic: Export analytic query result from vsql to R
Replies: 0
Views: 12966

Export analytic query result from vsql to R

Is there a way to export an a query result I produced in Vertica to R. I've been playing around with my data in R already using the RODBC connector however I got a query result using a Vertica-specific function and I'd like to export it to R so I can do a further analysis.

Thanks in advance.
by sdorich
Fri Dec 27, 2013 10:23 pm
Forum: Vertica Management Console
Topic: Issue while creating new user in MC (Vertica 7)
Replies: 0
Views: 12052

Issue while creating new user in MC (Vertica 7)

I created a user (with IT privileges) in Vertica 7's MC and doing so caused me (dbadmin) to loose my admin privileges! I actually had to install the MC on another node to get my privileges back! Why would this happen?? The MC still illustrated that dbadmin (which I was logged in as) had super privil...
by sdorich
Mon Dec 23, 2013 8:31 pm
Forum: Vertica Management Console
Topic: MC warning about NTP
Replies: 1
Views: 14683

Re: MC warning about NTP

Figured out the issue - my admintools.conf file wasn't configured correctly for some reason (one of the ip addresses for a node in my cluster was incorrect). This can be fixed by editing the following file:

vi /opt/vertica/config/admintools.conf
by sdorich
Mon Dec 23, 2013 5:07 pm
Forum: Vertica Management Console
Topic: MC warning about NTP
Replies: 1
Views: 14683

MC warning about NTP

Hi, I have succeffully installed a 3-node Vertica cluster. I wanted to use the Management Console for monitoring the cluster before creating my Vertica database and ran into an error. The message says it's a warning but it's preventing me from doing anything in the MC. I've gone through all of the p...
by sdorich
Thu Dec 12, 2013 5:36 pm
Forum: Vertica Upgrade
Topic: Upgrade from Vertica 6.1 to Vertica 7.0
Replies: 10
Views: 38768

Re: Upgrade from Vertica 6.1 to Vertica 7.0

Method 2 in http://www.thegeekstuff.com/2010/08/how ... wap-space/ works! I guess swap space is at the OS level implying that Vertica just "asks" OS "how much swap space is available on this system. To install Vertica, as long as this is greater than or equal to 2.00 GB, all is good!

Go to advanced search