[ https://issues.jboss.org/browse/TEIID-4572?page=com.atlassian.jira.plugin... ] 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 -- This message was sent by Atlassian JIRA (v7.2.3#72005)