Search found 11 matches
- Thu Feb 13, 2014 2:08 pm
- Forum: General
- Topic: Best practice for external database transfer to Vertica
- Replies: 0
- Views: 3893
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 ...
- Thu Jan 09, 2014 8:33 pm
- Forum: Vertica Tips, Lessons and Examples
- Topic: Export query result from Vertica to R
- Replies: 0
- Views: 13784
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.
- Thu Jan 09, 2014 3:56 pm
- Forum: Vertica Analytics
- Topic: Export analytic query result from vsql to R
- Replies: 0
- Views: 13318
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.
Thanks in advance.
- Fri Dec 27, 2013 10:23 pm
- Forum: Vertica Management Console
- Topic: Issue while creating new user in MC (Vertica 7)
- Replies: 0
- Views: 12400
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...
- Mon Dec 23, 2013 8:31 pm
- Forum: Vertica Management Console
- Topic: MC warning about NTP
- Replies: 1
- Views: 15051
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
vi /opt/vertica/config/admintools.conf
- Mon Dec 23, 2013 5:07 pm
- Forum: Vertica Management Console
- Topic: MC warning about NTP
- Replies: 1
- Views: 15051
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...
- Thu Dec 12, 2013 5:36 pm
- Forum: Vertica Upgrade
- Topic: Upgrade from Vertica 6.1 to Vertica 7.0
- Replies: 10
- Views: 39524
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!