Hey Travis, You should never get an exception. Difference in behavior will be whether filter got pushed from Pig into HCat or not, but that should not affect correctness. Can you paste the stack trace that you are getting?
Ashutosh On Tue, Mar 13, 2012 at 11:14, Travis Crawford <[email protected]>wrote: > Hey HCat gurus - > > I'm having an issue getting range filters working and am curious if what > I'm trying to do makes sense. When filtering for explicit partitions (even > multiple explicit partitions) things work as expected. However, when > requesting a range it fails with a TTransportException. > > data = LOAD 'db.table' USING org.apache.hcatalog.pig.HCatLoader(); > > -- filter statements that work > f = FILTER data BY part_dt == '20120313T000000Z'; > f = FILTER data BY part_dt == '20120313T000000Z' > OR part_dt == '20120313T010000Z'; > > -- filter statements that do not work > f = FILTER data BY part_dt >= '20120313T000000Z'; > f = FILTER data BY part_dt >= '20120313T000000Z' > AND part_dt < '20120313T010000Z'; > > When things are working correctly would you expect all four of these filter > statements to be valid? > > Thanks! > Travis >
