On Mar 5, 2012, at 1:16 PM, Welty, Richard wrote:
> Walter Underwood [mailto:wun...@wunderwood.org] writes:
>
>> You may be able to have unique keys. At Netflix, I found that there were
>> collisions between >the movie IDs and the person IDs. So, I put an 'm' at
>> the beginning of each movie ID and a >'p' at the beginning of each person
>> ID. Like magic, I had unique IDs.
>
> did you do this with a transformer at index time, or in some other manner?
I had custom code for indexing; this was in Solr 1.3.
SQL should be able to do this, though it might not be portable. For MySQL is it
something like:
select
concat('m', movie_id) as id,
...
wunder
--
Walter Underwood
wun...@wunderwood.org
