cqlsh> CREATE TABLE hotel.available_rooms_by_hotel_date (
... hotel_id text,
... date date,
... room_number smallint,
... is_available boolean,
... PRIMARY KEY ((hotel_id), date, room_number)
... ) WITH comment = 'Q4. Find available rooms by hotel / date';
SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="Invalid (reserved) user type name smallint">
cqlsh> CREATE TABLE hotel.available_rooms_by_hotel_date (
... hotel_id text,
... date date,
... room_number int,
... is_available boolean,
... PRIMARY KEY ((hotel_id), date, room_number)
... ) WITH comment = 'Q4. Find available rooms by hotel / date';
SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="Invalid (reserved) user type name date">
cqlsh> show version
[cqlsh 5.0.1 | Cassandra 2.1.13 | CQL spec 3.2.1 | Native protocol v3]