Search found 9 matches

by greeness
Tue Aug 07, 2012 7:08 pm
Forum: Vertica Error Codes
Topic: error determining the active database
Replies: 3
Views: 18559

Re: error determining the active database

Thanks guys. After restarting spreadd, I was able to restart vertica. Thanks again.
by greeness
Tue Aug 07, 2012 12:02 am
Forum: Vertica Error Codes
Topic: error determining the active database
Replies: 3
Views: 18559

error determining the active database

I cannot run database designer, which gives me error message"spread error, restart?".

When I try to restart the vertica on Host, I get "error determining the active database, so no hosts can be restarted"

Anyone has any idea? Thanks!
by greeness
Thu Jul 26, 2012 7:03 pm
Forum: R Language Integration
Topic: Where to download the R UDx Source tarball?
Replies: 2
Views: 18389

Re: Where to download the R UDx Source tarball?

Thanks much, Jim! The second link works great!
BTW, I found this forum is much more helpful than the official one. (http://my.vertica.com/forums/)
by greeness
Thu Jul 26, 2012 12:40 am
Forum: R Language Integration
Topic: Where to download the R UDx Source tarball?
Replies: 2
Views: 18389

Where to download the R UDx Source tarball?

Per the Vertica 6's online documentation "Programmer's Guide > Developing and Using User Defined Functions > Developing a User Defined Function in R > Installing R for Vertica ", we need to download the R UDx Source tarball by going to the myVertica portal, clicking the downloads tab, and selecting ...
by greeness
Thu Jul 26, 2012 12:27 am
Forum: R Language Integration
Topic: R integration tutorial?
Replies: 3
Views: 21731

Re: R integration tutorial?

I found some brief introduction in Vertica's online documentation for version 6 under the section named "Developing a User Defined Function in R". http://my.vertica.com/docs/CE/6.0.0-1/HTML/index.htm#17794.htm The above forum does need to create an account for access though. Hope it helps for later ...
by greeness
Wed Jul 25, 2012 3:47 am
Forum: SQuirreL SQL Client
Topic: Setting up SQuirreL
Replies: 8
Views: 37757

Re: Setting up SQuirreL

This is alligator, not Kangaroo? :)
knicely87 wrote: I guess I did the same thing with the blue alligator :) It must just be cool to do that.
by greeness
Tue Jul 24, 2012 10:04 pm
Forum: R Language Integration
Topic: R integration tutorial?
Replies: 3
Views: 21731

Re: R integration tutorial?

Thanks Jim. That helps a lot! I was able to connect to vertica via odbc now. e.g., I could send queries in R and get response. >library("RODBC") > con <- odbcConnect("vertica") >sqlQuery(con, 'select count(*) from open_session_fact') count 1 87915596 However, this is not my original motivation to us...

Go to advanced search