phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Goulven Rozec <goulven.ro...@gmail.com>
Subject Fwd: How to check "split on" option on table
Date Fri, 24 Jul 2020 07:48:16 GMT
Hi folks,



I would like to create a table with the « split on » option on one part of
the primary key as follow  :



CREATE TABLE IF NOT EXISTS MYTABLE ("col1 " VARCHAR NOT NULL , "col2"
VARCHAR, "col3" VARCHAR NOT NULL, "col4" VARCHAR, "col5" VARCHAR, ……
CONSTRAINT ROWKEY PRIMARY KEY ("col1", "col2")) SPLIT ON ('col1
value1','col2 value2', …… );



How can I check if my « split on » is correctly setup on my table ?



Thanks in advance for your time

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message