Projection Encoding Design

[Timbo]

Hi,
Has anyone used the following function in V6:-
DESIGNER_DESIGN_PROJECTION_ENCODINGS

Is is in the 6.1 documentation, but I think it is only in V7.

https://my.vertica.com/docs/6.1.x/HTML/ ... #22012.htm

SELECT DESIGNER_DESIGN_PROJECTION_ENCODINGS (
'public.*',
'encodings.sql',
'false'
);
ERROR 3457: Function DESIGNER_DESIGN_PROJECTION_ENCODINGS(unknown, unknown, unknown) does not exist, or permission is denied for DESIGNER_DESIGN_PROJECTION_ENCODINGS(unknown, unknown, unknown)
HINT: No function matches the given name and argument types. You may need to add explicit type casts

Regards
Tim

[pborne]

On Version 6.x, you can use the following:

select dbd_design_projection_encodings('public.table_name', '/home/dbadmin/deploy_test.sql', false);

You can also control the size of the sample used to determine the best encoding per column but the defaults should work fine in general.

The call above will schedule a background job and you need to wait for it to complete before the DDL script is generated.

You can use something like this to check on it:

select * from design_status order by event_time desc;

[Timbo]

Hi, Thanks for the reply, does not work with segmented projections:-
dbadmin=> select dbd_design_projection_encodings('public.fxspots_0_b0','/home/dbadmin/DBDesigner/fxspots_dbd_test.sql',false);
select dbd_design_projection_encodings('public.fxspots_0_b0','/home/dbadmin/DBDesigner/fxspots_dbd_test.sql',false);
WARNING 5657: Segmentation type of the projection public.fxspots_0_b0 is not supported for encoding design, skipping
WARNING 5657: Segmentation type of the projection public.fxspots_0_b1 is not supported for encoding design, skipping
ERROR 3100: Did not find any projections to design encodings for

Regards
Tim

[pborne]

How is your projection segmented?

[Timbo]

Projections are segments as below:-
SEGMENTED BY modularhash(t.labelname, t.labeldate, t.id, t.service, t.identifier, t.source) ALL NODES ;