Thanks Joel! On Wed, Apr 5, 2017 at 6:30 PM, Joel Bernstein <joels...@gmail.com> wrote:
> Joins are not supported yet. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Wed, Apr 5, 2017 at 12:14 PM, Jordi Domingo Borràs < > jordi.domi...@gmail.com> wrote: > > > Hi! > > > > I don't know if I'm missing something. I did a simple join query asking > for > > one column in each table. The result contains the same column from the > > right table. (I read about it in the streaming expressions). > > > > curl --data-urlencode 'stmt=select t1.type AS type1, t2.type AS type2 > from > > iocs t1 join iocs2 t2 on (t1.ip=t2.ip) limit 1' > > http://localhost:8983/solr/iocs/sql > > > > > > {"result-set":{"docs":[{"type2":"BOT_IP","type2":"BOT_ > > IP"},{"EOF":true,"RESPONSE_TIME":555}]}} > > > > Thanks for your help, > > Jordi > > >