Logging
Create Data View
During creation of a data view, a debug message is logged like below :
DEBUG 2019-03-05 16:13:21.889 -0800 DDLNode - Data View '/shared/examples/myviewWithProps' created with sql 'SELECT OrderID
FROM /shared/examples/ViewOrder'
DEBUG 2019-03-05 16:13:21.889 -0800 DDLNode - Set annotation on resource: /shared/examples/myviewWithProps
Annotation: this view is created using DSL
"IF NOT EXISTS" can be specified in the CREATE DATA VIEW command optionally. If the data view being created does not exist, its then created. If resource already exists, no error is thrown when IF NOT EXISTS keywords are specified.
Delete Data View
During deletion of a data view, if debug logging is enabled, the following is logged
DEBUG 2019-03-05 16:11:52.452 -0800 DDLNode - Deleted :
/shared/examples/myviewWithProps
"IF EXISTS" can be specified optionally with the DROP DATA VIEW command. If the data view being dropped exists, it is dropped. If the data view being dropped does not exist, and "IF EXISTS" keywords are used, no error is thrown.
Alter Data View
When a data view is altered, a definition sql may or may not be provided. When a definition sql is provided which is not the same as the existing definition sql, the new sql is set on the view resource.
Annotation is optional, with the alter syntax.
When debug logging is enabled, the following is logged in cs_server.log
DEBUG 2019-03-05 16:18:16.521 -0800 DDLNode - Set annotation on resource: /shared/examples/myviewWithProps
Annotation: this view is altered using DSL
DEBUG 2019-03-05 16:18:16.522 -0800 DDLNode - "Data View '/shared/examples/myviewWithProps' altered with sql 'SELECT OrderID, CompanyName
FROM /shared/examples/ViewOrder'
To turn on debug logging for these commands, please set the following in conf/server/log4j.properties
log4j.logger.com.compositesw.server.qe.physical.ddl=DEBUG