The first parameter is the object name. Enclose the object name in single quotes. Object names that begin with a digit must be enclosed in double quotes and then single quotes.

The second parameter is the Compass data partition. Partitions correspond to dates. The dates are based on the date of the last modified timestamp. The lastmodified timestamp is the date time on which the data object was added to the Data Lake. The clear data procedure clears all Compass data on and after the specified date. Enclose the date with single quotes. Query syntax is case-insensitive.




exec infor.clear_data('product', '2020-01-01')
exec infor.clear_data('"123object"', '2020-01-01')