sql - Create a database view in HANA with data types defined -
when using hana sqlscript possible create view data types defined or need cast type in every select statement being used? running implicit data type issues hana doesn't seem evaluating data being used.
when create view data type defined syntax errors wondering if possible. on hana revision 84.
--trying create view datatype defined create view testview ( measure1 decimal(25,10) ) select 4493.3489212 dummy --creating view casting type in select statement create view testview (measure1) select cast(4493.3489212 decimal(25,10)) dummy
when creating sql views via create view, you're not using sqlscript standard sql. , standard sql doesn't have explicit output structure definition, you're depending on data types create in select statement (e.g. via cast()).
when dealing actual sap hana information models (e.g. scripted calculation view) explicitly define output structure (semantics tab).
Comments
Post a Comment