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

[GitHub] [doris] zengchen00 opened a new issue, #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

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

   ### 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: 2.0.0 beta
   hive: 3.1.2
   
   ### What's Wrong?
   
   I create hive catalog and succeed select data from hive_catalog.dwd.table_name first time. 
   ![image](https://github.com/apache/doris/assets/15973915/9e1c07f5-033f-4055-8c9a-e37aef584f4a)
   
   But after hive do  ' insert overwrite table table_name  select ........ ',doris same sql query again,An error has occurred:
   ![image](https://github.com/apache/doris/assets/15973915/af2fb440-6d6a-44fd-af7b-941310118a43)
   
   tail -f be.out:
   ![image](https://github.com/apache/doris/assets/15973915/07a5f358-ed04-416c-9156-a020bdc03fb4)
   
   
   
   ### What You Expected?
   
   when hive data change , I can select new data from doris hive catalog
   
   ### 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] zengchen00 commented on issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

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

   > 你得用 REFRESH TABLE hive_catalog.dwd.xxx 来重新刷新表元数据,不然查询的是历史信息!
   ,REFRESH database
   


-- 
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] ixzc commented on issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

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

   You can set auto-refresh when you create the catalog


-- 
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] zengchen00 commented on issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

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

   REFRESH catalog,REFRESH database,REFRESH table  都用了,都不行还是报错,不过过了一天后再查,就正常了,是我哪里没设置对吗?doris 还是 hive ?
   


-- 
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] zengchen00 commented on issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

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

   升级到 2.0.1 之后,就正常了


-- 
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] zengchen00 closed issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

Posted by "zengchen00 (via GitHub)" <gi...@apache.org>.
zengchen00 closed issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog
URL: https://github.com/apache/doris/issues/22982


-- 
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] w517424787 commented on issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

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

   你得用 REFRESH TABLE hive_catalog.dwd.xxx 来重新刷新表元数据,不然查询的是历史信息!


-- 
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] zengchen00 commented on issue #22982: [Bug] INTERNAL_ERROR happened when read hive table from hive catalog

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

   不过过了一天后再查,就正常了,是我哪里没设置对吗?doris 还是 hive ?


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