Follow

GAdmin Column Stats displays “Should not be Dict Encoded”

Incident Synopsis:

Gadmin Column Stats displays “Should not be Dict Encoded”

 

Problem/Question:

The warning is displayed when displaying columns Stats in GAdmin.

Reproduction steps: GAdmin -> Data -> Tables -> Select a Table -> Stats.

Some columns under Notes is saying “Should not be Dict Encoded”.

What does it mean, and what should it be changed to?

Screen_Shot_2020-07-22_at_11.35.26.png

Environment:

Kinetica On-prem 7.x

 

Cause:

Dictionary encoding is eligible for individual columns of the following effective types:

  • int
  • long
  • date
  • char1 – char256

On the other hand, columns with any of the following characteristics are not eligible for dictionary encoding:

  • Any effective types other than the above
  • Column with store_only data handling property
  • Column with compression
  • Column is member of an existing primary key or shard key; i.e. dictionary encoding cannot be applied to primary key or shard key columns after table creation.
  • Dictionary encoded column is not eligible for use in filtered view or join view

 

Solution/Answer:

It is recommended not to enable dictionary encoding on the column where the above warning is displayed.

To disable dictionary encoding, from GAdmin you go to Data -> Tables -> click the table name -> Config.

Please uncheck checkbox under Dict Enc of the particular column then click Apply.

 

Special Considerations:

https://www.kinetica.com/docs/concepts/dictionary_encoding.html 

https://support.kinetica.com/hc/en-us/articles/360002749874-CONF-0005-Using-Dictionary-Encoding-to-Save-Memory

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.