[
https://issues.apache.org/jira/browse/SOLR-15467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17433273#comment-17433273
]
David Eric Pugh commented on SOLR-15467:
----------------------------------------
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: [email protected]
For additional commands, e-mail: [email protected]
