You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by WhiteAncient <jo...@gmail.com> on 2016/09/01 10:43:26 UTC
Combine SQL and Text Query
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.
Re: Combine SQL and Text Query
Posted by WhiteAncient <jo...@gmail.com>.
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+s70518n7456h84@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]
> <http:///user/SendEmail.jtp?type=node&node=7456&i=0>> 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
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=7455&code=am9uYXNvbWF0aWNAZ21haWwuY29tfDc0NTV8LTEwNjYwNjE0OTk=>
> .
> NAML
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.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
Posted by Vladislav Pyatkov <vl...@gmail.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 <jo...@gmail.com> 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