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
