You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "David Eric Pugh (Jira)" <ji...@apache.org> on 2021/10/23 12:10:00 UTC
[jira] [Comment Edited] (SOLR-15467) Enhance Parallel SQL
documentation (new operators, limitations, and so on ...)
[ https://issues.apache.org/jira/browse/SOLR-15467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17433273#comment-17433273 ]
David Eric Pugh edited comment on SOLR-15467 at 10/23/21, 12:09 PM:
--------------------------------------------------------------------
I started looking at this Jira today...
I gave the first command "SELECT manu as mfr, price as retail FROM techproducts" a try, using the SQL screen in Solr Admin, and it blew up ;-(
Failed to execute sqlQuery 'SELECT manu as mfr, price as retail FROM techproducts' against JDBC connection 'jdbc:calcitesolr:'. Caused by: Error while executing SQL "SELECT manu as mfr, price as retail FROM techproducts": java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: --> [http://localhost:8983/solr:manu\|http://localhost:8983/solr:manu]{type=text_gen_sort,properties=indexed,tokenized,stored,omitNorms,docValues,uninvertible} Must have useDocValuesAsStored='true' to be used with export writer
was (Author: epugh):
I started looking at this Jira today...
I gave the first command "SELECT manu as mfr, price as retail FROM techproducts" a try, using the SQL screen in Solr Admin, and it blew up ;-(
Failed to execute sqlQuery 'SELECT manu as mfr, price as retail FROM techproducts' against JDBC connection 'jdbc:calcitesolr:'. Caused by: Error while executing SQL "SELECT manu as mfr, price as retail FROM techproducts": java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: --> http://localhost:8983/solr:manu\{type=text_gen_sort,properties=indexed,tokenized,stored,omitNorms,docValues,uninvertible} Must have useDocValuesAsStored='true' to be used with export writer
I guess I'll open another Jira about potentially makign these commands run "out of the box"... ;)
> Enhance Parallel SQL documentation (new operators, limitations, and so on ...)
> ------------------------------------------------------------------------------
>
> Key: SOLR-15467
> URL: https://issues.apache.org/jira/browse/SOLR-15467
> Project: Solr
> Issue Type: Task
> Components: documentation
> Affects Versions: 7.7.1, 8.6.1, 8.8.1
> Reporter: Aroop
> Assignee: David Eric Pugh
> Priority: Minor
> Labels: RobustSQL
>
> In the ref guide sections for Parallel SQL, the section on Supported where clauses seems to have a bug. The LIKE operator does not work at all.
>
> [https://solr.apache.org/guide/8_0/parallel-sql-interface.html#supported-where-operators]
>
> {code:java}
> A simplistic LIKE can be used with a wildcard, such as field = 'sam*'.
> {code}
> This may be fixed with little effort, but maybe we want to correct the documentation till then to avoid user confusion.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org