hey all! I have some datatype issues and wonder i...
# community-support
l
hey all! I have some datatype issues and wonder if you've seen this before and have a workaround. I have some spark workflows (in databricks) which return data with
decimal(28, 6)
which I would like to maintain, but then elemetary tries to convert it to float and has issues with values out of bound:
Copy code
[NUMERIC_VALUE_OUT_OF_RANGE.WITH_SUGGESTION]  float cannot be represented as Decimal(28, 6). If necessary set "ansi_mode" to "false" to bypass this error, and return NULL instead. SQLSTATE: 22003
  == SQL (line 48, position 95) ==
  ...e || ' value is ' || cast(round(cast(metric_value as decimal(28,6)), 3) as string) ||
                                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
if anyone has encountered this would like to know more, thanks! I am using Elementary version 0.18.3.
n
Hey @leo! Forwarding the question to #C08HW57FGN9 that will give a full answer based on the community history. Let me know if you need any further help!