You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Jordi Domingo Borràs <jo...@gmail.com> on 2017/04/05 16:14:21 UTC
SQL with join column mismatch
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
Re: SQL with join column mismatch
Posted by Jordi Domingo Borràs <jo...@gmail.com>.
Thanks Joel!
On Wed, Apr 5, 2017 at 6:30 PM, Joel Bernstein <jo...@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.domingo@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
> >
>
Re: SQL with join column mismatch
Posted by Joel Bernstein <jo...@gmail.com>.
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.domingo@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
>