The vote on adding a JSON canonical extension type [1] got me wondering: Is it possible to define an extension type that is based on a canonical extension type? If so, how?
For example, say I wanted to define a (non-canonical) HLLSKETCH extension type that corresponds to the type that Redshift uses for HyperLogLog sketches and is represented as JSON [2]. Is there a way to do this by building on the JSON canonical extension type? [1] https://lists.apache.org/thread/4dw3dnz6rjp5wz2240mn299p51d5tvtq [2] https://docs.aws.amazon.com/redshift/latest/dg/r_HLLSKTECH_type.html Ian
