Which version of Solr are you working with? Solr 6.5 has different SQL
engine the 6.0 through 6.4. Also what are field types you are working with
in the where clause?
Here is SQL query from the test cases in 6.4:
select id, Field_i, Str_s from Collection1 where Text_t='' order by
Field_i desc"
Did you find answer I getting same error when I use text instead of number in
Where clause - Please let me know.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Simple-sql-query-with-where-clause-doesn-t-work-tp4324498p4328991.html
Sent from the Solr - User mailing list arch
This has really nothing to do with SQL. What's happening is that the
query doesn't think you're specifying a field and it's looking for
_text_ which will be defined in your solrconfig file with a "df"
parameter for the query handler.
That said, the query appears malformed or it's a cut/paste error
Seems like this only happend when the value is not a number
curl --data-urlencode 'stmt=select fieldA from collection where field='123''
http://host:port/solr/collection/sql?aggregationMode=facet
works.
while this one doesnt work:
curl --data-urlencode 'stmt=select fieldA from collection where
