xinghuayu007 commented on issue #4805: URL: https://github.com/apache/incubator-doris/issues/4805#issuecomment-717663446
> why must cast the int to date type? > > in my idea, i think this the type cast problem, so the problem is what is the type should the cast the int to, > > so just cast the int to the type of the partition key type, > > and i also doubt that why scan the all partion. > > myabe this is the right flow , > > 1, we should know that the condition key has the partion key, and get the info from the catalog Yes, this is the problem of type-casting. In current system, sql like select * from table where date in (20201030); date is type of DATE; date and 20201030 will be casted to DOUBLE type. That is not corret. I think the invalid type should be found in Analyze Phase, not be found in phase of 'Pruning Partitions'. This problem will not cause to scan all partitions. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
