[14:09:23] who wants to answer a minor mysql/hive query syntax question at 10am on a sunday? [14:29:36] wait, solved it [14:29:38] six months ago [14:29:40] and wrote it up [14:29:50] and then forgot it existed, googled it and my writeup was the first entry >.>