A New Zealand television host whose comments about an Indian official sparked a diplomatic protest of racism from India has resigned from his job.