When attacking a base with an Archer Queen, you need to make sure to take other units besides your tanks to take out the queen. If you are taking Giants, generally you want take some wizards or a pekka to come behind them and clear out the buildings as the Giants are tanking for them. You can use a poison spell to slow the attack speed of the Archer Queen, and a heal spell to keep your Giants alive till the other troops can kill the queen. I generally don't have much trouble with the queen when using Giants.
For hogs, you rarely want to use full hogs against a th9+. If you are wanting to use hogs, you should look to be using gohowi (golems, wizards , hogs) or similar type attack strategy. Send in the golem and wizards with earthquake spells, a jump spell, or some wall breakers to get into the middle of the base and take out the queen. The hogs are then used to take out point defenses while your golems are tanking the damage. Consider looking at OneHive Raids YouTube channel for attack strategy tutorials.