Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] failed to create table from hms client. reason: org.apache.doris.datasource.hive.HMSClientException: Unsupported primitive type conversion of largeint #49253

Open
3 tasks done
pklcoder opened this issue Mar 19, 2025 · 0 comments

Comments

@pklcoder
Copy link

Search before asking

  • I had searched in the issues and found no similar issues.

Version

i use the doris-3.0.2-rc03 version .
i create mysql-5 catalog dom in the doris ,then i execute the sql "CREATE TABLE hive.dwmp.testCacheTablett2 AS select IFNULL(t3.id , NULL) AS id,IFNULL(t3.hive_db_name, NULL) AS hive_db_name,IFNULL(t3.hive_table_name, NULL) AS hive_table_name,IFNULL(t3.hive_table_comment, NULL) AS hive_table_comment FROM dom.dom.hive_table_info AS t3;" ;
error occured as bellow:ERROR 1105 (HY000): errCode = 2, detailMessage = failed to create table from hms client. reason: org.apache.doris.datasource.hive.HMSClientException: Unsupported primitive type conversion of largeint

ps: hive.dwmp.testCacheTablett2 which hive is the hive catalog created in doris
dom.dom.hive_table_info which dom is the mysql-5 catalog created in the doris
and t3.id which in the mysql table dom.dom.hive_table_info type is "bigint(20) unsigned"
so the type conversion likes this "bigint(20) unsigned [mysql-5]"=>largeint[doris-3.0.2-rc03 ]=>hive -3.1[no suit type]

how can we fix this bug?

What's Wrong?

i use the doris-3.0.2-rc03 version .
i create mysql-5 catalog dom in the doris ,then i execute the sql "CREATE TABLE hive.dwmp.testCacheTablett2 AS select IFNULL(t3.id , NULL) AS id,IFNULL(t3.hive_db_name, NULL) AS hive_db_name,IFNULL(t3.hive_table_name, NULL) AS hive_table_name,IFNULL(t3.hive_table_comment, NULL) AS hive_table_comment FROM dom.dom.hive_table_info AS t3;" ;
error occured as bellow:ERROR 1105 (HY000): errCode = 2, detailMessage = failed to create table from hms client. reason: org.apache.doris.datasource.hive.HMSClientException: Unsupported primitive type conversion of largeint

ps: hive.dwmp.testCacheTablett2 which hive is the hive catalog created in doris
dom.dom.hive_table_info which dom is the mysql-5 catalog created in the doris
and t3.id which in the mysql table dom.dom.hive_table_info type is "bigint(20) unsigned"
so the type conversion likes this "bigint(20) unsigned [mysql-5]"=>largeint[doris-3.0.2-rc03 ]=>hive -3.1[no suit type]

how can we fix this bug?

What You Expected?

how can we fix this bug?

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant