Json Creation

Database
Teradata Employee

Re: Json Creation

Can we see the table definition and statistics?

Enthusiast

Re: Json Creation

got it .. its the profile spool which is less than the allocated spool .. dbc.diskspace has maxProfilespool which is what  i am hitting across all amps 

Enthusiast

Re: Json Creation

the derive table is multi table join with case statements. and i dont have rights to collect stats on the table.. else i would.. 

the only thing i can say is the derive table runs..  but this on top of derived table gives a spool error.. 

 

SELECT LocInBldgKey

--,OREPLACE(OTRANSLATE(OREPLACE( (JSON_AGG(AssnCd)(VARCHAR(5000))),'"AssnCd":','') , 'AssnCd[]{}"', 'AssnCd') ,'\','"')
--,OREPLACE((XMLAGG(AssnCd) (VARCHAR(4000))), ' "', ',"')
,(XMLAGG(AssnCd) (VARCHAR(4000)))

 

maybe i just need some more spool