[ https://issues.apache.org/jira/browse/SOLR-8002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14736174#comment-14736174 ]
Susheel Kumar edited comment on SOLR-8002 at 9/9/15 5:03 AM: ------------------------------------------------------------- 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 Solr Streaming expression 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 was (Author: susheel2...@gmail.com): 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: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org