I want to query against one user_id in the string.

eg  user_id:2002+AND+created:[${from}+TO+${until}]+data:"more"

So all of the records with a 2002 in user_id need to be returned and only
those records.  If this can only be guaranteed by having user_id be an
integer, then that is fine, but I would like to reduce the growth of our
table.

*Row X*
>
> column1: "data here"
> column2: "more data here"
> ...
> user_id: 2002
>
> *Row Y*
>
> column1: "data here"
> column2: "more data here"
> ...
> user_id: 45
>
> *Row Z*
>
> column1: "data here"
> column2: "more data here"
> ...
> user_id: 45664
>
> So what I plan on doing before inserting into mysql, which is where solr
> pulls the data from, is shrinking similar datasets into one row:
>
> *Single Row XYZ*
>
> column1: "data here"
> column2: "more data here"
> ...
> user_id: "2002 45 45664"
>

Reply via email to