XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 1.1.1
    • Legacy/CQL
    • None

    Description

      It would be nice to add a native syntax for the use of ReversedType. I'm sure there is anything in SQL that we inspired ourselves from, so I would propose something like:

      CREATE TABLE timeseries (
        key text,
        time uuid,
        value text,
        PRIMARY KEY (key, time DESC)
      )
      

      Alternatively, the DESC could also be put after the column name definition but one argument for putting it in the PK instead is that this only apply to keys.

      Attachments

        1. 4004_alternative.txt
          14 kB
          Sylvain Lebresne
        2. 4004_alternative-v2.txt
          15 kB
          Sylvain Lebresne
        3. 4004.txt
          6 kB
          Sylvain Lebresne

        Issue Links

          Activity

            People

              slebresne Sylvain Lebresne
              slebresne Sylvain Lebresne
              Sylvain Lebresne
              Jonathan Ellis
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: