I want to get values for the remaining rows as the same as in row 38 (in the picture attached ) for null values but I can not achieve this with this query. since I need a string representation for downstream. I need to convert this value into a string and hive doesn't allow to convert decimals more than 38 character I also added an image description.
select service_group, cast(cast(b.pownr as decimal(38, 0)) as VARCHAR(42)) br from(
SELECT service_group, binary_representation, concat('1.0E',(row_number() over())-1) as pownr
FROM ***db.service_group_mapping) as b LIMIT 100;
