Encoding Techniques for table creation

Moderator: NorbertKrupa

Post Reply
Rambhupal
Newbie
Newbie
Posts: 1
Joined: Thu Dec 04, 2014 10:31 am

Encoding Techniques for table creation

Post by Rambhupal » Wed Jan 21, 2015 2:47 pm

Hi All,

I want to create a table with ENCODING rules. i just want to understand what is the best encoding for what data type. its great worth for me if you post in below format....


varchar---
char---
integer----
numeric----
Date--

example:

timestamp--- GCDDELTA <-----EXAMPLE

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

Re: Encoding Techniques for table creation

Post by NorbertKrupa » Wed Jan 21, 2015 3:01 pm

The easiest thing to do is run database designer after loading some data. DBD will determine the best encoding for the data in your columns. Otherwise, see the documentation on encoding types.
Checkout vertica.tips for more Vertica resources.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Encoding Techniques for table creation

Post by id10t » Wed Jan 21, 2015 10:54 pm

Hi!

[DELETED]
Last edited by id10t on Mon May 04, 2015 9:06 pm, edited 2 times in total.

msv
Newbie
Newbie
Posts: 2
Joined: Thu Sep 11, 2014 4:37 pm

Re: Encoding Techniques for table creation

Post by msv » Thu Jan 22, 2015 3:25 am

RLE on a rowid doesn't seem very optimal and sticks out like a sore thumb in your example. I think it is important to note that you need real, representative data in these tables before running DBD or related API.

Also, DBD can be run without deployment if you just want to look over the scripts. It's less targeted, but simpler and might show you other areas of interest in your projection design.

Post Reply

Return to “New to Vertica Database Development”