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
Encoding Techniques for table creation
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Encoding Techniques for table creation
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.
Re: Encoding Techniques for table creation
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Mon May 04, 2015 9:06 pm, edited 2 times in total.
Re: Encoding Techniques for table creation
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.
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.