You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "miaozi2008 (via GitHub)" <gi...@apache.org> on 2023/04/18 09:22:06 UTC
[GitHub] [doris] miaozi2008 opened a new issue, #18782: [Bug] doris-1.2.2 查询hive表int类型属性，值为NULL
miaozi2008 opened a new issue, #18782:
URL: https://github.com/apache/doris/issues/18782
### 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
apache-doris-be-1.2.2 apache-doris-fe-1.2.2
### What's Wrong?
通过doris catalog 自动同步hive 元数据，查询hive表，表中int类型的属性，通过doris查询值为NULL
hive中建表语句
CREATE TABLE test( id int);
hive中查询结果
select * from test;
+----------+
| test.id |
+----------+
| 12 |
| 678 |
| 678 |
+----------+
doris自动同步的表
desc test;
+-------+------+------+------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------+------+------+---------+-------+
| id | INT | Yes | true | NULL | |
+-------+------+------+------+---------+-------+
doris中查询结果：
select * from test;
+------+
| id |
+------+
| NULL |
| NULL |
| NULL |
+------+
### What You Expected?
通过doris能查到正确的结果
### 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] miaozi2008 commented on issue #18782: [Bug] doris-1.2.2 查询hive表int类型属性，值为NULL
Posted by "miaozi2008 (via GitHub)" <gi...@apache.org>.
miaozi2008 commented on issue #18782:
URL: https://github.com/apache/doris/issues/18782#issuecomment-1533983342
>
CREATE RESOURCE hms_resource PROPERTIES (
'type'='hms',
'hive.metastore.uris' = 'thrift://xxx:9083,thrift://xxx:9083,thrift://xxx:9083',
'hive.version' = '3.1.2',
'hadoop.username' = 'hadoop',
'dfs.nameservices'='hadoopcluster',
'dfs.ha.namenodes.hadoopcluster'='nn1,nn2',
'dfs.namenode.rpc-address.hadoopcluster.nn1'='xxx:8082',
'dfs.namenode.rpc-address.hadoopcluster.nn2'='xxx:8082',
'dfs.client.failover.proxy.provider.hadoopcluster'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider',
'dfs.encryption.key.provider.uri' = 'kms://http@xxx:9292/kms'
);
CREATE CATALOG hive WITH RESOURCE hms_resource;
--
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] yuxuan-luo commented on issue #18782: [Bug] doris-1.2.2 查询hive表int类型属性，值为NULL
Posted by "yuxuan-luo (via GitHub)" <gi...@apache.org>.
yuxuan-luo commented on issue #18782:
URL: https://github.com/apache/doris/issues/18782#issuecomment-1523268479
看下你创建 mutil 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