I need to reset the password of a user in vertica. What is the sql i will use to reset the password.

Can we use case statement on boolean datatype??

For e.g

case when COALESCE(test.Flag,'T') like 't%' or '%T%' then 1 else 0 end ;

here flag is a column in test table with boolean datatype.
I was trying to this in my etl and I was getting error.

Thanks;

How do I check that how is the user account set up?? Also what all permission and access a particular user have??

How o I check if rebalancing is going on the vertica cluster?? or which table rebalancing is going on??

I want to export the output of the ddl of a table to a file in vertica using export_object. How do I do that?

I used the alter table alter column command given by you:- ALTER TABLE t ALTER COLUMN c SET DATA TYPE VARCHAR(1000); But it is giving me error. Below is the error:- '[Vertica][VerticaDSII] (20) An error occurred during query execution: ERROR: syntax error at or near "DATA" at character 93' The prese...

I need to increase the size of the column from varchar(255) to varchar(1000).

What command I will use for that??