The Vertica Database Forums

sarah

http://www.crn.com/news/applications-os ... j02?pgno=2

sarah

Julie,

Do you think it contains a hash value created with the MD5 Message-Digest Algorithm? I'm curious too.

Thanks.

sarah

Could you use the translate function when you want to display the data?

Code: Select all

dbadmin=> SELECT translate(to_char(123456.77,'R$ 999G999G999D99'), ',.', '.,');
     translate
--------------------
 R$      123.456,77
(1 row)

sarah

Thanks, guys! This now makes sense to me. Do you think just starting out I should leave the encoding to AUTO? Maybe once I get to now the different encoding methods a little better I can change the tables. Hmm. I guess that's another question. Can I change the column encoding method on the fly? Or d...

sarah

Wow, thanks scutter for the detailed explanation of the concept of an epoch. I played around with your examples and have a much better understanding now!

sarah

Hello,

Another question... What exactly is an epoch? Is it like the Oracle SCN (System Change Number)?

(Added by me): Can someone please explain what the current_epoch, ahm_epoch, last_good_epoch and refresh_epoch columns represent in the system table?

Thanks you.

sarah

Hello! I'm glad I found this site! I'm very new to Vertica and have a lot of questions :oops: I'm a bit embarrassed to ask the simple question on the Vertica site. Can someone please explain to me the difference between a column's data type and encoding type? Whey do we need an encoding type I guess...

Search found 77 matches

Re: Execs Leaving Vertica ...

Re: SURPRISE column ?!?!

Re: How to handle "currency" in Vertica

Re: What is a column encoding type?

Re: What is an epoch exactly?

What is an epoch exactly?

What is a column encoding type?