Depends on your process chain to the eventual viewer/consumer of the data.
The questions to ask are:
A/ Is the data IN Solr going to be viewed or processed in its original form:
-->set stored = 'true'
--->no serialization needed.
B/ If it's going to be anayzed and searched for separate from any other
field,
the analyzing will put it into an unreadable form. If you need to see
it,
then
--->set indexed="true" and stored="true"
--->no serializaton needed. C/ If it's NOT going to be viewed AS IS, and
it's not going to be searched for AS IS,
(i.e. other columns will be how the data is found), and you have
another,
serialzable format:
-->set indexed="false" and stored="true"
-->serialize AS PER THE INTENDED APPLICATION,
not sure that Solr can do that at all.
C/ If it's NOT going to be viewed AS IS, and it's not going to be searched
for
AS IS,
(i.e. other columns will be how the data is found), and you have
another,
serialzable format:
-->set indexed="false" and stored="true"
-->serialize AS PER THE INTENDED APPLICATION,
not sure that Solr can do that at all.
D/ If it's NOT going to be viewed AS IS, BUT it's going to be searched for AS
IS,
(this column will be how the data is found), and you have another,
serialzable format:
-->you need to put it into TWO columns
-->A SERIALIZED FIELD
-->set indexed="false" and stored="true"
-->>AN UNSERIALIZED FIELD
-->set indexed="false" and stored="true"
-->serialize AS PER THE INTENDED APPLICATION,
not sure that Solr can do that at all.
Hope that helps!
Dennis Gearon
Signature Warning
----------------
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from others’ mistakes, so you do not have to make them yourself.
from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036'
EARTH has a Right To Life,
otherwise we all die.
----- Original Message ----
From: Papp Richard <ccode...@gmail.com>
To: solr-user@lucene.apache.org
Sent: Sun, January 23, 2011 2:02:05 PM
Subject: DIH serialize
Hi all,
I wasted the last few hours trying to serialize some column values (from
mysql) into a Solr column, but I just can't find such a function. I'll use
the value in PHP - I don't know if it is possible to serialize in PHP style
at all. This is what I tried and works with a given factor:
in schema.xml:
<field name="main_timetable" type="text" indexed="false"
stored="true" multiValued="true" />
in DIH xml:
<dataConfig>
<script><![CDATA[
function my_serialize(row)
{
row.put('main_timetable', row.toString());
return row;
}
]]></script>
.
<entity name="main_timetable" query="
SELECT * FROM shop_time_table stt WHERE stt.shop_id = '${shop.id}';"
transformer="script:my_serialize"
>
.
>
Can I use java directly in script (<script language="Java">) ?
How could I achieve this? Or any other idea?
I need these values together (from a row) and I need then in PHP to handle
the result easily.
thanks,
Rich
