Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-2445

Support SQL data types in CQL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 0.8 beta 1
    • Component/s: None
    • Labels:
      None
    • Severity:
      Normal

      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").

        Attachments

        1. 2445.txt
          15 kB
          Jonathan Ellis
        2. ASF.LICENSE.NOT.GRANTED--v1-0001-CASSANDRA-2445-update-documentation.txt
          19 kB
          Eric Evans

          Activity

            People

            • Assignee:
              jbellis Jonathan Ellis
              Reporter:
              jbellis Jonathan Ellis
              Authors:
              Jonathan Ellis
              Reviewers:
              Eric Evans
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: