Cannot perform UNION of two queries one projecting an INT32 and the other INT64

1

The following query attempt to union queries projecting an INT32 and an INT64, which many systems support.

Server 4.9.3-202010281843560195-edc49b6d
Driver 4.9.1-202010230218060541-2e764ed0

select tint.cint from dbcert.tint union select tbint.cbint from dbcert.tbint

DATA_READ ERROR: Unable to complete query, attempting to union two datasets that have different underlying schemas. Left: schema(cint::int32), Right: schema(cbint::int64)

2

@dqmdev

That is correct, we currently do not support the union of int and bigint

Thanks
Bali

3

The documentation needs to be improved.

Such a scenario is supported across many SQL engines, so seems to be a fundamental design limitation.

1 Like
4

Same issue in Dremio 14

5

@dqmdev

This has not been addressed yet, I have given feedback on docs to the concerned team