[teiid-issues] [JBoss JIRA] (TEIID-5688) groupby functionality not working with Teiid

[Christoph John (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Christoph John updated TEIID-5688:
----------------------------------
    Description: 
Hello together,
I tried to get the distinct values of a certain column in a mysql table and used the following query 

https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdProductCode&$apply=groupby((fkIdProductCode))&$format=json

However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:

{
@odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDiaryEntry,fkIdProductCode)",
value: [
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
idDiaryEntry: 17,
fkIdProductCode: 17
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
idDiaryEntry: 18,
fkIdProductCode: 38
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
idDiaryEntry: 19,
fkIdProductCode: 482
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
idDiaryEntry: 20,
fkIdProductCode: 1564
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
idDiaryEntry: 21,
fkIdProductCode: 17
}
]
}

So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?

 Thans for your help

  was:
Hello together,
I tried to get the distinct values of a certain column in a mysql table and used the following query 

https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdProductCode&$apply=groupby((fkIdProductCode))&$format=json

However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:

{
@odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDiaryEntry,fkIdProductCode)",
value: [
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
idDiaryEntry: 17,
fkIdProductCode: 17
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
idDiaryEntry: 18,
fkIdProductCode: 38
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
idDiaryEntry: 19,
fkIdProductCode: 482
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
idDiaryEntry: 20,
fkIdProductCode: 1564
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
idDiaryEntry: 21,
fkIdProductCode: 17
}
]
}



> groupby functionality not working with Teiid
> --------------------------------------------
>
>                 Key: TEIID-5688
>                 URL: https://issues.jboss.org/browse/TEIID-5688
>             Project: Teiid
>          Issue Type: Bug
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Major
>
> Hello together,
> I tried to get the distinct values of a certain column in a mysql table and used the following query 
> https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdProductCode&$apply=groupby((fkIdProductCode))&$format=json
> However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
> {
> @odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDiaryEntry,fkIdProductCode)",
> value: [
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
> idDiaryEntry: 17,
> fkIdProductCode: 17
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
> idDiaryEntry: 18,
> fkIdProductCode: 38
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
> idDiaryEntry: 19,
> fkIdProductCode: 482
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
> idDiaryEntry: 20,
> fkIdProductCode: 1564
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
> idDiaryEntry: 21,
> fkIdProductCode: 17
> }
> ]
> }
> So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
>  Thans for your help



--
This message was sent by Atlassian Jira
(v7.12.1#712002)