stream handler raw sql

[Kojo]

Hi,
I am making tests on the stream handler, but I am not sure whether it
was supposed to work or not.

When I test the following query:

192.168.1.100:8983/solr/my_collection/stream?expr=sql(stmt=SELECT
NON_DOC_VALUES_FIELD FROM my_collection)

I obtain the following exception:

{
  "result-set": {
    "docs": [
      {
        "EXCEPTION": "-->
http://172.18.0.4:8983/solr/my_collection_shard2_replica_n1/:Failed to
execute sqlQuery 'SELECT NON_DOC_VALUES_FIELD FROM my_collection'
against JDBC connection 'jdbc:calcitesolr:'.\nCaused by: Error while
executing SQL \"SELECT NON_DOC_VALUES_FIELD FROM my_collection\":
java.io.IOException: java.util.concurrent.ExecutionException:
java.io.IOException: -->
http://172.18.0.4:8983/solr:NON_DOC_VALUES_FIELD{type=text,properties=indexed,tokenized,stored,multiValued,sortMissingLast,uninvertible}
must have DocValues to use this feature.",
        "EOF": true,
        "RESPONSE_TIME": 36
      }
    ]
  }
}

When I test the following query:

192.168.1.100:8983/solr/my_collection/stream?expr=sql(stmt=SELECT
DOC_VALUES_FIELD FROM my_collection)

I obtain the following exception, which seems weird, because it is not
related to the DOC_VALUES_FIELD, but the _version_ field.

{
  "result-set": {
    "docs": [
      {
        "EXCEPTION": "-->
http://172.18.0.3:8983/solr/my_collection_shard1_replica_n4/:Failed to
execute sqlQuery 'SELECT DOC_VALUES_FIELD FROM my_collection' against
JDBC connection 'jdbc:calcitesolr:'.\nCaused by: Error while executing
SQL \"SELECT DOC_VALUES_FIELD FROM my_collection\":
java.io.IOException: java.util.concurrent.ExecutionException:
java.io.IOException: -->
http://172.18.0.4:8983/solr:_version_{type=long,properties=indexed,stored,omitNorms,omitTermFreqAndPositions,uninvertible}
must have DocValues to use this feature.",
        "EOF": true,
        "RESPONSE_TIME": 59
      }
    ]
  }
}



Does the second one should work? Is there a way to use raw SQL in a SE?

I know about the sql handler but I would like to obtain more complex
results using SE.

Thank you,
Koji