Does "_nest_path_" come back in a normal search? I would expect that the fields that are returned by normal searches would also work in SQL. If that turns out to be the case you could derive the fields from performing a search and seeing what fields are returned.
Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Jan 23, 2020 at 3:02 PM Nick Vercammen <nick.vercam...@zeticon.com> wrote: > Hey All, > > is there a way to get a list of all fields in a collection that can be used > in an SQL query? Currently I retrieve a list of fields through the schema > api: GET col/schema/fields. > > This returns all fields in a collection. But when I do a select on all > fields I get an exception because apparently _nest_path_ is no column in > the collection table: > > Failed to execute sqlQuery 'SELECT films._text_ AS text, films._nest_path_ > FROM films LIMIT 2000' against JDBC connection 'jdbc:calcitesolr:'. > Error while executing SQL "SELECT films._text_ AS text, films._nest_path_ > FROM films LIMIT 2000": From line 1, column 37 to line 1, column 47: Column > '_nest_path_' not found in table 'films' > > Can I determine which fields can be used in a SQL query? By means of the > type? > > kind regards, > > Nick >
