There is no supertype for types Int64, UInt64

[javiererrogarcia]

Hello we are facing the next issue in our tableau dashboards, do you know some workaround or fix?

There is no supertype for types Int64, UInt64 because some of them are signed integers and some are unsigned integers, but there is no signed integer type, that can exactly represent all required unsigned integer values: While processing multiIf((((toYear(AT_DT_FLIGHT) * 100) + MONTH(AT_DT_FLIGHT))

Thank you in advance, we love your connector!

[yurifal]

Hi @javiererrogarcia

There's no support of UInt64 and above (as Whole Numbers) in Tableau.
Casting to String (to be counted uniques or grouped by) seems a workaround imho.
This is what our connector is doing by default.

If you'd like to cast to different type (for ex FLOAT), you could do it
in the connection dialog --> Advanced tab --> JDBC Driver typeMappings

[javiererrogarcia]

Hello, we have implemented in JDBC Driver TypeMappings as you said but we still have the exact error

Do you know any workaround?

Thank you in advance

[yurifal]

Hi @javiererrogarcia

Could you please try

Int64=java.lang.String,UInt64=java.lang.String

and see if this could help?

FYI This could be relevant to your issue (imho):
ClickHouse/ClickHouse#21794