[
https://issues.apache.org/jira/browse/SOLR-8002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14736174#comment-14736174
]
Susheel Kumar commented on SOLR-8002:
-------------------------------------
Hi Joel, Davis,
Just to clarify that utilizing the SelectStream in SQL api (SQLHandler.java)
would require transforming the SQL expression into SOLR streaming expressions
for SelectStream to work. So for e.g. SQL expression
select id, field_i, str_s from collection1 where text='XXXX' order by field_i
desc
would be transformed to
search(collection1, q="text:XXXX", fl="id,field_i,str_s", sort="field_i desc")
Please let me know your thoughts on this.
Thanks,
Susheel
> Field aliases support for SQL queries
> -------------------------------------
>
> 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
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
