[
https://issues.apache.org/jira/browse/SOLR-8002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15094614#comment-15094614
]
Joel Bernstein edited comment on SOLR-8002 at 1/12/16 7:38 PM:
---------------------------------------------------------------
Patch with full alias support and tests. Aliases are supported for *columns*
and *functions* and can be used in GROUP BY, ORDER BY and HAVING clauses.
Aliases are not supported in the WHERE clause which is consistent with the SQL
spec.
was (Author: joel.bernstein):
Patch with full alias support and tests. Aliases are supported for columns and
functions and can be used in GROUP BY, ORDER BY and HAVING clauses.
Aliases are not supported in the WHERE clause as this which is consistent with
the SQL spec.
> Add field 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
>
>
> 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]
