[
https://issues.apache.org/jira/browse/SOLR-8002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15095528#comment-15095528
]
Dennis Gove commented on SOLR-8002:
-----------------------------------
I think this is one of those situations where what one almost always sees in a
JDBC implementation can actually be reversed. Normally in a JDBC implementation
when someone asks for a value via columnName that name will be translated to a
columnIdx and that index will be used to lookup the actual value. But because
values are keyed by columnName in the tuple I think it could just be reversed
where when asking for a value by columnIndex the index could be translated to
the columnName and that name used to lookup the actual value.
This removes the need to depend on order of the fields in the tuple.
> Add column alias support to the Parallel SQL Interface
> -------------------------------------------------------
>
> Key: SOLR-8002
> URL: https://issues.apache.org/jira/browse/SOLR-8002
> Project: Solr
> Issue Type: New Feature
> Components: search
> Affects Versions: Trunk
> Reporter: Susheel Kumar
> Assignee: Joel Bernstein
> Fix For: 6.0
>
> Attachments: SOLR-8002.patch, SOLR-8002.patch
>
>
> Currently field aliases are not supported for SQL queries against SQL
> Handler. E.g. below SQL query
> select id,name as product_name from techproducts limit 20
> currently fails as data returned contains still "name" as the field/column
> key than product_name
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
