Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-18729

add array indexing to travel-sample

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.5.0
    • 4.5.0
    • installer
    • None
    • Untriaged
    • Unknown

    Description

      We should add a new array index to watson.
      Feel free to sugest queries but it would be great to add something like this: look for flights from LAX that depart at 21:00:00 hours. The array index takes the schedule array and utc times.
      CREATE INDEX def_schedule_utc on `travel-sample`(
      ARRAY s.utc FOR s IN schedule END )

      SELECT * FROM `travel-sample`
      WHERE ANY s IN schedule SATISFIES s.utc BETWEEN "21:00:00" AND "21:01:00" END
      AND sourceairport = "LAX";

      We should add the example to the app and getting started pages.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            cihan Cihan Biyikoglu (Inactive)
            cihan Cihan Biyikoglu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty