Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALAO
Hi Guys, I am new to the Solr world and I am using Solr 5.4.1. I have a question and hope to find answer to the same. Consider a SQL query as: select A, sum(B), sum(C) from Col1 where D = ‘Test’ group by A *having sum(B) > 20* order by A limit 100 I am able to translate the above

Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALO
Hi Guys, I am new to the Solr world and I am using Solr 5.4.1. I have a question and hope to find answer to the same. Consider a SQL query as: select A, sum(B), sum(C) from Col1 where D = ‘Test’ group by A having sum(B) > 20 order by A limit 100 I am able to translate the above to Solr Query p

Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALAO
Hi Guys, I am new to the Solr world and I am using Solr 5.4.1. I have a question and hope to find answer to the same. Consider a SQL query as: select A, sum(B), sum(C) from Col1 where D = ‘Test’ group by A *having sum(B) > 20* order by A limit 100 I am able to translate the above