NOTICE 3175: Encoding requested for column '<column_name>' does nothing

Yeswanth

Hi All,

 

When I try to create projection we are facing the below issue but "projection is getting created". And these columns are related to Numeric(19,0) datatype. I am using Encoding type – DELTAVAL for Numeric datatype.

 

 

 NOTICE 3175:  Encoding requested for column 'upload_data' does nothing

 NOTICE 3175:  Encoding requested for column 'val' does nothing

 NOTICE 3175:  Encoding requested for column 'optional' does nothing

CREATE PROJECTION

 

 

Please help how to resolve this.

 

Thanks & Regards,

Yeswanth

SruthiA

Hi Yeshwanth,

 

 

     When using encoding type PARAMETER for numeric data type, HP Vertica recommends using numeric with 18 digits or less. In order to have effect of encoding, use Numeric data type with 18 digits or lesser.

 

For more information please refer to the documentation http://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/SQLReferenceManual/Statements/encoding-type.htm

 

 

-Regards,

 Sruthi

Yeswanth

Hi Sruthi,

 

It worked. Thank you so much.

 

Regards,

Yeswanth