Decimal() is not JSON serializable error in Hue for DbQuery - CDH 5.4.3/Hue 3.7

[rockssk]

Hi,

I access MySQL tables via DBQuery option in Hue. Selec statement on  tables with Decimal type are failing with the exception given below. 

Please help fix this

ENV:

CDH 5.4.3

Hue 3.7

MySQL : Server version: 5.5.11 MySQL Community Server (GPL)

Error : Server error occured: Decimal('-5.000000000') is not JSON serializable

MySQL Column : | Amount          | decimal(30,9) | YES  |     | NULL    |       |

 

[Romain Rigaux]

Yes, we would need to update

https://github.com/cloudera/hue/blob/master/apps/rdbms/src/rdbms/api.py#L48

and text serialize it if it is an instance of Decimal.

We will have a patch shortly

--
You received this message because you are subscribed to the Google Groups "Hue-Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

[Suresh Kumar Sethuramaswamy]

Thanks Romain

How do I text serialize it?

[Romain Rigaux]

We will have this pushed soon: https://review.cloudera.org/r/6715/