In glue Schema, Partition key expects similar Data type for all partitions, to pass set expression in GetPartitions api ?

[Sach1nAgarwal]

After running the glue crawler, it generates schema, when all partition_key in the generated schema have same data type,
then get_partitions api after set_expression passes,
If any one partition_key have different data type in schema, then after setting set_expression, get_partitions api throwing an error "InvalidInputException"

Is this expected behavior or not?

[Sach1nAgarwal]

If let suppose two partitions are there in schema:-

Column name | Data Type

   c1         int
   c2        float

GetPartitions fails, if setting expression ( c1 > 20 ) .

Now if change data type of c2 to int or bigint or char, get partition passes.

[jmklix]

I'm still a little confused about what you are asking. Can you provide more details and maybe a code snipet that gives you the "invalideInputException"

You can also check out GetPartition details here

[Sach1nAgarwal]

@jmklix
It is GetPartitions.
Corrected the heading.

If we do set_expression( tinyint > 20) then GetPartitions give "invalidInputException",
Now if I change Data Type of Column name float, from float to int, then GetPartitions gives correct results.