I didn't try it but I think the topic on the link below might be helpful for you.

viewtopic.php?f=21&t=1331

As I know currently TRUNCATE TABLE operation need to be table owner or superuser.

Refer:

http://my.vertica.com/docs/7.1.x/HTML/i ... ETABLE.htm

OK, Let say you have a ETL user (ETLUSER user) and a ETL role (ETLROLE role). ETLROLE was granted to ETLUSER. Assume that a STAGING schema was created by DBADMIN. Now you already grant CREATE on STAGING schema to ETLROLE. ETLUSER should have a privilege to create objects (Table, View, etc.) on STAGI...

Hi Nandhina M, First, you need to create a role. CREATE ROLE rolename; Second, you grant privileges to the role. I think all you need is only CREATE privilege (Allows the user read access to the schema and the right to create tables and views within the schema). The object owner can DROP and TRUNCAT...

Question: If so, Like we create sequences, can we also create identity, Auto Increment Answer: Yes, you can. For each column you can choose a type of the sequence objects that you want to use. But each table can contain only one auto_increment or identity column. A table can contain both an auto_in...

Could you please capture the screen. The error doesn't make sense.

As I know @@ROWCOUNT is a Built-in System Function (Transact-SQL) of SQL Server that returns the number of rows affected by the last statement. And Vertica currently doesn't support programming language in Database like PL/SQL (Oracle) or Transact-SQL (SQL Server). So If you want to know the number ...