Re: Combine SQL and Text Query

2016-09-01 Thread WhiteAncient
Ok. Thank you very much for the response. I hoped that I just hadn't found
the way.

Too bad though, since that will very much limit the usability of TextSearch
in my case where the sql-parts really filters down the result-set.

tors 1 sep. 2016 kl 13:11 skrev vdpyatkov [via Apache Ignite Users] <
ml-node+s70518n7456...@n6.nabble.com>:

> Hello,
>
> If you specify type on IndexTypes property[1] SQL will be work, but
> without indexes.
> The resume field do not be visible from SQL.
>
> Text query do not work together with SQL.
>
>
> [1]:
> https://apacheignite.readme.io/docs/sql-queries#configuring-sql-indexes-by-annotations
>
> On Thu, Sep 1, 2016 at 1:43 PM, WhiteAncient <[hidden email]
> > wrote:
>
>> If I have the classic POJO
>>
>> class Person{
>> @QuerySqlField
>> private String genotype;
>>
>> @QueryTextField
>> private String resume;
>> }
>>
>> How do I query "where genotype = 'male' and resume like '%Hello%'" so that
>> it hits the lucene index?
>>
>>
>>
>> --
>> View this message in context:
>> http://apache-ignite-users.70518.x6.nabble.com/Combine-SQL-and-Text-Query-tp7455.html
>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>
>
>
>
> --
> Vladislav Pyatkov
>
>
> --
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-ignite-users.70518.x6.nabble.com/Combine-SQL-and-Text-Query-tp7455p7456.html
> To unsubscribe from Combine SQL and Text Query, click here
> 
> .
> NAML
> 
>




--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Combine-SQL-and-Text-Query-tp7455p7457.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Combine SQL and Text Query

2016-09-01 Thread Vladislav Pyatkov
Hello,

If you specify type on IndexTypes property[1] SQL will be work, but without
indexes.
The resume field do not be visible from SQL.

Text query do not work together with SQL.


[1]:
https://apacheignite.readme.io/docs/sql-queries#configuring-sql-indexes-by-annotations

On Thu, Sep 1, 2016 at 1:43 PM, WhiteAncient  wrote:

> If I have the classic POJO
>
> class Person{
> @QuerySqlField
> private String genotype;
>
> @QueryTextField
> private String resume;
> }
>
> How do I query "where genotype = 'male' and resume like '%Hello%'" so that
> it hits the lucene index?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Combine-SQL-and-Text-Query-tp7455.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Vladislav Pyatkov