Netezza - What is datatype for select Sum(col) from table

caseyhoo · Post by **caseyhoo** » Mon Oct 06, 2014 9:36 am

Im using netezza connector. I try to sum a numeric NUMERIC column using below select statement. However, I always get "did not have a compatible data type. These columns will be dropped from the output link schema" message.

select Sum(col) as ssum from table

May I know what DS datatype I should use? I had tried all of them (may be I missed out).

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Oct 06, 2014 3:30 pm

A Numeric data type with sufficiently large precision should be adequate.

Try dfloat (Double), since this is the largest possible numeric data type, and all numeric data types can be implicitly converted to it. Also try reducing the severity of metadata mismatch reports in any Connector stage that you are using.

caseyhoo · Post by **caseyhoo** » Tue Oct 07, 2014 8:57 pm

Beside using Double for the "sum" column, below is the others changes that i did.

At "Netezza Connector" stage, I had change "Type mismatch action" to Keep.

ray.wurlod, billions thanks