lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Noble Paul നോബിള്‍ नोब्ळ् <noble.p...@corp.aol.com>
Subject Re: Bug with DIH and MySQL CONCAT()?
Date Wed, 04 Nov 2009 16:44:45 GMT
Thanks,
It would be nice to add this to the DIH FAQ

On Wed, Nov 4, 2009 at 8:27 PM, Jonathan Hendler
<jonathan.hendler@gmail.com> wrote:
> Thanks Chantal for the explanation of the issue.
> Avlesh - worked great. Thank you!
>
>
> On Nov 4, 2009, at 9:44 AM, Avlesh Singh wrote:
>
>> Try cast(concat(...) as char) ...
>>
>> Cheers
>> Avlesh
>>
>> On Wed, Nov 4, 2009 at 7:36 PM, Jonathan Hendler
>> <jonathan.hendler@gmail.com
>>>
>>> wrote:
>>
>>> Hi All,
>>>
>>> I have an SQL query that begins with "SELECT CONCAT (  'ID', Subject.id
>>>  ,
>>> ':' , Subject.name , ':L', Subject.level) as subject_name" and the query
>>> runs great against MySQL from the command line.
>>> Since this is a nested entity, the schema.xml contains "<field
>>> name="subject_name" type="string" indexed="true" stored="true"
>>> multiValued="true" />"
>>>
>>> After a full-import, a select output of the xml looks like
>>>
>>> "<arr name="subject_name">
>>> <str>[B@1db4c43</str>
>>> <str>[B@6bcef1</str>
>>> <str>[B@1df503b</str>
>>> <str>[B@c5dbb</str>
>>> <str>[B@1ddc3ea</str>
>>> <str>[B@6963b0</str>
>>> <str>[B@10fe215</str>
>>> ...
>>> "
>>>
>>> Without a CONCAT - it works fine.
>>>
>>> Is this a bug?
>>>
>>> Meanwhile - should I go about concatenating some where else in the DIH
>>> config?
>>>
>>> Thanks.
>>>
>>> - Jonathan
>>>
>>>
>>>
>
>



-- 
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com

Mime
View raw message