You are not doing anything wrong. I should have been more clear in my description of the workaround, sorry. It seems like what you want is CHAR comparison semantics, but Impala currently does not provide that directly. To avoid confusion, I'd recommend using the STRING type consistently. However, comparison of STRINGs are whitespace-sensitive, so you will have to work around that, e.g., by manually trimming the whitespace when doing comparisons. So in your example, you'd have to change your query to: select * from test where trim(c1) = 'ABC';
... View more
