vertica - ERROR: Unsupported access to table with projection expressions or aggregates -


i want remove partitioning table:

alter table rosing_watch_sessions remove partitioning 

but raise error:

severity: rollback,  message: unsupported access table projection expressions or aggregates,  sqlstate: 0a000,  routine: checkunsupportedmavericktableerror,  file: /scratch_a/release/16125/vbuild/vertica/catalog/cataloglookup.cpp,  line: 1383 

what mean error message?

p.s.

result of select export_objects('', 'rosing_watch_sessions'):

create table staging.rosing_watch_sessions (     id  identity ,     session_uid varchar(255) not null,     ... ) partition (rosing_watch_sessions.requested_day);  alter table staging.rosing_watch_sessions add constraint c_primary primary key (id);   create projection staging.rosing_watch_sessions_super /*+basename(rosing_watch_sessions),createtype(p)*/  (  id,  session_uid,  ... )  select rosing_watch_sessions.id,         rosing_watch_sessions.session_uid,         ...  staging.rosing_watch_sessions  order rosing_watch_sessions.id segmented hash(rosing_watch_sessions.requested_day) nodes ;  create projection staging.channel_coverage (  resource_uid,  device_uid,  request_date,  num_requests,  __partition_key_value__ encoding rle )  select rosing_watch_sessions.resource_uid,         rosing_watch_sessions.device_uid,         date("timezone"('utc'::varchar(3), rosing_watch_sessions.requested_at)) request_date,         count(rosing_watch_sessions.session_uid) num_requests,         max(rosing_watch_sessions.requested_day) __partition_key_value__  staging.rosing_watch_sessions  group rosing_watch_sessions.resource_uid,           rosing_watch_sessions.device_uid,           date("timezone"('utc'::varchar(3), rosing_watch_sessions.requested_at)) ;   select mark_design_ksafe(0); 

live aggregate projections not support operations (yet).

drop projection staging.channel_coverage; alter table rosing_watch_sessions remove partitioning; 

then rebuild staging.channel_coverage using ddl have.


Comments