How to query on json data ?

ashu123

hello,
I was loaded json data into flex table

when i fetched days,it shows like this

how to in query on data array ??
ex: select maptostring(days=4) from testing_view ;

ERROR 4286: Operator does not exist: long varbinary = int
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts

How to query on this please provide a solution
Thanks in advance

ashu123

I got the solution

select id from testing where mapcontainsvalue(__raw__['days'],'2')='t' ;

this will give u exact id's which 2 value contains

ashu123

plz provide solution i need that query #Jim_Knicely

Jim_Knicely

Maybe the MAPITEMS function can help?

dbadmin=> select maptostring(days) from testing_view;
                                    maptostring
    ---------------------------------------------------------------------------
     {
       "0" : "3",
       "1" : "4",
       "2" : "5",
       "3" : "2",
       "4" : "3"
    }

     {
       "0" : "1",
       "1" : "2",
       "2" : "3",
       "3" : "1",
       "4" : "3"
    }

    (2 rows)

dbadmin=> select values from (select mapitems(days) over(partition best)from testing_view) foo where keys = 4;
 values
--------
 3
 3
(2 rows)

dbadmin=> select values from (select mapitems(days) over(partition best)from testing_view) foo where keys = 0;
 values
--------
 3
 1
(2 rows)