How to do this in Elasticsearch?

I am coming from Solr, new to Elasticsearch.

The following snippet is from Solr entity.xm. How to do same kind of
requirement in Elasticsearch? Means, based on an ID, get some fields from a
different table and insert in to the document.

<entity name="poll_details" dataSource="vign" transformer=
"ClobTransformer,RegexTransformer"

   query="select HEAD_POLL_ID, HEAD_POLL_TITLE,PUBLISHED_DATE from 

fox_poll where id= '${vign-poll.VCMID}'">

    <field column="HEAD_POLL_ID" name="secondary_id" />

    <field column="HEAD_POLL_TITLE" name="title" />

    <field column="PUBLISHED_DATE" name="date" />

    </entity>

I am very new to ES, I knew only that I can call a sql which creating an
index:

"sql" : "select * from furl_table"

--
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 elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

You will want to look into the JDBC River plugin:

Thanks,
Matt Weber

On Fri, May 17, 2013 at 2:57 PM, Srinivas Nalluri nallurisrini@gmail.comwrote:

I am coming from Solr, new to Elasticsearch.

The following snippet is from Solr entity.xm. How to do same kind of
requirement in Elasticsearch? Means, based on an ID, get some fields from a
different table and insert in to the document.

<entity name="poll_details" dataSource="vign" transformer=
"ClobTransformer,RegexTransformer"

   query="select HEAD_POLL_ID, HEAD_POLL_TITLE,PUBLISHED_DATE from

fox_poll where id= '${vign-poll.VCMID}'">

    <field column="HEAD_POLL_ID" name="secondary_id" />

    <field column="HEAD_POLL_TITLE" name="title" />

    <field column="PUBLISHED_DATE" name="date" />

    </entity>

I am very new to ES, I knew only that I can call a sql which creating an
index:

"sql" : "select * from furl_table"

--
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 elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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 elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.