[GitHub] [incubator-doris] wuyunfeng commented on issue #3559: [Doris on ES] unix_timestamp(date_format(now(), '%Y-%m-%d')) not push down

[GitBox]

wuyunfeng commented on issue #3559:
URL: 
https://github.com/apache/incubator-doris/issues/3559#issuecomment-645837038


   @blackfox1983 
   I think maybe the reason maybe is Data-Type is different with  
unix_timestamp(date_format(now(), '%Y-%m-%d')),
   I just create a table:
   
   ```
   
   CREATE EXTERNAL TABLE `fucntion_push` (
     `k1` bigint COMMENT "",
      `k2`  date COMMENT ""
   ) ENGINE=ELASTICSEARCH
   ```
   create a mapped index in es:
   
   ```
   PUT function_push
   {
      "settings": {
         "index": {
            "number_of_shards": "1",
            "number_of_replicas": "0"
         }
      },
      "mappings": {
         "doc": {
            "properties": {
               "k1": {
                  "type": "long"
               },
               "k2": {
                  "type": "date"
               }
            }
         }
      }
   }
   ```
   
   explain this SQL:
   
   
![image](https://user-images.githubusercontent.com/5183061/84991263-dec70c00-b178-11ea-95fc-e74deb56a454.png)
   
   As we can see date_format(now(), '%Y-%m-%d') can be pre-computed by Doris 
FE, but because `k1` datatype is different with the returned type 
`unix_timestamp`, all these two `Expr` become `CastExpr`.
   


----------------------------------------------------------------
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org