Search found 1825 matches

by JimKnicely
Mon Feb 13, 2012 3:22 pm
Forum: Vertica Migration
Topic: Converting from MySQL datatype question
Replies: 1
Views: 19626

Re: Converting from MySQL datatype question

In the Vertica database INT , INTEGER , INT8 , BIGINT , SMALLINT and TINYINT are all synonyms for the same signed 64-bit integer data type. You don't have to worry about specifying a size because Vertica will automatically compress the data to conserve disk space when you don't need the full 64 bits...
by JimKnicely
Mon Feb 13, 2012 2:46 pm
Forum: Vertica Security
Topic: AdminTools error when editing authentication method
Replies: 1
Views: 17532

Re: AdminTools error when editing authentication method

Did you set up your EDITOR environment variable? If you want to use the vi editor then you can find out where the vi executable is located with the "which vi" command: Example: bash-3.2$ which vi /bin/vi Then export that value to the EDITOR variable: bash-3.2$ export EDITOR=/bin/vi You can add the e...
by JimKnicely
Thu Feb 09, 2012 1:26 pm
Forum: Vertica Community Edition
Topic: Community Edition release date is right around the corner!
Replies: 5
Views: 51648

Re: Community Edition release date is right around the corne

It's free up to 1 TB of storage. I'm not sure what other restrictions Vertica will impose. We'll have to wait until next week to find out!
by JimKnicely
Thu Feb 09, 2012 1:21 pm
Forum: New to Vertica Database Development
Topic: How can I find the last day of last month in SQL?
Replies: 2
Views: 10928

Re: How can I find the last day of last month in SQL?

Although there isn't a built in function for that, it's easy enough to get the result you need via a combination of built in functions. For instance in vSQL: vertica01=> SELECT CURRENT_DATE() "TODAY", DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -1))) "LAST DAY OF LAST MONTH"; TODAY | LAST DAY OF LAST MONT...
by JimKnicely
Wed Feb 08, 2012 4:58 pm
Forum: Request for New Forums Categories
Topic: running analytics on the database
Replies: 1
Views: 17014

Re: running analytics on the database

Thanks! I added the "Vertica Analytics" forum under the "Using Vertica" category.
by JimKnicely
Wed Feb 08, 2012 1:01 am
Forum: New to Vertica
Topic: How to drop columns from a table
Replies: 6
Views: 20895

Re: How to drop columns from a table

I wanted to update this thread to let folks know that we still can't drop a column easily from a table in release 5.1. But remember, were working with data warehouses ...
by JimKnicely
Tue Feb 07, 2012 3:46 pm
Forum: Vertica Community Edition
Topic: Community Edition release date is right around the corner!
Replies: 5
Views: 51648

Community Edition release date is right around the corner!

Hi,

I just heard that the Community Edition will be available in mid-February (2012)!!! Make sure you sign up for the beta program!

Thanks!

Go to advanced search