Is there an ENUM datatype in Cassandra? For example, using a pseudo-CQL language:
CREATE ENUM MovieGenre (Comedy, Romance, Fantasy, SciFi)
Then use it as:
INSERT INTO myMovie (movieid, name, genre) VALUES (124-abcd, 'The Enum Story', MovieGenre.SciFi);
The idea is to use a more compact encoding of the values and avoid unintended creation of new values because of typos or case sensitivity.
@Tri, CQL does not have an enum data type. It would have to be done from the application writing into the database. For example, one could write their own custom codec implementation using DataStax Java Driver 4.7 which was implemented as part of JAVA-846.
Alternatively, if you're looking for User Defined Type (UDT), refer to this documentation for working with them.
[EDIT] UDTs are not equivalent to enums.
I hope that helps!
@smadhavan Can you please show an example how to use UDT to fit a use-case of "Must-be-one-among-these" like enum?
BTW what is the syntax to write the inline code like the enum in red in your reply above? I used markdown (surround by backticks) but it seems not compatible in this board.
The DataStax Java Driver 4.7 you indicated is closer to what I was looking for. Thanks. Does that work with open source Cassandra? If yes, does it require a license?
6 People are following this question.
