Hello
I am trying to create a table with Primary key and partition key as follows,
Create Table if not exists Schema.Alert
(
...
PRIMARY KEY (("Col1","Col2"), Col3,Col4,Col5)
) WITH CLUSTERING ORDER by (Col5 ASC);
Primary key : Col1 to col5
Partition Key : Col1 AND Col2
I am unable to do so in the hackolade app,as I can onl add 1 column at a time in the partition key (on the right pane).
Please advise
Cheers
kalyan
Hi Kalyan,
By clicking the + sign in the Properties Pane for Partition Key, you can add columns. Let's take this expected CQL CREATE TABLE script:
CREATE TABLE IF NOT EXISTS "new_keyspace"."crossfit_gyms_by_city" (
"country_code" text,
"city" text,
"state_province" text,
"gym_name" text,
"opening_date" timestamp,
PRIMARY KEY (("country_code", "state_province", "city"), "opening_date", "gym_name")
)
WITH CLUSTERING ORDER BY ("opening_date" ASC, "gym_name" ASC);
You would model it in Hackolade this way:
Does that make sense?
hi, i tried to add partitioning and clustering keys in a table, but attributes are not availible for choosing. why?
Hello. Partition keys and clustering keys are mutually exclusive. So if a column has been selected for a PK for example, then when the dialog opens up for a CK, that column will not be selectable. If you still have questions, I suggest you send your model and screenshots to support@hackolade.com so our helpdesk can assist you.
