Problems with using designer_design_projection_encodings function

  • KM03297098
  • 04-Dec-2018
  • 04-Dec-2018

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

ERROR 4460: Projection anchor_table_name does not exist

Question

Trying to optimize projection encodings with help of function designer_design_projection_encodings.

The table exist, and projections exists. The table have a lot of data.


Now trying to use function:
select designer_design_projection_encodings('projection_schema.anchor_table_name','','false','true');
ERROR 4460: Projection projection_schema.anchor_table_name does not exist

Answer

It seems that if we include either database name or table name, the function complains about "projection does not exist."

select DESIGNER_DESIGN_PROJECTION_ENCODINGS('projection_schema.projection_name','','false', 'true');