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

[GitHub] [doris] CodeCooker17 opened a new issue, #20588: [Bug] Doris does not support specifying the hive version when creating hive external table

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

   ### 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 version 2.0.0
   hive version  2.1.2
   
   ### What's Wrong?
   
   Doris does not support specifying the hive version when creating hive tables. Because a large amount of data needs to be imported by spark load, the hive version cannot be specified when creating a hive table, and the hive 2.3 version is used by default, which leads to an incompatibility error of the hive metastore version. 
   exception:
   `Invalid method nameļ¼š'get_table_req'`
   
   ### What You Expected?
   
   Doris already supports configuring hive version when registering catalog, so I think it should also support configuring hive version when creating hive appearance.
   
   ### How to Reproduce?
   
   use hive 2.1 version, create hive EXTERNAL TABLE as this:
   create EXTERNAL TABLE `feature_metric_extend_aggregation_external`(
     `team_id` bigint ,
     `user_id` string ,
     `metric_code` string,
     `metric_value` string ,
     `version` string 
   )
   ENGINE=hive
   properties
   (
   "database" = "dm_cdp",
   "table" = "feature_metric_extend_aggregation",
   "hive.metastore.uris" = "****",
   );
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] 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] CodeCooker17 commented on issue #20588: [Bug] Doris does not support specifying the hive version when creating hive external table

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

   But when you need to import a large amount of data, you need to use spark load to import data. At this time, you need to create a hive external table. Therefore, it makes sense to support the configuration of hive version when the task can create a hive  external table, although the hive  external table has been deprecated.
   @hechao-ustc 


-- 
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] hechao-ustc commented on issue #20588: [Bug] Doris does not support specifying the hive version when creating hive external table

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

   It is recommended to use the Hive Catalog to access Hive. The external table function will no longer be maintained after version 1.2.0.


-- 
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] dataroaring closed issue #20588: [Bug] Doris does not support specifying the hive version when creating hive external table

Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed issue #20588: [Bug] Doris does not support specifying the hive version when creating hive external table
URL: https://github.com/apache/doris/issues/20588


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