Search found 12 matches
- Sun Feb 23, 2014 2:42 pm
- Forum: Vertica SQL
- Topic: Handle/store pdf and text file in Vertica
- Replies: 1
- Views: 5184
Handle/store pdf and text file in Vertica
How to handle/store pdf and text file in Vertica
- Tue Sep 24, 2013 6:44 am
- Forum: Vertica SQL
- Topic: How to delete duplicate rows
- Replies: 5
- Views: 19988
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.
- Mon Sep 23, 2013 9:24 am
- Forum: Vertica SQL
- Topic: How to delete duplicate rows
- Replies: 5
- Views: 19988
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.
- Mon Sep 23, 2013 6:32 am
- Forum: Vertica SQL
- Topic: How to delete duplicate rows
- Replies: 5
- Views: 19988
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...
- Sat Sep 14, 2013 5:39 am
- Forum: Vertica Management Console
- Topic: Configuration Failed: User already Created
- Replies: 2
- Views: 15830
Re: Configuration Failed: User already Created
We have created the user with different name. Then also it is showing the same error.
- Thu Sep 05, 2013 6:57 am
- Forum: Vertica Management Console
- Topic: Configuration Failed: User already Created
- Replies: 2
- Views: 15830
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"
- Sat Jun 29, 2013 4:32 pm
- Forum: Vertica Installation
- Topic: Passwordless SSH access to other hosts (FAILED)
- Replies: 7
- Views: 16772
Re: Passwordless SSH access to other hosts (FAILED)
Thank so much it is working