lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafael Taboada <kaliman.fore...@gmail.com>
Subject Re: Data Import Handler fields with different values in column and name
Date Fri, 01 Jun 2012 16:19:59 GMT
Hi!

I think it works but using alias with Oracle database....

<entity name="documento" query="SELECT iddocumento,nrodocumento,asunto as
asunto1,autor FROM documento">
            <field column="iddocumento" name="iddocumento" />
            <field column="nrodocumento" name="nrodocumento" />
            <field column="asunto1" name="asunto1" />
            <field column="autor" name="autor" />
</entity>

Am i wrong with this??? Anyone tried DIH with Oracle?

Thanks for your help



On Fri, Jun 1, 2012 at 10:34 AM, Jack Krupansky <jack@basetechnology.com>wrote:

> James: Is there some particular DIH logging he can turn on to see what is
> really happening with his field name mapping? In other words, if DIH/Solr
> really is ignoring that field mapping, to find out exactly why.
>
> -- Jack Krupansky
>
> -----Original Message----- From: Dyer, James
> Sent: Friday, June 01, 2012 10:50 AM
> To: solr-user@lucene.apache.org
> Subject: RE: Data Import Handler fields with different values in column
> and name
>
>
> Are you leaving both mappings in there, like this...
>
> <entity name="documento" query="SELECT iddocumento,nrodocumento,**asunto
> FROM documento">
> <field column="iddocumento" name="iddocumento" />
> <field column="nrodocumento" name="nrodocumento" />
> <field column="asunto" name="asunto" />
> <field column="asunto" name="anotherasunto" />
> </entity>
>
> If so, I'm not sure you can map "asunto" to two different fields like
> this. For that, you may need to write a transformer that will duplicate
> "asunto" for you.  Although, in most cases all you need to do is add a
> <copyField /> in schema.xml to copy "asunto" to "anotherasunto".  But a DIH
> Transformer would be helpful, for instance, if "asunto" is multi-valued but
> you only want to copy the first value to "anotherasunto" (perhaps you need
> to sort on it, which is not possible with multi-valued fields).
>
> If this doesn't help, let us know exactly why you need to duplicate
> "asunto" and maybe you can get more help from there.
>
> (If you're not trying to duplicate "asunto" and you're sure you've taken
> the duplicate out of data-config.xml, then go ahead and double-check
> spelling and case in all your config files.  Besides a typo somewhere, I'm
> not sure what else would cause this not to map.)
>
> James Dyer
> E-Commerce Systems
> Ingram Content Group
> (615) 213-4311
>
>
> -----Original Message-----
> From: Rafael Taboada [mailto:kaliman.forever@gmail.**com<kaliman.forever@gmail.com>
> ]
> Sent: Thursday, May 31, 2012 4:13 PM
> To: solr-user@lucene.apache.org
> Subject: Fwd: Data Import Handler fields with different values in column
> and name
>
> Please,
>
> Can anyone guide me through this issue? Thanks
>
>
>
> ---------- Forwarded message ----------
> From: Rafael Taboada <kaliman.forever@gmail.com>
> Date: Thu, May 31, 2012 at 12:30 PM
> Subject: Data Import Handler fields with different values in column and
> name
> To: solr-user@lucene.apache.org
>
>
> Hi folks,
>
> I'm using Solr 3.6 and I'm trying to import data from my database to solr
> using Data Import Handler. My db-config is like this:
>
> <dataConfig>
>  <dataSource driver="oracle.jdbc.**OracleDriver"
> url="jdbc:oracle:thin:@**localhost:1521:XE" user="admin" password="admin"
> />
>  <document>
>     <entity name="documento" query="SELECT
> iddocumento,nrodocumento,**asunto FROM documento">
>        <field column="iddocumento" name="iddocumento" />
>        <field column="nrodocumento" name="nrodocumento" />
>        <field column="asunto" name="asunto" />
>     </entity>
>  </document>
> </dataConfig>
>
> My problem is when I'm trying to use a different values in the field tag,
> for example
>
>        <field column="asunto" name="anotherasunto" />
>
> When I use different name from column, this field is omitted. Please can
> you help me with this issue?
>
> My schema.xml is:
>
> <types>
>     <fieldtype name="string" class="solr.StrField" sortMissingLast="true"
> />
>  </types>
>
>  <fields>
>     <!-- general -->
>     <field name="iddocumento" type="string" indexed="true" stored="true"
> required="true" />
>     <field name="nrodocumento" type="string" indexed="true" stored="true"
> />
>     <field name="anotherasunto" type="string" indexed="true"
> stored="true" />
>  </fields>
>
> Thanks in advance!
>
> --
> Rafael Taboada
>
>
>
>
>
>
> --
> Rafael Taboada
>
> /*
> * Phone >> 992 741 026
> */
>



-- 
Rafael Taboada

/*
 * Phone >> 992 741 026
 */

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message