in Gaelic "Chi mi na mor-bheanna" (literally "I will see the great mountains"), it is a Scottish slow air which sounds wonderful on the pipes. The tune was a favorite of King George VI and was played at his funeral, and it was similarly played as a lament for President John F. Kennedy’s funeral. The original Gaelic words were written in 1856 by John Cameron of Ballachulish, Scotland.
I don't remember when I first heard this, probably for a funeral, but I know it was played on Highland pipes. I looked up the print version later.