User:TJones (WMF)/Notes/TextCat Optimization for frwiki eswiki itwiki and dewiki/HQL

The Hive query for frwiki (adapted from relevanceForge/misc/fulltextQueriesSample.hql) is here: