You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/09/11 08:45:54 UTC

[GitHub] [iotdb] LIU-WEI-git opened a new issue #3945: Hope fuzzy query could support multi-device

LIU-WEI-git opened a new issue #3945:
URL: https://github.com/apache/iotdb/issues/3945


   I find the fuzzy query of IoTDB doesn't support multi device.  Hope it can be supported in the future.
   
   In my scenario, I store the value of the index as LayerName to index some fields. For example, there is a table called service_traffic. It has 4 fields: id, type, group, name. I make the value of id, type and name as part of the storage path to achieve the effect of index. Eventually the data from the same table is spread across multiple devices.
   
   When I used `like` clause to fuzzy query, I got a Exception: `Msg: 500: [INTERNAL_SERVER_ERROR] Exception occurred while executing "select * from root.skywalking.service_traffic.*."0".* where name like '%1%'". class org.apache.iotdb.db.qp.logical.crud.LikeOperator cannot be cast to class org.apache.iotdb.db.qp.logical.crud.BasicFunctionOperator (org.apache.iotdb.db.qp.logical.crud.LikeOperator and org.apache.iotdb.db.qp.logical.crud.BasicFunctionOperator are in unnamed module of loader 'app')`
   
   In debug mode, I found the Exception occurs on [ConcatPathOptimizer](https://github.com/apache/iotdb/blob/rel/0.12/server/src/main/java/org/apache/iotdb/db/qp/strategy/optimizer/ConcatPathOptimizer.java#:~:text=((BasicFunctionOperator)%20operator)). The LikeOperator cannot be cast to BasicFunctionOperator.
   
   ![image](https://user-images.githubusercontent.com/51618159/132941220-c77b1ac7-13df-42f5-b3e9-538369858dc8.png)
   
   OS: Win10, Version: 0.12.2


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [iotdb] HTHou commented on issue #3945: Hope fuzzy query could support multi-device

Posted by GitBox <gi...@apache.org>.
HTHou commented on issue #3945:
URL: https://github.com/apache/iotdb/issues/3945#issuecomment-917403683


   @ijihang Any idea about this issue?


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [iotdb] LIU-WEI-git commented on issue #3945: Hope fuzzy query could support multi-device

Posted by GitBox <gi...@apache.org>.
LIU-WEI-git commented on issue #3945:
URL: https://github.com/apache/iotdb/issues/3945#issuecomment-919060141


   wow~, thanks a lot. : )


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [iotdb] HTHou commented on issue #3945: Hope fuzzy query could support multi-device

Posted by GitBox <gi...@apache.org>.
HTHou commented on issue #3945:
URL: https://github.com/apache/iotdb/issues/3945#issuecomment-918897023


    @LIU-WEI-git The latest rel/0.12 fixed this issue. You can try it now.


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [iotdb] HTHou edited a comment on issue #3945: Hope fuzzy query could support multi-device

Posted by GitBox <gi...@apache.org>.
HTHou edited a comment on issue #3945:
URL: https://github.com/apache/iotdb/issues/3945#issuecomment-918897023


    @LIU-WEI-git The latest rel/0.12 branch fixed this issue. You can try it now.


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [iotdb] LIU-WEI-git closed issue #3945: Hope fuzzy query could support multi-device

Posted by GitBox <gi...@apache.org>.
LIU-WEI-git closed issue #3945:
URL: https://github.com/apache/iotdb/issues/3945


   


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [iotdb] ijihang commented on issue #3945: Hope fuzzy query could support multi-device

Posted by GitBox <gi...@apache.org>.
ijihang commented on issue #3945:
URL: https://github.com/apache/iotdb/issues/3945#issuecomment-917771062


   Ok,I'll implement this function right away


-- 
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.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org