Hello everybody,
I have a problem with some field types in the managed-schema generated.
First, the data SOLR returned with a standard query :
response":{"numFound":365567,"start":0,"docs":[
{
"id":"560.561.134676",
"parent_i":560,
"asso_i":561,
"personne_i":134676,
"etat_technique_s":"avec_documents",
"etat_marketing_s":"actif",
"type_parent_s":"Ecole élémentaire publique",
"type_asso_s":"APE (association de parents d'élèves)",
"groupe_type_parent_s":"ENSEIGNEMENT_PRIMAIRE",
"groupe_type_asso_s":"ASSOCIATION_DE_PARENTS",
"nombre_commandes_brut_i":2,
"nombre_commandes_i":1,
"nombre_kits_saveur_i":0,
"ca_periode_i":560,
"ca_periode_fleur_i":0,
"ca_periode_saveur_i":0,
"zone_scolaire_s":"A",
"territoire_s":"France Métropolitaine",
"region_s":"AUVERGNE RHONE-ALPES",
"departement_s":"01 AIN",
"postal_country_s":"FR",
"asso_country_s":"FRANCE",
"object_type_s":"contact",
"date_derni_re_commande_dt":"2016-05-20T00:00:00Z",
"_version_":1604889647955050496,
"_childDocuments_":[
{
"fixe_facturation":["0256897856"],
"object_type":["order"],
"mobile_livraison":["0658987874"],
"kit_sans_suite":["false"],
"fixe_livraison":["0450598311"],
"type_cde_s":"CDE",
"statut_s":"V",
"mobile_facturation":["0658787458"],
"campagne_s":"A",
"TTC":[780],
"date_dt":"2016-05-20T00:00:00Z",
"id":"A28837",
"enseigne_s":"CRE"},
{
"fixe_facturation":["0245784975"],
"object_type":["order"],
"mobile_livraison":["0645789874"],
"kit_sans_suite":["false"],
"type_cde_s":"KIT",
"statut_s":"V",
"mobile_facturation":["0612345678"],
"campagne_s":"A",
"TTC":[0],
"date_dt":"2016-05-04T00:00:00Z",
"id":"A25415",
"enseigne_s":"CRE"}]}
My goal is to sum fields "TTC" by parentDocument. But with the type
"multiValued", I can't use aggregation functions.
The core get the data from this script : /opt/solr/bin/post -c <core_name>
-format solr build/index.json
The index.json looks like that:
[
{
"id": "781.782.134878",
"parent_i": 781,
"asso_i": 782,
"personne_i": 134878,
"etat_technique_s": "avec_documents",
"etat_marketing_s": "inactif",
"type_parent_s": "Ecole élémentaire privée",
"type_asso_s": "APEL (association de parents école libre)",
"groupe_type_parent_s": "ENSEIGNEMENT_PRIMAIRE",
"groupe_type_asso_s": "ASSOCIATION_DE_PARENTS",
"nombre_commandes_brut_i": 4,
"nombre_commandes_i": 2,
"nombre_kits_saveur_i": 2,
"date_dernière_commande_dt": "2010-11-16",
"ca_periode_i": 0,
"ca_periode_fleur_i": 0,
"ca_periode_saveur_i": 0,
"zone_scolaire_s": "A",
"territoire_s": "France Métropolitaine",
"region_s": "AUVERGNE RHONE-ALPES",
"departement_s": "01 AIN",
"postal_country_s": "FR",
"asso_country_s": "FRANCE",
"object_type_s": "contact",
"kits_sans_suite_ss": null,
"_childDocuments_": [
{
"fixe_facturation": "0450407279",
"object_type": "order",
"mobile_livraison": "0628332864",
"kit_sans_suite": "false",
"fixe_livraison": "0450407279",
"type_cde_s": "KIT",
"statut_s": "V",
"mobile_facturation": "0628332864",
"campagne_s": "L",
"TTC": 0,
"date_dt": "2009-10-12T00:00:00Z",
"id": "L14276",
"enseigne_s": "SAV",
"gamme": [
"KITS > Kits Saveurs"
]
},
{
"fixe_facturation": "0450407279",
"object_type": "order",
"mobile_livraison": "0628332864",
"kit_sans_suite": "false",
"fixe_livraison": "0450407279",
"type_cde_s": "CDE",
"statut_s": "V",
"mobile_facturation": "0628332864",
"campagne_s": "L",
"TTC": 1045,
"date_dt": "2009-11-14T00:00:00Z",
"id": "L25049",
"enseigne_s": "SAV",
"gamme": [
"CHOCOLAT > Assortiment",
"CHOCOLAT > Individuel",
"CHOCOLAT > Mono-produit",
"EQUIPEMENT MAISON > Cuisine",
"EQUIPEMENT MAISON > Décoration",
"KITS > Kits Saveurs",
"SAVEURS > Confiserie",
"SAVEURS > Pâtisserie"
]
}
]
In the managed-schema, only those fields appear:
<field name="TTC" type="tlongs"/>
<field name="_root_" type="string" docValues="false" indexed="true"
stored="false"/>
<field name="_text_" type="text_general" multiValued="true" indexed="true"
stored="false"/>
<field name="_version_" type="long" indexed="true" stored="false"/>
<field name="fixe_facturation" type="strings"/>
<field name="fixe_livraison" type="strings"/>
<field name="gamme" type="strings"/>
<field name="id" type="string" multiValued="false" indexed="true"
required="true" stored="true"/>
<field name="kit_sans_suite" type="strings"/>
<field name="mobile_facturation" type="strings"/>
<field name="mobile_livraison" type="strings"/>
<field name="object_type" type="strings"/>
I don't understand why for example "type_cmd_s" get the field type attribute
"singleValued", but "TTC" or "kits_sans_suite" get "multiValued" attribute ?
Why those field are in the managed-schema and enseigne_s (for example) is
not ?
Thanks a lot for your help...
Best
JB
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
