Sir Chris Hoy has revealed his cancer diagnosis is terminal.