Test Result : HivePartitionFilteringSuite

0 failures (±0)
39 tests (±0)
Took 27 sec.

All Tests

Test nameDurationStatus
3.1: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false18 secPassed
3.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))0.19 secPassed
3.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)0.18 secPassed
3.1: getPartitionsByFilter: 20170101=ds0.12 secPassed
3.1: getPartitionsByFilter: IS NULL / IS NOT NULL0.14 secPassed
3.1: getPartitionsByFilter: IS NULL / IS NOT NULL with other filter0.12 secPassed
3.1: getPartitionsByFilter: In(d, 2019-01-01, 2019-01-02)0.13 secPassed
3.1: getPartitionsByFilter: InSet(d, 2019-01-01, 2019-01-02)78 msPassed
3.1: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)0.1 secPassed
3.1: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)0.12 secPassed
3.1: getPartitionsByFilter: cast(datestr as date)= 2020-01-0173 msPassed
3.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)96 msPassed
3.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)97 msPassed
3.1: getPartitionsByFilter: cast(ds as long)=20170101L and h=275 msPassed
3.1: getPartitionsByFilter: chunk contains bb0.86 secPassed
3.1: getPartitionsByFilter: chunk endsWith b1.2 secPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)0.16 secPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)81 msPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') and ((cast(ds as string)>'20170102')0.15 secPassed
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))0.2 secPassed
3.1: getPartitionsByFilter: chunk startsWith b1.4 secPassed
3.1: getPartitionsByFilter: chunk='aa'0.16 secPassed
3.1: getPartitionsByFilter: d <=> 2019-01-0169 msPassed
3.1: getPartitionsByFilter: d <=> null68 msPassed
3.1: getPartitionsByFilter: d =!= 2019-01-010.12 secPassed
3.1: getPartitionsByFilter: d =!= 2019-01-01 || IS NULL74 msPassed
3.1: getPartitionsByFilter: d=2019-01-010.12 secPassed
3.1: getPartitionsByFilter: d>2019-01-020.11 secPassed
3.1: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)0.16 secPassed
3.1: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)0.1 secPassed
3.1: getPartitionsByFilter: ds<=>201701010.52 secPassed
3.1: getPartitionsByFilter: ds<>201701010.1 secPassed
3.1: getPartitionsByFilter: ds=(20170101 + 1) and h=00.17 secPassed
3.1: getPartitionsByFilter: ds=201701010.28 secPassed
3.1: getPartitionsByFilter: ds=20170101 and h=20.22 secPassed
3.1: getPartitionsByFilter: ds=20170101 or ds=201701020.2 secPassed
3.1: getPartitionsByFilter: h<>0 and chunk<>ab and d<>2019-01-010.36 secPassed
3.1: getPartitionsByFilter: not in/inset date type0.29 secPassed
3.1: getPartitionsByFilter: not in/inset string type0.39 secPassed