Cannot load filter Error: ORA-00979: not a GROUP BY expression about superset HOT 18 OPEN

@mistercrunch
@villebro
@michael-s-molina
@betodealmeida

Can you help me, I have not been able to solve it for several weeks

from superset.

I faced this problem with superset oracle connection. There is a connection with oracle and there is data, but there is this error in the filter, this process happened after connecting to oracle postres, this problem is not there, because it is the superset settings or the queries are wrong?

from superset.

Hi @mujohiddin. Oracle does not support GROUP BY 1. I believe you are using a virtual dataset? If that's the case, just replace GROUP BY 1 with GROUP BY "CODE".

from superset.

@michael-s-molina
but 5 months ago version didn't have this error, I got this error when upgrading to new version.

from superset.

@michael-s-molina GROUP BY 1 with GROUP BY "CODE".
I could not find this part, can you tell me where to replace it

from superset.

I could not find this part, can you tell me where to replace it

1 - Go to the filter configuration
2 - Check what's the dataset that's being used for the filter
3 - Go to the datasets list and check if that dataset is a virtual dataset
4 - If it is, you can edit its query

from superset.

@michael-s-molina ,
I followed the steps what you suggested, but there problem is not in the dataset. The above query was generated by Superset itself on filter pane. I think issue is with SQLA dialect, because the source was change to Postgre, it works, since Postgre supports Group BY 1, but Oracle does not. Therefore I am guesing it is due to SQLA dialect on newer version of Superset.

Moreover, I cannot create Table, Pivot charts , they are failling with the same error :

from superset.

The above query was generated by Superset itself on filter pane. I think issue is with SQLA dialect, because the source was change to Postgre, it works, since Postgre supports Group BY 1, but Oracle does not.

@rusackas @betodealmeida Does any of you have an Oracle instance to test this? Or do you know who's the Oracle dialect maintainer?

from superset.

@mujohiddin Can you also share what was the previous version where this was working?

from superset.

@michael-s-molina

1. I don't remember the exact version, it was about 6 months ago,
   It works successfully with postgre, clickhouse, oracle
2. The last new superset I installed recently was 1 month before the project
   in this case there is a problem with oracle

from superset.

Sadly, I don't know of anyone with Oracle. It's still on the wish list in the rolodex, if anyone on this thread would be kind enough to sign up.

from superset.

how can i detect the old superset version, 0.0.dev is the same in the interface

@mistercrunch
@villebro
@michael-s-molina
@betodealmeida
@john-bodley

from superset.

I have also faced this issue with Oracle,
any updates @rusackas , @michael-s-molina , @mistercrunch ?
Any workaround applied ? @mujohiddin

from superset.

i have old version working with oracle but i have problems in new version, do i need to add some parts from old version or some scprits? exactly in which python file or class is this generation process taking place. If you tell me that, I will send it to you, and we will compare the status of the two versions

@mistercrunch
@villebro
@michael-s-molina
@betodealmeida
@john-bodley
@rusackas

from superset.

I have also faced this issue with Oracle, any updates @rusackas , @michael-s-molina , @mistercrunch ? Any workaround applied ? @mujohiddin

No, the solution has not been found yet. I am waiting for a response from contributions

from superset.