Menu

#22 Add support to distribute on other than unique column

Development Queue
open
nobody
5
2012-06-03
2011-04-12
Abbas Butt
No

create table blood_gp(bg_id integer PRIMARY KEY, pos integer, bg_name varchar(20)) distribute by modulo (pos);
results in
ERROR: Unique index of partitioned table must contain the hash/modulo distribution column.

This needs some fundamental work to solve. We need to enforce the uniqueness (or other constraints) globally among all the nodes involved.

Discussion

  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03

    Global constraint issue.

     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03
    • milestone: 1843521 --> Development Queue
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.