Best encoding type for people's names

Moderator: NorbertKrupa

Post Reply
Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

Best encoding type for people's names

Post by Brett » Thu Jun 12, 2014 11:57 pm

Hi,

What is the best encoding type for a varchar that stores people last name? Obviously the cardinality is low. Should I just leave it AUTO?

-Thanks

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Best encoding type for people's names

Post by NorbertKrupa » Fri Jun 13, 2014 4:08 am

AUTO will probably use Lempel-Ziv-Oberhumer-based (LZO) compression for varchars. You can always run DBD to see what it comes up with.
Checkout vertica.tips for more Vertica resources.

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Best encoding type for people's names

Post by nnani » Fri Jun 13, 2014 6:54 am

Just to add to norbert's reply.

IF you are running DBD make sure, you have enough of sampling data in the table / column for the DBD

Hope this helps
nnani........
Long way to go

You can check out my blogs at vertica-howto

Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

Re: Best encoding type for people's names

Post by Brett » Fri Jun 13, 2014 11:52 am

Thanks, all. I figured auto was probably the best. I am going to post another question in a different topic about how to run DBD on a single table.

Post Reply

Return to “New to Vertica”