[jira] [Commented] (SOLR-8847) SolrJ JDBC - Implement "Select *"

["Kevin Risden (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SOLR-8847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15193727#comment-15193727 ] 

Kevin Risden commented on SOLR-8847:
------------------------------------

Just some notes on the topic. Currently the Schema API supports getting the schema, but this won't get dynamic fields that are present in the collection. ie: *_i will come back but mycount_i will not. There are a few workarounds for this, but nothing that seems well supported.
1) use the luke request handler
2) use csv wt and headers to get back the columns.
Both of these were provided to a stackoverflow answer previously: http://stackoverflow.com/questions/3211139/solr-retrieve-field-names-from-a-solr-index

> SolrJ JDBC - Implement "Select *" 
> ----------------------------------
>
>                 Key: SOLR-8847
>                 URL: https://issues.apache.org/jira/browse/SOLR-8847
>             Project: Solr
>          Issue Type: Sub-task
>          Components: SolrJ
>    Affects Versions: master
>            Reporter: Trey Cahill
>
> The sql query "Select *" is commonly used, but currently all fields need to be specified.  This can cause some troubles as "Select *" has been used to pull back column metadata in some JDBC clients.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org