Re: case insensitive string equality

2011-02-04 Thread Jamie Cockrill
Amlan, In: http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#String_Functions It looks like you could use 'RLIKE' to achieve what you're after if you make a case-insensitive java regular expression. Thanks, Jamie On 4

Re: Can't drop table

2011-01-17 Thread Jamie Cockrill
Hi all, We use postgres as a metastore for Hive and haven't come across any problems. The postgres driver jar is: postgresql-8.4.701-jdbc.jar. We use the version of hive that comes out of Cloudera's CDH3b2, which I believe is some variant of Hive 0.5.0. Java: HotSpot 1.6.0_20 OS: Ubuntu Lucid (10