Test Result : HivePartitionFilteringSuite

0 failures (±0)
37 tests (±0)
Took 44 sec.

All Tests

Test nameDurationStatus
3.1: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false29 secPassed
3.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))0.29 secPassed
3.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)0.35 secPassed
3.1: getPartitionsByFilter: 20170101=ds0.24 secPassed
3.1: getPartitionsByFilter: IS NULL / IS NOT NULL0.18 secPassed
3.1: getPartitionsByFilter: IS NULL / IS NOT NULL with other filter0.18 secPassed
3.1: getPartitionsByFilter: In(d, 2019-01-01, 2019-01-02)0.26 secPassed
3.1: getPartitionsByFilter: InSet(d, 2019-01-01, 2019-01-02)0.1 secPassed
3.1: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)0.14 secPassed
3.1: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)0.18 secPassed
3.1: getPartitionsByFilter: cast(datestr as date)= 2020-01-010.38 secPassed
3.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)0.12 secPassed
3.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)0.11 secPassed
3.1: getPartitionsByFilter: cast(ds as long)=20170101L and h=20.12 secPassed
3.1: getPartitionsByFilter: chunk contains bb1.4 secPassed
3.1: getPartitionsByFilter: chunk endsWith b1.8 secPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)0.33 secPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)0.11 secPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') and ((cast(ds as string)>'20170102')89 msPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))0.42 secPassed
3.1: getPartitionsByFilter: chunk startsWith b2.2 secPassed
3.1: getPartitionsByFilter: chunk='aa'0.55 secPassed
3.1: getPartitionsByFilter: d <=> 2019-01-0187 msPassed
3.1: getPartitionsByFilter: d <=> null88 msPassed
3.1: getPartitionsByFilter: d =!= 2019-01-010.26 secPassed
3.1: getPartitionsByFilter: d =!= 2019-01-01 || IS NULL99 msPassed
3.1: getPartitionsByFilter: d=2019-01-010.19 secPassed
3.1: getPartitionsByFilter: d>2019-01-020.16 secPassed
3.1: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)0.49 secPassed
3.1: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)0.16 secPassed
3.1: getPartitionsByFilter: ds<=>201701011 secPassed
3.1: getPartitionsByFilter: ds<>201701010.16 secPassed
3.1: getPartitionsByFilter: ds=(20170101 + 1) and h=00.44 secPassed
3.1: getPartitionsByFilter: ds=201701010.72 secPassed
3.1: getPartitionsByFilter: ds=20170101 and h=20.42 secPassed
3.1: getPartitionsByFilter: ds=20170101 or ds=201701020.36 secPassed
3.1: getPartitionsByFilter: h<>0 and chunk<>ab and d<>2019-01-010.46 secPassed