That's what I was afraid of. I'm going through Cloudera Manager and looking at queries where missing_stats=true and going through one by one more or less. Thanks for the response!
... View more
Not helpful yet, but promising... PIVOT keyword is reserved for future use! https://www.cloudera.com/documentation/enterprise/6/6.2/topics/impala_reserved_words.html
... View more
Turned out to be pretty simple. Hadoop (or at least Hive) prefers two backslashes like \\d rather than \d. I ended up using this, which also requires one to four digits. [(]\\d{1,4}[)]$
... View more
