Thanks, It would be nice to add this to the DIH FAQ On Wed, Nov 4, 2009 at 8:27 PM, Jonathan Hendler <jonathan.hend...@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.hend...@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>[...@1db4c43</str> >>> <str>[...@6bcef1</str> >>> <str>[...@1df503b</str> >>> <str>[...@c5dbb</str> >>> <str>[...@1ddc3ea</str> >>> <str>[...@6963b0</str> >>> <str>[...@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
