sqlalchemy - group_by with json field attribute

Asked Oct 29 '18 at 14:34

Active Oct 30 '18 at 11:35

Viewed 734 times

I want aggregated results from my table and I want to aggregate based on an attribute in a json field.

I tried:

channel_raw = db.session.query(
    Chathistory2.meta_json['channel'],
    func.sum(Chathistory2.id).label('sum')
    ).filter().group_by(Chathistory2.meta_json['channel']).all()

Error:

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) could not identify an equality operator for type json

Is it not possible to group by an attribute from a json field?

Thanks in advance.

edited Oct 30 '18 at 11:35

Ilja Everilä

45,748
6
100
105

asked Oct 29 '18 at 14:34

caliph

1,209
2
22
45

Related: https://stackoverflow.com/questions/30519458/group-by-in-postgres-no-equality-for-json-data-type – Ilja Everilä Oct 30 '18 at 11:36
@caliph can you add a few data rows into question and expected result? – Danila Ganchar Oct 31 '18 at 11:40

sqlalchemy - group_by with json field attribute

0 Answers0