[CASSANDRA-2445] Support SQL data types in CQL

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 0.8 beta 1
• Severity: Normal
• Assignee: Jonathan Ellis
• Reporter: Jonathan Ellis

Authors

Jonathan Ellis

Reviewers

Eric Evans

• Created: 09/Apr/11 21:40
• Updated: 16/Apr/19 09:33
• Resolved: 10/Apr/11 04:45

Description

We should support SQL data types where possible:

(sql -> cassandra)
varint -> int
bigint -> long
varchar, text -> utf8
ascii -> ascii (not strictly correct – sql defines collations for this – but close enough for a 1.0)
uuid -> uuid (see CASSANDRA-2233)
bytea -> bytes

IMO the right thing to do is only support the SQL types in CQL CREATE statements, because there is ambiguity otherwise (in particular with "int").