Creating columns with a single value (static column) [DATACASS-812]

[spring-projects-issues]

lmcdasi opened DATACASS-812 and commented

In the DataStax driver manual, there is a possibility to create columns as static.

https://docs.datastax.com/en/dse/6.0/cql/cql/cql_using/refStaticCol.html

In the driver code, the DefaultAlterTable seems to support the addition of static columns through: columnsToAddStatic

I'm wondering if we can achieve the same with the framework & if not is it possible introduce this functionality ?

Thx

---

No further details from DATACASS-812

[spring-projects-issues]

Mark Paluch commented

That sounds a neat enhancement. Feel free to submit a pull request. I assume it doesn't make so much sense to use static columns for entities, right?

[spring-projects-issues]

lmcdasi commented

The way that our developers would like to use it in the entity is:

@Getter
@Column(aud_typ) // Static
private String audioType;

So I guess a @Column(..., static=true) or alike would be great.

When the table is created that should translate into the static be added into the create table:

 
CREATE TABLE test_media.media (
...
aud_channels int static,
aud_dtls map<text, text> static,
aud_smpl_rate int static,
aud_typ text static,
cr_time timestamp,
del_at timestamp,
dur_mls bigint static,
live boolean static,
media_typ text static,
parent boolean,
seg_end_mls bigint,
seg_start_mls bigint,
size_bytes bigint static,
stor_path text static,
PRIMARY KEY (....)
) WITH CLUSTERING ORDER BY (rlm_id ASC, seg_id ASC)
....;
 
Sorry - I'm playing a bit of a 3rd party on this request