The term "to hallow" is to be understood here not primarily in its causative sense (only God hallows, makes holy), but above all in an evaluative sense: to recognize as holy, to treat in a holy way. And so, in adoration, this invocation is sometimes understood as praise and thanksgiving. But this petition is here taught to us by Jesus as an optative: a petition, a desire, and an expectation in which God and man are involved. Beginning with this first petition to our Father, we are immersed in the innermost mystery of his Godhead and the drama of the salvation of our humanity. Asking the Father that his name be made holy draws us into his plan of loving kindness for the fullness of time, "according to his purpose which he set forth in Christ," that we might "be holy and blameless before him in love."
Source: Catechism of the Catholic Church (Vatican.va)