Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Donner par année le nombre de films sortis
- GET /movies/_search
- { "size": 0,
- "aggregations":{
- "par_annee":{
- "terms": {
- "field": "fields.year"
- }
- }
- }
- }
- #Donner les occurrences des films par catégorie (genres) de film
- GET /movies/_search
- { "size": 0,
- "aggregations":{
- "Categorie":{
- "terms": {
- "field": "fields.genres.keyword"
- }
- }
- }
- }
- #Donner la note (rating) moyenne des films
- POST /movies/_search?size=0&pretty
- {
- "aggs" : {
- "Note_Moyenne" : { "avg" : { "field" : "fields.rating"} }
- }
- }
- #Donner la note (rating) moyenne des films de Georges Lucas
- GET /movies/_search
- {
- "size":0,
- "query": {
- "match": {
- "fields.directors": "Michael Bay"
- }
- },
- "aggs" : {
- "Note_Lucas" : { "avg" : { "field" : "fields.rating"} }
- }
- }
- #Donner la note (rating) moyenne des films par genre
- GET /movies/_search
- { "size": 0,
- "aggregations":
- {
- "Genre":{
- "terms": {"field": "fields.genres.keyword"},
- "aggs": {"note_moyenne":{
- "avg":{"field": "fields.rating"}}
- }
- }
- }
- }
- #Donner la note (rating) minimum, maximum et moyenne des films par genre
- GET /movies/_search
- { "size": 0,
- "aggregations":
- {
- "Genre":{
- "terms": {"field": "fields.genres.keyword"},
- "aggs":
- {"Moyenne":
- {
- "avg":
- {"field": "fields.rating"}
- },
- "Minimum":{
- "min": {
- "field": "fields.rating"
- }
- },"Maximum":{
- "max": {
- "field": "fields.rating"
- }
- }
- }
- }
- }
- }
- #Donner le rang (rank) moyen des films par metteur en scène (directors)
- GET /movies/_search
- { "size": 0,
- "aggregations":
- {
- "Moyenne_Director":{
- "terms": {"field": "fields.directors.keyword"},
- "aggs": {"note_moyenne":{
- "avg":{"field": "fields.rating"}}
- }
- }
- }
- }
- #Compter le nombre de films par tranche de note
- GET /movies/_search
- {
- "size":0,
- "aggs": {
- "Classe": {
- "range": {
- "field": "fields.rating",
- "ranges": [
- {
- "from": 0,
- "to": 1.9
- },
- {
- "from": 2,
- "to": 3.9
- },
- {
- "from": 4,
- "to": 5.9
- },
- {
- "from": 5
- }
- ]
- }
- }
- }
- }
- #Nombre de metteurs en scène distincts pour les films d’aventure
- GET /movies/_search
- {
- "size":0,
- "query": {
- "match": {
- "fields.genres.keyword": "Action"
- }
- },
- "aggs" : {
- "Directeur" : { "terms": { "field" : "fields.directors.keyword"} }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement