Hi All,
I am having an use case where I want to index a json field from mysql into
solr. The Json field will contain entries as key value pairs. The Json can
be nested, but I want to index only the first level field value pairs of
Jsons into solr keys and nested levels can be present as value of
corresponding field in solr.
Eg)
{
"k1":"value1",
"k2":"value2",
"k3":{
"f1":"fv1",
"f2":"fv2"
},
"k4":[
"v1",
"v2",
"v3",
"v4"
]
}
The above Json is present as value for a mysql field. Along with this field,
I have few other fields in mysql like id, timestamp etc.
Considering this, can I import this data from mysql to solr and map fields
like,
Mysql_fields => solr_fields
id => id
timestamp => timestamp
k1 => k1
k2 => k2
k3 => k3 ( Type "text" field and it will contain this Json
k4 => k4 ( Type "text" with multivalued=true)?
Can this be achieved? I have used simplistic data import to import data from
mysql to solr, not for these complicated use cases. Also I would like to use
that timestamp field for constructing my delta import query.
Thanks,
Sriram
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-mysql-Json-import-tp4278686.html
Sent from the Solr - User mailing list archive at Nabble.com.
