Hi Jens, The queries look correct. If you try indexing some small amount of file content through the same output connection (using, say, the Filesystem connector), do you see the same thing? I would bet so; if that's the case, something is clearly wrong with either how your elasticsearch connector is configured, or there's a bug.
Karl On Fri, Sep 19, 2014 at 3:26 AM, Jens Jahnke <[email protected]> wrote: > Hi, > > I'm new to manifold and I try to index some stuff from a mysql db via > jdbc into an elasticsearch index. > > So far I've used the simple mapping example from the user docs for > elasticsearch and I've the following query for data collection: > > SELECT id AS $(IDCOLUMN), > CONCAT("http://my.base.url/show.html?record=";, id) AS $(URLCOLUMN), > CONCAT(name, " ", description, " ", what_ever) AS $(DATACOLUMN) > FROM accounts WHERE id IN $(IDLIST) > > If I run the indexing job the data is fetched from the db and stored > into elasticsearch. But I've noticed 2 things: > > 1. The actual content field in the mapping is base64 encoded and > therefore not searchable? > > 2. If I do a base64decode on the content field then I see that it the > value from URLCOLUMN but not the one from DATACOLUMN. > > Can anyone shed some light on this? > > Regards, > > Jens > > -- > 19. Scheiding 2014, 09:15 > Homepage : http://www.wegtam.com > > Integrity has no need for rules. >
