Search found 1825 matches
- Mon Feb 13, 2012 3:22 pm
- Forum: Vertica Migration
- Topic: Converting from MySQL datatype question
- Replies: 1
- Views: 19729
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...
- Mon Feb 13, 2012 2:46 pm
- Forum: Vertica Security
- Topic: AdminTools error when editing authentication method
- Replies: 1
- Views: 17647
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...
- Thu Feb 09, 2012 1:26 pm
- Forum: Vertica Community Edition
- Topic: Community Edition release date is right around the corner!
- Replies: 5
- Views: 51808
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!
- 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: 10994
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...
- Wed Feb 08, 2012 4:58 pm
- Forum: Request for New Forums Categories
- Topic: running analytics on the database
- Replies: 1
- Views: 17131
Re: running analytics on the database
Thanks! I added the "Vertica Analytics" forum under the "Using Vertica" category.
- Wed Feb 08, 2012 1:01 am
- Forum: New to Vertica
- Topic: How to drop columns from a table
- Replies: 6
- Views: 20966
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 ...
- Tue Feb 07, 2012 3:46 pm
- Forum: Vertica Community Edition
- Topic: Community Edition release date is right around the corner!
- Replies: 5
- Views: 51808
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!
I just heard that the Community Edition will be available in mid-February (2012)!!! Make sure you sign up for the beta program!
Thanks!