Search Functions

SELECT META(t1).id
FROM `travel-sample`.inventory.airline AS t1
WHERE SEARCH(t1.country, "+United +States");

SELECT META(t1).id
FROM `travel-sample`.inventory.airline AS t1
WHERE SEARCH(t1, "country:\"United States\"");

[

  {
    "id": "airline_10"
  },
  {
    "id": "airline_10123"
  },
  {
    "id": "airline_10226"
  },
  {
    "id": "airline_10748"
  },
...
]

SELECT t1.name
FROM `travel-sample`.inventory.hotel AS t1
WHERE SEARCH(t1, {
  "match": "bathrobes",
  "field": "reviews.content",
  "analyzer": "standard"
});

[
  {
    "name": "Typoeth Cottage"
  },
  {
    "name": "Great Orme Lighthouse"
  },
  {
    "name": "New Road Guest House (B&B)"
  },
...
]

SELECT t1.name
FROM `travel-sample`.inventory.hotel AS t1
WHERE SEARCH(t1, {
  "explain": false,
  "fields": [
     "*"
   ],
   "highlight": {},
   "query": {
     "match": "bathrobes",
     "field": "reviews.content",
     "analyzer": "standard"
   },
   "size" : 5,
   "sort": [
      {
       "by" : "field",
       "field" : "reviews.ratings.Overall",
       "mode" : "max",
       "missing" : "last"
      }
   ]
});

[
  {
    "name": "Waunifor"
  },
  {
    "name": "Bistro Prego With Rooms"
  },
  {
    "name": "Thornehill Broome Beach Campground"
  },
...
]

SELECT META(t1).id
FROM `travel-sample`.inventory.hotel AS t1
WHERE t1.type = "hotel" AND SEARCH(t1.description, "amazing");

[
  {
    "id": "hotel_20422"
  },
  {
    "id": "hotel_22096"
  },
  {
    "id": "hotel_25243"
  },
  {
    "id": "hotel_27741"
  }
]

SELECT SEARCH_META() AS meta (1)
FROM `travel-sample`.inventory.hotel AS t1
WHERE SEARCH(t1, {
  "query": {
    "match": "bathrobes",
    "field": "reviews.content",
    "analyzer": "standard"
  },
  "includeLocations": true (2)
})
LIMIT 3;

[
  {
    "meta": {
      "id": "hotel_12068", (3)
      "locations": { (4)
        "reviews.content": {
          "bathrobes": [
            {
              "array_positions": [
                8
              ],
              "end": 664,
              "pos": 122,
              "start": 655
            }
          ]
        }
      },
      "score": 0.3471730605306995 (5)
    }
  },
  {
    "meta": {
      "id": "hotel_18819",
      "locations": {
        "reviews.content": {
          "bathrobes": [
            {
              "array_positions": [
                6
              ],
              "end": 110,
              "pos": 19,
              "start": 101
            }
          ]
        }
      },
      "score": 0.3778486940124847
    }
  },
  {
    "meta": {
      "id": "hotel_5841",
      "locations": {
        "reviews.content": {
          "bathrobes": [
            {
              "array_positions": [
                0
              ],
              "end": 1248,
              "pos": 242,
              "start": 1239
            }
          ]
        }
      },
      "score": 0.3696905918027607
    }
  }
]

SELECT t1.name, SEARCH_META(s1) AS meta (1)
FROM `travel-sample`.inventory.hotel AS t1
WHERE SEARCH(t1.description, "mountain", {"out": "s1"}) (2)
AND SEARCH(t1, {
  "query": {
    "match": "bathrobes",
    "field": "reviews.content",
    "analyzer": "standard"
  }
});

[
  {
    "name": "Marina del Rey Marriott"
  }
]

SELECT name, description, SEARCH_SCORE() AS score (1)
FROM `travel-sample`.inventory.hotel AS t1
WHERE SEARCH(t1.description, "mountain")
ORDER BY score DESC
LIMIT 3;

[
  {
    "description": "3 Star Hotel next to the Mountain Railway terminus and set in 30 acres of grounds which include Dolbadarn Castle",
    "name": "The Royal Victoria Hotel"
  },
  {
    "description": "370 guest rooms offering both water and mountain view.",
    "name": "Marina del Rey Marriott"
  },
  {
    "description": "This small family run hotel captures the spirit of Mull and is a perfect rural holiday retreat. The mountain and sea blend together to give fantastic, panoramic views from the hotel which is in an elevated position on the shoreline. Panoramic views are also available from the bar and restaurant which serves local produce 7 days a week.",
    "name": "The Glenforsa Hotel"
  }
]