org.apache.spark.sql.hive.client.HivePartitionFilteringSuite

0.14: create client with sharesHadoopClasses = false
0.14: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false
0.14: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))
0.14: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)
0.14: getPartitionsByFilter: 20170101=ds
0.14: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)
0.14: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)
0.14: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)
0.14: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)
0.14: getPartitionsByFilter: cast(ds as long)=20170101L and h=2
0.14: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)
0.14: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)
0.14: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))
0.14: getPartitionsByFilter: chunk='aa'
0.14: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)
0.14: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)
0.14: getPartitionsByFilter: ds<=>20170101
0.14: getPartitionsByFilter: ds=(20170101 + 1) and h=0
0.14: getPartitionsByFilter: ds=20170101
0.14: getPartitionsByFilter: ds=20170101 and h=2
0.14: getPartitionsByFilter: ds=20170101 or ds=20170102
1.0: create client with sharesHadoopClasses = false
1.0: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false
1.0: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))
1.0: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)
1.0: getPartitionsByFilter: 20170101=ds
1.0: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)
1.0: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)
1.0: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)
1.0: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)
1.0: getPartitionsByFilter: cast(ds as long)=20170101L and h=2
1.0: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)
1.0: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)
1.0: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))
1.0: getPartitionsByFilter: chunk='aa'
1.0: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)
1.0: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)
1.0: getPartitionsByFilter: ds<=>20170101
1.0: getPartitionsByFilter: ds=(20170101 + 1) and h=0
1.0: getPartitionsByFilter: ds=20170101
1.0: getPartitionsByFilter: ds=20170101 and h=2
1.0: getPartitionsByFilter: ds=20170101 or ds=20170102
1.2: create client with sharesHadoopClasses = false
1.2: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false
1.2: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))
1.2: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)
1.2: getPartitionsByFilter: 20170101=ds
1.2: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)
1.2: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)
1.2: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)
1.2: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)
1.2: getPartitionsByFilter: cast(ds as long)=20170101L and h=2
1.2: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)
1.2: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)
1.2: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))
1.2: getPartitionsByFilter: chunk='aa'
1.2: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)
1.2: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)
1.2: getPartitionsByFilter: ds<=>20170101
1.2: getPartitionsByFilter: ds=(20170101 + 1) and h=0
1.2: getPartitionsByFilter: ds=20170101
1.2: getPartitionsByFilter: ds=20170101 and h=2
1.2: getPartitionsByFilter: ds=20170101 or ds=20170102
2.1: create client with sharesHadoopClasses = false
2.1: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false
2.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))
2.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)
2.1: getPartitionsByFilter: 20170101=ds
2.1: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)
2.1: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)
2.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)
2.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)
2.1: getPartitionsByFilter: cast(ds as long)=20170101L and h=2
2.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)
2.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)
2.1: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))
2.1: getPartitionsByFilter: chunk='aa'
2.1: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)
2.1: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)
2.1: getPartitionsByFilter: ds<=>20170101
2.1: getPartitionsByFilter: ds=(20170101 + 1) and h=0
2.1: getPartitionsByFilter: ds=20170101
2.1: getPartitionsByFilter: ds=20170101 and h=2
2.1: getPartitionsByFilter: ds=20170101 or ds=20170102
2.3: create client with sharesHadoopClasses = false
2.3: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false
2.3: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))
2.3: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)
2.3: getPartitionsByFilter: 20170101=ds
2.3: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)
2.3: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)
2.3: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)
2.3: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)
2.3: getPartitionsByFilter: cast(ds as long)=20170101L and h=2
2.3: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)
2.3: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)
2.3: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))
2.3: getPartitionsByFilter: chunk='aa'
2.3: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)
2.3: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)
2.3: getPartitionsByFilter: ds<=>20170101
2.3: getPartitionsByFilter: ds=(20170101 + 1) and h=0
2.3: getPartitionsByFilter: ds=20170101
2.3: getPartitionsByFilter: ds=20170101 and h=2
2.3: getPartitionsByFilter: ds=20170101 or ds=20170102
3.1: create client with sharesHadoopClasses = false
3.1: getPartitionsByFilter returns all partitions when hive.metastore.try.direct.sql=false
3.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<(1+1))
3.1: getPartitionsByFilter: (ds=20170101 and h>=2) or (ds=20170102 and h<2)
3.1: getPartitionsByFilter: 20170101=ds
3.1: getPartitionsByFilter: cast(chunk as boolean)=true (not a valid partition predicate)
3.1: getPartitionsByFilter: cast(chunk as int)=1 (not a valid partition predicate)
3.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using IN expression)
3.1: getPartitionsByFilter: cast(ds as long) in (20170102L, 20170103L) (using INSET expression)
3.1: getPartitionsByFilter: cast(ds as long)=20170101L and h=2
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using IN expression)
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') (using INSET expression)
3.1: getPartitionsByFilter: chunk in ('ab', 'ba') and ((ds=20170101 and h>=2) or (ds=20170102 and h<2))
3.1: getPartitionsByFilter: chunk='aa'
3.1: getPartitionsByFilter: ds in (20170102, 20170103) (using IN expression)
3.1: getPartitionsByFilter: ds in (20170102, 20170103) (using INSET expression)
3.1: getPartitionsByFilter: ds<=>20170101
3.1: getPartitionsByFilter: ds=(20170101 + 1) and h=0
3.1: getPartitionsByFilter: ds=20170101
3.1: getPartitionsByFilter: ds=20170101 and h=2
3.1: getPartitionsByFilter: ds=20170101 or ds=20170102