Hey, thanks, Jim! That's awesome

Hello, I'm converting a bunch of Oracle SQL which uses a function called remainder(). Is there something similar in Vertica? If I have to write my own do you think I can use the mod function? I'm worried by this statement in the Oracle doc: The MOD function is similar to REMAINDER except that it use...

Thanks for you reply, sKwa. I'll try this out.

hello,

I use the \c (connect) command in vsql to connect as a different user. I can only pass it the database name and user name. Is it possible to add the password to the command so that I don't have to type it when asked?

That's pretty cool! Jim, how do you save a file in Notepad as UTF8?

Hello #me_theonlyone, I had a problem like yours in the past (at least I think it was similar :| ). Can you run a select statement against the view without error? I wonder if somehow the view definition is different on your nodes? You can use this query to get the view definition. Is it the same on ...

I second that! Great post!