Applying OLAP functions on hashrow applied column

Database
KVB
Enthusiast

Applying OLAP functions on hashrow applied column

Hi

I am using TD13.I am calculating uniqueness fo rows usinhhashrow functions and i need to store that value as varchar in another table to apppky OLAP functions.Since hashrow being BYTE, does not allow any conversion.I got strucked at that poin.

Is there any other way fo using that to have it like a varchar column.

1 REPLY
Enthusiast

Re: Applying OLAP functions on hashrow applied column

SELECT cast(HASHBUCKET(hashrow(1234,5))as varchar(10))

we can convert a byte datatype into an integer only using the hashbucket which can be later casted into a varchar.