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

Forum|Forum|11 years ago
May 4, 2015
2 replies
16 views

Yeswanth
New Participant

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

+1

SruthiA
Participating Frequently
Forum|Forum|11 years ago
May 4, 2015

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