[IBM][Hive JDBC Driver] SemanticException [Error 10004]
Moderators: chulett, rschirm, roy
Just fishing here but is it actually the case statement that is the issue? It seems to think your string assignment inside it is a table alias or a column reference. Perhaps a test might help clarify the issue... in your shoes I'd try another case statement but with it using actual column references rather than strings. That might help determine where to go next.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers