This was an early tune used with The Spirit of God (probably the first tune used with it). It was likely also used with Now Let Us Rejoice. Some suspect this tune is the same tune as Assembly; the tune Hosanna, however, has yet to be discovered in modern times, and so this remains a mystery.
There is a tune called Hosanna referenced in The Scottish Hymnal: Hymns for Public Worship, Selected by a Committee of the General Assembly of the Church of Scotland, 1884 by William Henry Monk. However, the poetic meter for it does not seem to match that of The Spirit of God.
The first-known publication date is 1844 (but the tune has been around since at least a certain temple dedication before that publication).