Considerations
Listed below are some points to consider while working with Virtual Tables and Procedures:
• Virtual Table / Procedure DSL can be executed using:
For Create/Alter/Delete: http://localhost:9400/rest/execute/v1/ actions/ dsl/invoke
For read: http://localhost:9400/rest/execute/v1/actions/query/invoke
• During creation of virtual table or procedure, a target is to be specified which refers to the base table or procedure in non-published area. "target" is mandatory in a create command. Specifying target is optional in an alter command and when specified during alter, its used to change the target.
• Validation is performed to check if the specified target is of type TABLE or PROCEDURE specified in the DSL command.
• Use the "CREATE VIRTUAL TABLE|PROCEDURE IF NOT EXISTS" syntax to avoid any error messages if the virtual table or procedure already exists.
• For annotation QUOTED_STRING, an explicit NULL keyword or simply ‘NULL’ can be specified. This is to allow annotation to be unset or set to null explicitly.
• Altering a virtual table or procedure can also alter the annotation or rename/relocate the virtual table or procedure.
• Drop virtual table or procedure includes an "IF EXISTS" syntax. When this is specified, error will not be displayed for non-existent resources.