You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "CatchTheDog (via GitHub)" <gi...@apache.org> on 2023/04/19 01:43:17 UTC

[GitHub] [doris] CatchTheDog opened a new issue, #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

CatchTheDog opened a new issue, #18802:
URL: https://github.com/apache/doris/issues/18802

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   Doris 1.2.3 
   
   ### What's Wrong?
   
   使用catalog 连接 ES 7.5 ,出现如下报错：
   
   ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[index_name] type[null] mapping not found for the ES Cluster
   
   ### What You Expected?
   
   返回index 内数据。
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: commits-unsubscribe@doris.apache.org.apache.org

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


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

[GitHub] [doris] CatchTheDog commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "CatchTheDog (via GitHub)" <gi...@apache.org>.
CatchTheDog commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1514018372

   ![image](https://user-images.githubusercontent.com/38939831/232945133-663af6e4-f4ea-41bf-b584-3931bc2c4b30.png)
   


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] stalary commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1561124585

   @zlz-cn Try it in doris 1.2.4


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] stalary commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1547998638

   Show me your create table sql and es index _mapping info


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] stalary commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1559479706

   > @stalary 同样遇到了这个问题，是在执行这个命令之后出现的 curl -X PUT "localhost:9200/doc/_mapping?pretty" -H 'Content-Type:application/json' -d ' { "_meta": { "doris":{ "array_fields":[ "array_int_field", "array_string_field", "array_object_field" ] } } }'
   
   Please provide es index mapping, and what's your es version?


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] zlz-cn commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "zlz-cn (via GitHub)" <gi...@apache.org>.
zlz-cn commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1560347821

   > 
   > Please provide es index mapping, and what's your es version?
   
   es version: 7.10.2
   doris version : 1.2.2
   
   index mapping :
   ![image](https://github.com/apache/doris/assets/46663197/7c2bed0a-2288-41ec-9c9f-c42473a97cf3)
   
   好像和这个bug有关 ：
   [https://github.com/apache/doris/issues/15485](url)
   
   这个Doris版本还遇到了另外一个问题， 使用同样的es数据 分别创建 catalog和 es外部表
   查询catalog
   select * from es_catalog where esquery(...) 会报错 
   [HY000][1105] errCode = 2, detailMessage = Fake function fake do not support execute
   可能是esquery导致的，因为不加条件查询
   select * from es_catalog 是可以的
   查询外部表
   select * from es_table where esquery(...) 也是可以的


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] stalary commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1548815039

   Your type look like error


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] CatchTheDog commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "CatchTheDog (via GitHub)" <gi...@apache.org>.
CatchTheDog commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1514019015

   参考了外部表的创建，type 这个字段是不是值有问题要确认一下；
   但是我使用 alter 语句修改type字段值为doc的时候，提示无法修改资源类型。


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] zlz-cn commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "zlz-cn (via GitHub)" <gi...@apache.org>.
zlz-cn commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1558839828

   @stalary 同样遇到了这个问题，是在执行这个命令之后出现的
   curl -X PUT "localhost:9200/doc/_mapping?pretty" -H 'Content-Type:application/json' -d '
   {
       "_meta": {
           "doris":{
               "array_fields":[
                   "array_int_field",
                   "array_string_field",
                   "array_object_field"
               ]
           }
       }
   }'


-- 
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: commits-unsubscribe@doris.apache.org

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


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

[GitHub] [doris] zlz-cn commented on issue #18802: [Bug] ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: org.apache.doris.external.elasticsearch.DorisEsException: index[top_popular_enterprise] type[null] mapping not found for the ES Cluster

Posted by "zlz-cn (via GitHub)" <gi...@apache.org>.
zlz-cn commented on issue #18802:
URL: https://github.com/apache/doris/issues/18802#issuecomment-1562627783

   > @zlz-cn Try it in doris 1.2.4
   
   使用1.2.4.1版本，es catalog  查询select * from es_catalog where esquery(...) 依旧会报错
   Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=29) errCode = 2, detailMessage = (10.253.28.52)[NOT_IMPLEMENTED_ERROR]Fake function fake do not support execute
   截图如下
   ![image](https://github.com/apache/doris/assets/46663197/0a290e03-8eb5-4b38-9830-7d04f3417a03)
   


-- 
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: commits-unsubscribe@doris.apache.org

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


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