Search found 12 matches

by vicky_tsc
Sun Feb 23, 2014 2:42 pm
Forum: Vertica SQL
Topic: Handle/store pdf and text file in Vertica
Replies: 1
Views: 5068

Handle/store pdf and text file in Vertica

How to handle/store pdf and text file in Vertica
by vicky_tsc
Tue Sep 24, 2013 6:44 am
Forum: Vertica SQL
Topic: How to delete duplicate rows
Replies: 5
Views: 19733

Re: How to delete duplicate rows

This is small table and the epoch can be used, but if the table is huge and has many duplicates in the table.then how to handle it.
by vicky_tsc
Mon Sep 23, 2013 9:24 am
Forum: Vertica SQL
Topic: How to delete duplicate rows
Replies: 5
Views: 19733

Re: How to delete duplicate rows

Thank you nnaani. Is there any way without creating temp table?. I want by using queries as we use in oracle and sql.
by vicky_tsc
Mon Sep 23, 2013 6:32 am
Forum: Vertica SQL
Topic: How to delete duplicate rows
Replies: 5
Views: 19733

How to delete duplicate rows

How to delete the duplicate rows from he following table, id | name | sal | location ----+------------+-------+---------- 1 | Tom | 50000 | NJ 1 | Tom | 50000 | NJ 2 | Jerry | 40000 | NJ 2 | jerry | 40000 | NJ 3 | Tim | 40000 | NJ 4 | Jim | 20000 |NJ I tried with following Query, DELETE FROM syn.sal...
by vicky_tsc
Sat Sep 14, 2013 5:39 am
Forum: Vertica Management Console
Topic: Configuration Failed: User already Created
Replies: 2
Views: 14836

Re: Configuration Failed: User already Created

We have created the user with different name. Then also it is showing the same error.
by vicky_tsc
Thu Sep 05, 2013 6:57 am
Forum: Vertica Management Console
Topic: Configuration Failed: User already Created
Replies: 2
Views: 14836

Configuration Failed: User already Created

i have installed Management console. when enter the host and configure, it is showing error at last saying "Configuration Failed: User already Created, Cannot create another one"
by vicky_tsc
Sat Jun 29, 2013 4:32 pm
Forum: Vertica Installation
Topic: Passwordless SSH access to other hosts (FAILED)
Replies: 7
Views: 16504

Re: Passwordless SSH access to other hosts (FAILED)

Thank so much it is working

Go to advanced search