Postgres/Vertica and their ilk have ILIKE which is a case-insensitive
version of LIKE, in addition to the case-sensitive LIKE. Works well having
both.
Cheers,
Anthony
On Fri, May 24, 2013 at 8:58 AM, Edward Capriolo wrote:
> It is not as simple of a problem as you think. Mysql has the same prob
Your shell is expanding the variable ${env:freq}, which doesn't exist in
the shell's environment, so hive is getting the empty string in that place.
If you are always intending to run your query like this, just use ${freq}
which will be expanded as expected by bash and then passed to hive.
Cheers
I am getting an exception when joining two tables with Amazon's Hive
0.8.1 on Amazon EMR, and I've run out of ideas on how to fix it.
The query is something along the lines of
Q1: SELECT count(*) FROM t1 x JOIN t2 y ON (x.id = y.x_id);
Which ends up throwing an exception like this in some of the
