The mail is hard to read, the layout is scrambled. For simple integer array, you do not need type "nested".
What is the SQL statement you tried for JDBC river? You have seen the examples for bracket notation? Jörg On Mon, Oct 6, 2014 at 2:04 PM, <[email protected]> wrote: > Hi All, > > I have a scenario like, I need to build an index with four fields > (Generic Description,GenericId ,GroupNo, List of Catalogsids ). > > Here is sample example of mysql table. > > Generic Description GenericId GroupNo > List of Catalogsids FrameKit > 1 35 10,20,24,56,78,90,87 Pulley 3480 23 36 Bypass Pulley > 4133 7 55 > > > > The fourth column in above table field contains multiple values for one > row. Now i want to create index using above mysql table via river > concept so that fourth column in the table sholud be represented as array > in elastic search i tried this concept but i am not getting a good way to > solve this.please help me in this. > > Mapping i used: > > PUT /temp > { > "mappings": { > "tempv1" : { > "properties" : { > "GenericDescription" : {"type" : "string"}, > "GenericId" : {"type" : "string"}, > "GroupNo" : {"type" : "string"}, > "descriptionids" : { > "type" : "nested", > "properties" : { > "ListofDescriptionIDs" : {"type" : "integer"} > } > } > } > } > } > } > > Thanks in advance. > phani srinivas > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/c81e61d2-c73d-42f9-82ac-86ced59f7316%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/c81e61d2-c73d-42f9-82ac-86ced59f7316%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGw8M0vxkrQGcWhLL_UcRNc71t554UYr5tdYZOvs6rD-w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
