query json from embedded py
Hello,
I am trying to query a table with a JSON field with a loopback query in embedded python. I get this error: SQL Query Failed: MALException:pyapi.eval:Unsupported SQL Type: son
Is JSON not supported? Do I have to store the JSON object as a string in case I want to query it from python?
Thank you,
Stefano
Hey Stefano,
Not all SQL types are supported for conversion to Python Objects; right now the only types that are supported are strings, numeric types, decimals and date/date time objects. JSON objects are not currently supported, so you would indeed need to store them as strings.
Regards,
Mark
----- Original Message ----- From: "Stefano Fioravanzo" fioravanzos@gmail.com To: "users-list" users-list@monetdb.org Sent: Wednesday, June 1, 2016 2:28:55 PM Subject: query json from embedded py
Hello,
I am trying to query a table with a JSON field with a loopback query in embedded python. I get this error: SQL Query Failed: MALException:pyapi.eval:Unsupported SQL Type: son
Is JSON not supported? Do I have to store the JSON object as a string in case I want to query it from python?
Thank you,
Stefano _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Mark Raasveldt
-
Stefano Fioravanzo