[teiid-issues] [JBoss JIRA] (TEIID-4572) Grouping by and faceted search for Solr tranlator

[Amr Ismail (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13373371#comment-13373371 ] 

Amr Ismail edited comment on TEIID-4572 at 3/6/17 10:27 AM:
------------------------------------------------------------

Handling group by clause in Teiid Solr translator module

Teiid Solr translator neglects grouping in Teiid query. We modified it to accept grouping and count(*) function in select clause. Furthermore, we support grouping by date field using PARSETIMESTAMP(FORMATTIMESTAMP('dateField', 'dateFormat'), 'dateFormat') Teiid function with these gap values: minute, hour, day, month and year according to dateFormat. For example, if dateFormat="yyyy-MM-dd" then gap=1DAY and if dateFormat="yyyy-MM-dd HH" then gap=1HOUR. 

We developed some test cases in calss "TestTeiidLanguageGroupingToSolr" to test grouping by single field, by multiple fields and by date ranges combined with other fields.

Please refer to the "TestTeiidLanguageGroupingToSolr" class to see more examples





was (Author: amr_alaa):
Handling group by clause in Teiid Solr translator module

Teiid Solr translator neglects grouping in Teiid query. We modified it to accept grouping and count(*) function in select clause. Furthermore, we support grouping by date field using PARSETIMESTAMP(FORMATTIMESTAMP('dateField', 'dateFormat'), 'dateFormat') Teiid function with these gap values: minute, hour, day, month and year according to dateFormat. For example, if dateFormat="yyyy-MM-dd" then gap=1DAY and if dateFormat="yyyy-MM-dd HH" then gap=1HOUR. 

We developed some test cases in calss "TestTeiidLanguageGroupingToSolr" to test grouping by single field, by multiple fields and by date ranges combined with other fields.

Please refer to the "TestTeiidLanguageGroupingToSolr" class to see more examples



> Grouping by and faceted search for Solr tranlator
> -------------------------------------------------
>
>                 Key: TEIID-4572
>                 URL: https://issues.jboss.org/browse/TEIID-4572
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Hend Amin
>             Fix For: Open To Community
>
>
> Currently group by is not supported for Solr translator. For example:
> select x,y, count\(*) from solr_core group by x,y; the corresponding Solr request does not contain group by. 
> Please add group by and faceted search support for Solr translator.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)