Group by on column in Flex tables, with nested json

vishnu777

I have loaded below Json to a flex table

Need to write query with group by based on group id with count.

i tried different combinations of Maplookup, but failed.

any suggestions ?

 

1 .CREATE flex table chat_mont()

 

2. COPY chat_mont from local '/home/XXXXX/trim_rep.json' parser fjsonparser()"

 

{
    "numFound": 483,
    "start": 0,
    "Groups": [{
        "GroupID": "7234234234234234",
        "LocationID": "10004119",
                 
        ***
        
        "GroupID": "9234234234234234",
        "LocationID": "10004119",
        
        ***
        
        "GroupID": "840375620221478683",
        "LocationID": "10004119",
        
        ***
                
        "GroupID": "7234234234234234",
        "LocationID": "10004119",
        
        ***
        
        "GroupID": "340375620221478684",
        "LocationID": "10004119",
        
        }]
        
}