Search found 1825 matches
- Wed Feb 29, 2012 1:41 pm
- Forum: Vertica Community Edition
- Topic: Community Edition release date is right around the corner!
- Replies: 5
- Views: 51824
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...
- Tue Feb 28, 2012 10:55 pm
- Forum: New to Vertica
- Topic: Why aren't Primary Keys Enforced?
- Replies: 5
- Views: 26698
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...
- Tue Feb 28, 2012 4:39 pm
- Forum: ODBC
- Topic: Set Default Time Zone for ODBC
- Replies: 1
- Views: 9172
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...
- Sat Feb 25, 2012 3:44 am
- Forum: New to Vertica
- Topic: Evaluating Vertica
- Replies: 1
- Views: 5290
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...
- 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: 17595
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...
- Fri Feb 24, 2012 10:02 pm
- Forum: Vertica Database Development
- Topic: View Explain Plan
- Replies: 7
- Views: 25220
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 -------------------------------------------------------------------------------------...
- Fri Feb 24, 2012 7:55 pm
- Forum: Vertica Database Administration
- Topic: Kick a user off of Vertica?
- Replies: 1
- Views: 8133
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...