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
Post a Comment