How to get a varchar type out of a hdbdd-model?

[i033659]

Hello,

I'd like to define the tree model input table type for the PAL function PREDICTWITHDT within CDS via an hdbdd-file. The tree model input data type needs varchar(5000), but string(5000) in hdbdd generates nvarchar(5000). When trying to use this tree model table with type nvarchar(5000) as input table in the AFM for the "Predict with Decision Tree" algorithm, one gets an error telling that the table column setting does not match the function specification.

Is there any possibility to get varchar from hdbdd?

Thanks,

Ingo

[former_member221716]

Hi All,

I know this is an old thread, but let me answer it for future reference.

Starting SPS9 Revision 90 you can use VARCHAR in CDS HDBDD. The data type should be hana.VARCHAR.

For more information search for "SAP HANA to CDS Data-Type Mapping"

Best regards,

Viktor Vass

[former_member182302]

Hi There,

As per the SAP HANA Developer guide page no: 193

VARCHAR is not supported from CDS types.

Regards,

Krishna Tangudu

[i033659]

Hi Krishna,

Alternatively I used the hdbtable type to create a table with the required data types.

Regards,

Ingo

[former_member182302]

ho yes u can hdbtable instead of hdbdd

Regards,

Krishna Tangudu