Search found 1825 matches

by JimKnicely
Wed Feb 29, 2012 1:41 pm
Forum: Vertica Community Edition
Topic: Community Edition release date is right around the corner!
Replies: 5
Views: 51642

Re: Community Edition release date is right around the corne

Hi! The CE edition is available, but only for a limited number of people. But according to a Vertica representative I spoke to via email, there are plans now to start giving access to the rest of the folks who had signed up for it. He said he expects everyone should hear back from Vertica soon about...
by JimKnicely
Tue Feb 28, 2012 10:55 pm
Forum: New to Vertica
Topic: Why aren't Primary Keys Enforced?
Replies: 5
Views: 26621

Re: Why aren't Primary Keys Enforced?

Hi, Constraints in Vertica are not enforced when the data is loaded. They are only enforced at the time you run a SELECT statement and join to another table. You'll have to manually check if there are any constraint violations using the ANALYZE_CONSTRAINTS function. I believe that Vertica is elimina...
by JimKnicely
Tue Feb 28, 2012 4:39 pm
Forum: ODBC
Topic: Set Default Time Zone for ODBC
Replies: 1
Views: 9141

Re: Set Default Time Zone for ODBC

Hi Jeff, You can set the timezone for a session opened by an ODBC connection via the ConnSettings parameter of the odbc.ini file. This parameter allows us to list SQL commands that will execute when the connection is made. Here we can add the SET TIMEZONE command to change the timezone! I'll run thr...
by JimKnicely
Sat Feb 25, 2012 3:44 am
Forum: New to Vertica
Topic: Evaluating Vertica
Replies: 1
Views: 5266

Re: Evaluating Vertica

Hi Piglet, I love the your login name here at vertica-forums.com ! I am sorry that no one has replied to your post. I was hoping we'd get the community together a bit more by now so that users can help me respond to these great topics. But I'm sure we'll get there! Anyway, I can let you know that we...
by JimKnicely
Fri Feb 24, 2012 10:18 pm
Forum: Microsoft SQL Server Analysis Services (SSAS)
Topic: Suggestions for how to make this work?
Replies: 1
Views: 17479

Re: Suggestions for how to make this work?

Hi, Unfortunately the ADO.NET driver isn't included in the Vertica 5.1 client drivers. But you should be able to use an OLEDB to ODBC bridge (via MSDASQL) or simply use the legacy Vertica 4.1 client drivers. We use the 4.1 drivers against a 5.0 server, and the documentation says that the 4.1 drivers...
by JimKnicely
Fri Feb 24, 2012 10:02 pm
Forum: Vertica Database Development
Topic: View Explain Plan
Replies: 7
Views: 25128

Re: View Explain Plan

Josh, Quick answer is you can use the EXPLAIN command in vsql to show the query plan. Example: dbadmin=> EXPLAIN SELECT COUNT(*) FROM athena_transaction a JOIN date_dim b ON b.date_key = a.post_date_key; QUERY PLAN -------------------------------------------------------------------------------------...
by JimKnicely
Fri Feb 24, 2012 7:55 pm
Forum: Vertica Database Administration
Topic: Kick a user off of Vertica?
Replies: 1
Views: 8111

Re: Kick a user off of Vertica?

Josh, You can use the CLOSE_SESSION function to drop a user's session. This function has one parameter: session_id So if I want to kick the cognos user off my server, first I have to find its session id from the sessions table: dbadmin=> SELECT user_name, session_id FROM sessions; user_name | sessio...

Go to advanced search