military advisor vs consultant

military advisor and consultant both are nouns.

Word	Noun	Adjective	Verb	Adverb
military advisor	Yes	No	No	No
consultant	Yes	No	No	No

As nouns, consultant is a hypernym of military advisor; that is, consultant is a word with a broader meaning than military advisor:

military advisor: a military officer who serves as an adviser to the troops of an allied nation
consultant: an expert who gives advice

Other hypernyms of military advisor include adviser, advisor, military officer, officer.

military advisor (noun)	consultant (noun)
a military officer who serves as an adviser to the troops of an allied nation	an expert who gives advice