You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by fabigol <fa...@vialtis.com> on 2015/10/27 08:52:27 UTC
Many mapping files
Hi,
I already posted on my subject that helped me a lot. I recover a solr
project but the person is gone.
There are several configuration files / mapping (base / Solr)
What interest do that?
thanks for your help
--
View this message in context: http://lucene.472066.n3.nabble.com/Many-mapping-files-tp4236658.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Many mapping files
Posted by Gora Mohanty <go...@mimirtech.com>.
On 28 October 2015 at 19:45, fabigol <fa...@vialtis.com> wrote:
>
> Thank for your response.
> I have 7 files *.xml. I already worked with SOlr but i have an only file. My
> question is why in this project there's 7 files describing an entity.
I am afraid that it is still difficult for an external person to guess
at how these files are being used without looking at complete details.
These look like separate data-config.xml files for DIH, and my best
guess is that either these were used for trial-and-error while setting
up the Solr installation, or that the person responsible manually
edited Solr's configuration files to use one or the other
data-config.xml (not sure why one would do that).
You might be better off trying to understand things from the other
end, i.e., figuring out what searches are made in the system, and what
data from the RDBMS needs to be imported into Solr for these. That
should lead you to an understanding of how these DIH data
configuration files might be used.
Regards,
Gora
Re: Many mapping files
Posted by fabigol <fa...@vialtis.com>.
Thank for your response.
I have 7 files *.xml. I already worked with SOlr but i have an only file. My
question is why in this project there's 7 files describing an entity.
Here my files:
<dataConfig>
<dataSource name="" driver="org.postgresql.Driver"
url="" user=""
password="" readOnly="true" autoCommit="false" batchSize="100000"
transactionIsolation="TRANSACTION_READ_COMMITTED"
holdability="CLOSE_CURSORS_AT_COMMIT" />
<document>
<entity rootEntity="true" name="tiers" dataSource=""
query="select * from bi_solr_tiers" transformer="RegexTransformer">
<field name="ID" column="tiers_id" />
<field name="DOC_TYPE" column="tiers_doc_type" />
<field name="ID_CLIENT" column="tiers_id_client" />
<field name="NOM_CLIENT" column="tiers_nom_client" />
<field name="ID_PARENT" column="tiers_id_parent" splitBy="," />
<field name="ID_PAYS_CLIENT" column="tiers_id_pays_client" />
<field name="ID_SEGMENT" column="tiers_id_segment" />
<field name="ID_SALE" column="tiers_id_sale" />
<field name="NOM_SALE" column="tiers_nom_sale" />
<field name="U_ID_CLIENT" column="tiers_id_client" />
<field name="U_NOM_CLIENT" column="tiers_nom_client" />
<field name="U_ID_PARENT" column="tiers_id_parent" splitBy="," />
<field name="U_ID_PAYS_CLIENT" column="tiers_id_pays_client" />
<field name="U_ID_SEGMENT" column="tiers_id_segment" />
<field name="U_ID_SALE" column="tiers_id_sale" />
<field name="U_NOM_SALE" column="tiers_nom_sale" />
<entity name="tiers_contrat" dataSource=""
query="select * from bi_solr_contrat">
<field name="ID_PARTENAIRE" column="contrat_id_partenaire" />
<field name="NOM_PARTENAIRE" column="contrat_nom_partenaire" />
<field name="TYPE_PARTENAIRE" column="contrat_type_partenaire" />
<field name="ID_TYPE_SERVICE" column="contrat_id_type_service" />
<field name="ID_FILIALE" column="contrat_id_filiale" />
<field name="NOM_FILIALE" column="contrat_nom_filiale" />
<field name="COMPTE_WEB_POSSIBLE" column="contrat_compte_web_possible"
/>
<field name="ID_CONTRAT" column="contrat_id_contrat" />
<field name="ID_STATUT_CONTRAT" column="contrat_id_statut_contrat" />
<field name="NOM_PRODUIT" column="contrat_nom_produit" />
<field name="ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="ID_BENEFICIAIRE_HONO" column="contrat_id_beneficiaire_hono"
/>
<field name="ID_PAYEUR_CONSO" column="contrat_id_payeur_conso" />
<field name="ID_PAYEUR_HONO" column="contrat_id_payeur_hono" />
<field name="REF_CONTRAT_TVA" column="contrat_ref_contrat_tva" />
<field name="PAYS_DEPOT_TVA" column="contrat_pays_depot_tva" />
</entity>
<entity name="tiers_carte" dataSource=""
query="select
carte_id_client,
carte_id_carte,
carte_num_carte,
carte_carte_active,
carte_immatriculation,
carte_nom_flotte
from bi_solr_carte"
cacheKey="carte_id_client" cacheLookup="tiers.tiers_id_client"
>
<field name="ID_CARTE" column="carte_id_carte" />
<field name="NUM_CARTE" column="carte_num_carte" />
<field name="CARTE_ACTIVE" column="carte_carte_active" />
<field name="IMMATRICULATION" column="carte_immatriculation" />
<field name="NOM_FLOTTE" column="carte_nom_flotte" />
</entity>
<entity name="tiers_invoice" dataSource="" query="select
distinct bi_solr_invoice.*,
bi_solr_contrat.contrat_id_client
from bi_solr_invoice
inner join bi_solr_invoice_cnt on
bi_solr_invoice.invoice_numero_facture=bi_solr_invoice_cnt.numero_facture
inner join bi_solr_contrat on
bi_solr_contrat.contrat_id_contrat=bi_solr_invoice_cnt.id_contrat">
<field name="NUMERO_FACTURE" column="invoice_numero_facture" />
<field name="ID_BENEFICIAIRE" column="invoice_id_beneficiaire" />
<field name="ID_PAYEUR" column="invoice_id_payeur" />
<field name="DATE_EMISSION" column="invoice_date_emission" />
<field name="DATE_EMISSION_DD_MM_YYYY"
column="invoice_date_emission_dd_mm_yyyy" />
<field name="DATE_EMISSION_MM_YYYY"
column="invoice_date_emission_mm_yyyy" />
<field name="DATE_EMISSION_YYYY" column="invoice_date_emission_yyyy" />
<field name="DEVISE" column="invoice_devise" />
<field name="INVOICE_TOTAL_HT" column="invoice_total_ht" />
<field name="INVOICE_TOTAL_TVA" column="invoice_total_tva" />
<field name="INVOICE_TOTAL_TTC" column="invoice_total_ttc" />
</entity>
<entity name="tiers_conso" dataSource=""
query="select
conso_id_client,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where conso_id_client is not null
and (conso_type_transaction is null or conso_type_transaction !=
'1')">
<field name="NUM_CARTE" column="conso_numero_carte" />
<field name="IMMATRICULATION" column="conso_immatriculation" />
<field name="NOM_FLOTTE" column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso" />
<field name="NOM_GARE_ORIGINE" column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE" column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE" column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE" column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE" column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE" column="conso_sca_sortie" />
<field name="STATUT_CONSO" column="conso_statut" />
</entity>
<entity name="tiers_conso_remise" dataSource=""
query="select
conso_id_client,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where conso_id_client is not null
and conso_type_transaction != '3'">
<field name="NUM_CARTE" column="conso_numero_carte" />
<field name="IMMATRICULATION" column="conso_immatriculation" />
<field name="NOM_FLOTTE" column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso" />
<field name="NOM_GARE_ORIGINE" column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE" column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE" column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE" column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE" column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE" column="conso_sca_sortie" />
<field name="STATUT_CONSO" column="conso_statut" />
</entity>
<entity name="tiers_remise" dataSource=""
query="select
remise_id_client,
remise_numero_carte,
remise_immatriculation,
remise_nom_flotte,
remise_id_remise,
remise_sca_entree
from bi_solr_remise where remise_id_client is not null">
<field name="NUM_CARTE" column="remise_numero_carte" />
<field name="IMMATRICULATION" column="remise_immatriculation" />
<field name="NOM_FLOTTE" column="remise_nom_flotte" />
<field name="ID_REMISE" column="remise_id_remise" />
<field name="NOM_SCA_ORIGINE" column="remise_sca_entree" />
</entity>
</entity>
</document>
</dataConfig>
<dataConfig>
<dataSource name="" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/" user=""
password="" readOnly="true" autoCommit="false" batchSize="100000"
transactionIsolation="TRANSACTION_READ_COMMITTED"
holdability="CLOSE_CURSORS_AT_COMMIT" />
<document>
<entity rootEntity="true" name="carte" dataSource=""
transformer="RegexTransformer"
query="select * from bi_solr_carte
inner join bi_solr_contrat on
bi_solr_carte.carte_id_contrat=bi_solr_contrat.contrat_id_contrat
inner join bi_solr_tiers on
bi_solr_contrat.contrat_id_client=bi_solr_tiers.tiers_id_client">
<field name="ID" column="carte_id" />
<field name="DOC_TYPE" column="carte_doc_type" />
<field name="ID_TYPE_SERVICE" column="contrat_id_type_service" />
<field name="ID_CONTRAT" column="contrat_id_contrat" />
<field name="ID_CONTRAT_CADRE" column="contrat_id_contrat_cadre" />
<field name="ID_STATUT_CONTRAT" column="contrat_id_statut_contrat" />
<field name="ID_PRODUIT" column="contrat_id_produit" />
<field name="NOM_PRODUIT" column="contrat_nom_produit" />
<field name="ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="ID_BENEFICIAIRE_HONO" column="contrat_id_beneficiaire_hono"
/>
<field name="ID_PAYEUR_CONSO" column="contrat_id_payeur_conso" />
<field name="ID_PAYEUR_HONO" column="contrat_id_payeur_hono" />
<field name="ID_PARTENAIRE" column="contrat_id_partenaire" />
<field name="NOM_PARTENAIRE" column="contrat_nom_partenaire" />
<field name="TYPE_PARTENAIRE" column="contrat_type_partenaire" />
<field name="ID_FILIALE" column="contrat_id_filiale" />
<field name="NOM_FILIALE" column="contrat_nom_filiale" />
<field name="COMPTE_WEB_POSSIBLE" column="contrat_compte_web_possible" />
<field name="REF_CONTRAT_TVA" column="contrat_ref_contrat_tva" />
<field name="PAYS_DEPOT_TVA" column="contrat_pays_depot_tva" />
<field name="ID_CLIENT" column="tiers_id_client" />
<field name="NOM_CLIENT" column="tiers_nom_client" />
<field name="ID_PARENT" column="tiers_id_parent" splitBy="," />
<field name="ID_PAYS_CLIENT" column="tiers_id_pays_client" />
<field name="ID_SEGMENT" column="tiers_id_segment" />
<field name="ID_SALE" column="tiers_id_sale" />
<field name="NOM_SALE" column="tiers_nom_sale" />
<field name="ID_CARTE" column="carte_id_carte" />
<field name="ID_COMMANDE" column="carte_id_commande" />
<field name="NUM_CARTE" column="carte_num_carte" />
<field name="DATE_DEB_CARTE" column="carte_date_deb_carte" />
<field name="DATE_FIN_CARTE" column="carte_date_fin_carte" />
<field name="CODE_OP_CARTE" column="carte_code_op_carte" />
<field name="NOM_OP_CARTE" column="carte_nom_op_carte" />
<field name="CARTE_ACTIVE" column="carte_carte_active" />
<field name="ID_VEHICULE" column="carte_id_vehicule" />
<field name="ID_FLOTTE" column="carte_id_flotte" />
<field name="IMMATRICULATION" column="carte_immatriculation" />
<field name="NORME_VEHICULE" column="carte_norme_vehicule" />
<field name="TYPE_VEHICULE" column="carte_type_vehicule" />
<field name="CLASSE_VEHICULE" column="carte_classe_vehicule" />
<field name="MEP_VEHICULE" column="carte_mep_vehicule" />
<field name="MARQUE_VEHICULE" column="carte_marque_vehicule" />
<field name="PAYS_VEHICULE" column="carte_pays_vehicule" />
<field name="NB_ESSIEUX_VEHICULE" column="carte_nb_essieux_vehicule" />
<field name="PTCA_VEHICULE" column="carte_ptca_vehicule" />
<field name="CHASSIS_VEHICULE" column="carte_chassis_vehicule" />
<field name="HAUTEUR_VEHICULE" column="carte_hauteur_vehicule" />
<field name="LONGUEUR_VEHICULE" column="carte_longueur_vehicule" />
<field name="LARGEUR_VEHICULE" column="carte_largeur_vehicule" />
<field name="PTRA_VEHICULE" column="carte_ptra_vehicule" />
<field name="NOM_FLOTTE" column="carte_nom_flotte" />
<field name="U_ID_TYPE_SERVICE" column="contrat_id_type_service" />
<field name="U_ID_CONTRAT" column="contrat_id_contrat" />
<field name="U_ID_CONTRAT_CADRE" column="contrat_id_contrat_cadre" />
<field name="U_ID_STATUT_CONTRAT" column="contrat_id_statut_contrat" />
<field name="U_ID_PRODUIT" column="contrat_id_produit" />
<field name="U_NOM_PRODUIT" column="contrat_nom_produit" />
<field name="U_ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="U_ID_BENEFICIAIRE_HONO"
column="contrat_id_beneficiaire_hono" />
<field name="U_ID_PAYEUR_CONSO" column="contrat_id_payeur_conso" />
<field name="U_ID_PAYEUR_HONO" column="contrat_id_payeur_hono" />
<field name="U_ID_PARTENAIRE" column="contrat_id_partenaire" />
<field name="U_NOM_PARTENAIRE" column="contrat_nom_partenaire" />
<field name="U_TYPE_PARTENAIRE" column="contrat_type_partenaire" />
<field name="U_ID_FILIALE" column="contrat_id_filiale" />
<field name="U_NOM_FILIALE" column="contrat_nom_filiale" />
<field name="U_COMPTE_WEB_POSSIBLE" column="contrat_compte_web_possible"
/>
<field name="U_REF_CONTRAT_TVA" column="contrat_ref_contrat_tva" />
<field name="U_PAYS_DEPOT_TVA" column="contrat_pays_depot_tva" />
<field name="U_ID_CLIENT" column="tiers_id_client" />
<field name="U_NOM_CLIENT" column="tiers_nom_client" />
<field name="U_ID_PARENT" column="tiers_id_parent" splitBy="," />
<field name="U_ID_PAYS_CLIENT" column="tiers_id_pays_client" />
<field name="U_ID_SEGMENT" column="tiers_id_segment" />
<field name="U_ID_SALE" column="tiers_id_sale" />
<field name="U_NOM_SALE" column="tiers_nom_sale" />
<field name="U_ID_CARTE" column="carte_id_carte" />
<field name="U_ID_COMMANDE" column="carte_id_commande" />
<field name="U_NUM_CARTE" column="carte_num_carte" />
<field name="U_DATE_DEB_CARTE" column="carte_date_deb_carte" />
<field name="U_DATE_FIN_CARTE" column="carte_date_fin_carte" />
<field name="U_CODE_OP_CARTE" column="carte_code_op_carte" />
<field name="U_NOM_OP_CARTE" column="carte_nom_op_carte" />
<field name="U_CARTE_ACTIVE" column="carte_carte_active" />
<field name="U_ID_VEHICULE" column="carte_id_vehicule" />
<field name="U_ID_FLOTTE" column="carte_id_flotte" />
<field name="U_IMMATRICULATION" column="carte_immatriculation" />
<field name="U_NORME_VEHICULE" column="carte_norme_vehicule" />
<field name="U_TYPE_VEHICULE" column="carte_type_vehicule" />
<field name="U_CLASSE_VEHICULE" column="carte_classe_vehicule" />
<field name="U_MEP_VEHICULE" column="carte_mep_vehicule" />
<field name="U_MARQUE_VEHICULE" column="carte_marque_vehicule" />
<field name="U_PAYS_VEHICULE" column="carte_pays_vehicule" />
<field name="U_NB_ESSIEUX_VEHICULE" column="carte_nb_essieux_vehicule" />
<field name="U_PTCA_VEHICULE" column="carte_ptca_vehicule" />
<field name="U_CHASSIS_VEHICULE" column="carte_chassis_vehicule" />
<field name="U_HAUTEUR_VEHICULE" column="carte_hauteur_vehicule" />
<field name="U_LONGUEUR_VEHICULE" column="carte_longueur_vehicule" />
<field name="U_LARGEUR_VEHICULE" column="carte_largeur_vehicule" />
<field name="U_PTRA_VEHICULE" column="carte_ptra_vehicule" />
<field name="U_NOM_FLOTTE" column="carte_nom_flotte" />
<entity name="carte_conso" dataSource=""
processor="CachedSqlEntityProcessor" cacheKey="conso_id_carte"
cacheLookup="carte.carte_id_carte"
query="select
conso_id_carte,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where conso_id_carte is not null
and (conso_type_transaction is null or conso_type_transaction !=
'1')">
<field name="NUM_CARTE" column="conso_numero_carte" />
<field name="IMMATRICULATION" column="conso_immatriculation" />
<field name="NOM_FLOTTE" column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso" />
<field name="NOM_GARE_ORIGINE" column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE" column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE" column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE" column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE" column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE" column="conso_sca_sortie" />
<field name="STATUT_CONSO" column="conso_statut" />
</entity>
<entity name="carte_conso_remise" dataSource=""
processor="CachedSqlEntityProcessor" cacheKey="conso_id_carte"
cacheLookup="carte.carte_id_carte"
query="select
conso_id_carte,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where conso_id_carte is not null
and conso_type_transaction != '3'">
<field name="NUM_CARTE" column="conso_numero_carte" />
<field name="IMMATRICULATION" column="conso_immatriculation" />
<field name="NOM_FLOTTE" column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso" />
<field name="NOM_GARE_ORIGINE" column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE" column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE" column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE" column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE" column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE" column="conso_sca_sortie" />
<field name="STATUT_CONSO" column="conso_statut" />
</entity>
<entity name="carte_invoice" dataSource=""
processor="CachedSqlEntityProcessor" cacheKey="conso_id_carte"
cacheLookup="carte.carte_id_carte"
query="select
invoice_numero_facture,
invoice_id_beneficiaire,
invoice_id_payeur,
invoice_date_emission,
invoice_date_emission_dd_mm_yyyy,
invoice_date_emission_mm_yyyy,
invoice_date_emission_yyyy,
invoice_devise,
invoice_total_ht,
invoice_total_tva,
invoice_total_ttc,
conso_id_carte
from bi_solr_invoice
inner join bi_solr_transaction on
invoice_numero_facture=conso_numero_facture
where conso_numero_facture is not null and conso_id_carte is not
null">
<field name="NUMERO_FACTURE" column="invoice_numero_facture" />
<field name="ID_BENEFICIAIRE" column="invoice_id_beneficiaire" />
<field name="ID_PAYEUR" column="invoice_id_payeur" />
<field name="DATE_EMISSION" column="invoice_date_emission" />
<field name="DATE_EMISSION_DD_MM_YYYY"
column="invoice_date_emission_dd_mm_yyyy" />
<field name="DATE_EMISSION_MM_YYYY"
column="invoice_date_emission_mm_yyyy" />
<field name="DATE_EMISSION_YYYY" column="invoice_date_emission_yyyy" />
<field name="DEVISE" column="invoice_devise" />
<field name="INVOICE_TOTAL_HT" column="invoice_total_ht" />
<field name="INVOICE_TOTAL_TVA" column="invoice_total_tva" />
<field name="INVOICE_TOTAL_TTC" column="invoice_total_ttc" />
</entity>
<entity name="carte_remise" dataSource="" cacheKey="remise_id_carte"
cacheLookup="carte.carte_id_carte" processor="CachedSqlEntityProcessor"
query="select
remise_id_carte,
remise_numero_carte,
remise_immatriculation,
remise_nom_flotte,
remise_id_remise,
remise_sca_entree
from bi_solr_remise where remise_id_carte is not null">
<field name="NUM_CARTE" column="remise_numero_carte" />
<field name="IMMATRICULATION" column="remise_immatriculation" />
<field name="NOM_FLOTTE" column="remise_nom_flotte" />
<field name="ID_REMISE" column="remise_id_remise" />
<field name="NOM_SCA_ORIGINE" column="remise_sca_entree" />
</entity>
</entity>
</document>
</dataConfig>
--
View this message in context: http://lucene.472066.n3.nabble.com/Many-mapping-files-tp4236658p4236951.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Many mapping files
Posted by Gora Mohanty <go...@mimirtech.com>.
On 27 October 2015 at 13:22, fabigol <fa...@vialtis.com> wrote:
> Hi,
> I already posted on my subject that helped me a lot. I recover a solr
> project but the person is gone.
> There are several configuration files / mapping (base / Solr)
> What interest do that?
> thanks for your help
Unfortunately, this question is too vague for any kind of reasonable
help. Your best bet probably is to get a basic familiarity with Solr.
There are books available, and the Wiki is a helpful resource. You
might want to start at https://wiki.apache.org/solr/ and go through
the tutorial linked therein. Many of the files will be explained that,
and once you have at least a basic understanding, please ask more
specific questions about specific configuration files on this list.
Regards,
Gora