Skip to main content

CREATE TABLE ... LIKE .. INCLUDING PROJECTIONS - auto naming issue

  • October 17, 2014
  • 2 replies
  • 17 views

Dawid_Glowacki
CREATE TABLE ... LIKE .. INCLUDING PROJECTIONS  statement is automatically copying the projections from the source table. At the same  time the replicated projections are named automatically. Every time this statement is done, the output projection names become longer and longer like for example below:
# iteration, source table proj name, target table proj name
1,dg_tables2_b1, dg_tables2_v1_b0
2,dg_tables2_v1_b0, dg_tables2_v1_v1_b0
3,dg_tables2_v1_v1_b0, dg_tables2_v1_v1_v1_b0

So every time the statement is executed Vertica adds the 'v1_' into the projection name. At the end the projection names becomes very long, sooner or later I will hit the 128 chars limit.
Do you know how to control this Vertica projection auto naming to avoid this 'v1_' to be added?
 









2 replies

Shobhit_Garg
Forum|alt.badge.img
  • Participating Frequently
  • October 17, 2014
Hi,

Can you let us know the exact vertica version and exact create table command you are executing.

Regards,
Shobhit

Dawid_Glowacki
  • Author
  • New Participant
  • October 17, 2014
Vertica 7.1
The exact SQL command:  create table dg_tables2 like dg_tables including projections;