Details
-
Bug
-
Resolution: Fixed
-
Critical
-
Goldfish Private Preview
-
Enterprise Edition 8.0.0 build 1448
-
Untriaged
-
analytics_query_fail_internal_error → http://supportal.couchbase.com/snapshot/d8a23c372b8bd05a1076afbae2b0589b::0
-
0
-
Unknown
-
Analytics Sprint 30
Description
|
Query |
select city,country,count(*) from volCollection where free_breakfast=True and free_parking=True group by country,city order by country,city limit 100;
|
|
Document Type |
{
|
"_id": "test_docs-0000080001",
|
"address": "492 Collin Pine",
|
"city": "492 Collin Pine",
|
"country": "South Africa",
|
"email": "Mariah.Macejkovic@hotels.com",
|
"free_breakfast": false,
|
"free_parking": false,
|
"phone": "531-306-7716",
|
"name": "Kassandra Renner",
|
"price": 888,
|
"avg_rating": 3.191835880279541,
|
"public_likes": [
|
"Winona Mayer",
|
"Lloyd Raynor",
|
"Nicola Nolan",
|
"Jules Herzog",
|
"Afton Parker III",
|
"Eloisa Nitzsche",
|
"Evelyn Schroeder",
|
"Miss Kurt Klocko"
|
],
|
"reviews": [
|
{
|
"author": "Shyann Streich Sr.",
|
"date": "2023-11-02 21:49:46",
|
"ratings": {
|
"Check in / front desk": 1,
|
"Cleanliness": 3,
|
"Overall": 3,
|
"Rooms": 3,
|
"Value": 3
|
}
|
},
|
{
|
"author": "Miss Herminia Powlowski",
|
"date": "2023-11-09 21:49:46",
|
"ratings": {
|
"Check in / front desk": 4,
|
"Cleanliness": 0,
|
"Overall": 3,
|
"Rooms": 3,
|
"Value": 3
|
}
|
},
|
{
|
"author": "Keith Lebsack",
|
"date": "2023-11-16 21:49:46",
|
"ratings": {
|
"Check in / front desk": 3,
|
"Cleanliness": 0,
|
"Overall": 4,
|
"Rooms": 0,
|
"Value": 4
|
}
|
},
|
{
|
"author": "Dorothea Schroeder PhD",
|
"date": "2023-11-23 21:49:46",
|
"ratings": {
|
"Check in / front desk": 3,
|
"Cleanliness": 1,
|
"Overall": 1,
|
"Rooms": 1,
|
"Value": 1
|
}
|
}
|
],
|
"type": "Suites",
|
"url": "www.shaun-lemke.co"
|
}
|
|
QueryResult |
[
|
{
|
"code": 25000,
|
"msg": "Internal error",
|
"query_from_user": "select city,country,count(*) from volCollection where free_breakfast=True and free_parking=True group by country,city order by country,city limit 100;"
|
}
|
]
|