Does anybody know whether the entire Apache Calcite SQL dialect is supported by SolrCloud?
cheers
1 Answers
0
votes
Solr does not support all the operations available in the SQL dialect, as they're not easily implemented or in some cases, maybe not possible in an effective manner in a document search engine context (i.e. Solr has no current support for anything similar to UPDATE collection SET foo = bar WHERE field = 'baz').
For reference you can see how Solr handles different keywords and syntax in the Solr SQL syntax page in the reference guide.
Among other limitations, one is that Solr's JDBC interface is currently not handling other types than string very well.
