Search found 732 matches

by id10t
Sat Apr 21, 2012 11:23 pm
Forum: Vertica Analytics
Topic: RANK and DENSE_RANK
Replies: 1
Views: 20347

Re: RANK and DENSE_RANK

If two rows receive the same rank DENSE_RANK leaves no gaps in the ranking sequence, while RANK do. The best way to show it - example, I will skip PARTITION BY for simplicity. Table: CREATE TABLE Scores ( "name" varchar(80), scores int ); Data: select * from scores order by scores desc; name | score...
by id10t
Sat Apr 21, 2012 10:29 pm
Forum: New to Vertica
Topic: Add column to table
Replies: 8
Views: 24033

Re: Add column to table

fsalvelt wrote:Why do you think that a DROP and ADD option isn't available out of the box?
As I know Vertica team already works on it and... who knows :?: may be it will be available in a next update or version.
by id10t
Sat Apr 21, 2012 10:01 pm
Forum: New to Vertica Database Administration
Topic: Change Database Owner
Replies: 4
Views: 11752

Re: Change Database Owner

Hi!

[DELETED]
by id10t
Sat Apr 21, 2012 8:46 pm
Forum: Vertica Backup & Recovery
Topic: Backup and Restore for tables
Replies: 7
Views: 20709

Re: Backup and Restore for tables

Hi!

[DELETED]

Go to advanced search