SQL handler throws exception if WHERE clause is present
>
> Hello,
>
> I was, finally, trying the SQL handler on one of our collections. Executing a
> SELECT * FROM logs LIMIT 10 runs fine, but restricting the set using a WHERE
> clause gives me the exception below. The type f
Hello,
I was, finally, trying the SQL handler on one of our collections. Executing a
SELECT * FROM logs LIMIT 10 runs fine, but restricting the set using a WHERE
clause gives me the exception below. The type field is a String type, indexed
and has DocValues.
I must be doing something wrong
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
Fi
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
ying
> the sql, I'm not using anything related to the nested format (except that
> the data itself was indexed this way)
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Simple-sql-query-with-where-clause-doesn-t-work-tp4324498p4324499.html
> Sent from the Solr - User mailing list archive at Nabble.com.
in context:
http://lucene.472066.n3.nabble.com/Simple-sql-query-with-where-clause-doesn-t-work-tp4324498p4324499.html
Sent from the Solr - User mailing list archive at Nabble.com.
xt:
http://lucene.472066.n3.nabble.com/Simple-sql-query-with-where-clause-doesn-t-work-tp4324498.html
Sent from the Solr - User mailing list archive at Nabble.com.
On Wed, Dec 21, 2011 at 4:58 PM, ayyappan wrote:
> In the information search in DB, the query has to be based on customer
> specific. Is it possible to change “where” clause value in select query
> based on the user who logged in.
It is not clear what you are asking here? Which "wh
