So I haven't looked at this in a few years, but the columns should be
registered in the SQL catalog so you should be able to ask via SQL for all
the columns.
describe table or using the JDBC metadata should work.
There may be some edge cases where depending on sharding you get into a
case where
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
