We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
doris 3.0.1-bin-x64 hive 3.1.3
first: create hive catalog CREATE CATALOG IF NOT EXISTS hive PROPERTIES ( 'type'='hms', 'hive.metastore.uris' = 'thrift://eant001:9083', 'hive.version' = '3.1.3', 'hadoop.username' = 'hive', 'dfs.nameservices'='eans1', 'dfs.ha.namenodes.eans1'='eann1,eann2', 'dfs.namenode.rpc-address.eans1.eann1'='eant001:8020', 'dfs.namenode.rpc-address.eans1.eann2'='eant002:8020', 'dfs.client.failover.proxy.provider.eans1'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider' );
CREATE CATALOG IF NOT EXISTS hive PROPERTIES ( 'type'='hms', 'hive.metastore.uris' = 'thrift://eant001:9083', 'hive.version' = '3.1.3', 'hadoop.username' = 'hive', 'dfs.nameservices'='eans1', 'dfs.ha.namenodes.eans1'='eann1,eann2', 'dfs.namenode.rpc-address.eans1.eann1'='eant001:8020', 'dfs.namenode.rpc-address.eans1.eann2'='eant002:8020', 'dfs.client.failover.proxy.provider.eans1'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider' );
second: Generate TPC-DS sample data
third: Query ` mysql> select * from customer_demographics where cd_education_status = 'College' limit 1; Empty set (0.02 sec)
mysql> select cd_education_status, length(cd_education_status), 'College' = cd_education_status from customer_demographics where cd_education_status like '%College' limit 1; +---------------------+-----------------------------+-----------------------------------+ | cd_education_status | length(cd_education_status) | ('College' = cd_education_status) | +---------------------+-----------------------------+-----------------------------------+ | College | 7 | 1 | +---------------------+-----------------------------+-----------------------------------+ 1 row in set (0.04 sec) `
Summary: The query sql select * from customer_demographics where cd_education_status = 'College' limit 1; has no resultset as expect
select * from customer_demographics where cd_education_status = 'College' limit 1;
sql select * from customer_demographics where cd_education_status = 'College' limit 1; should have resultset
No response
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Search before asking
Version
doris 3.0.1-bin-x64
hive 3.1.3
What's Wrong?
first: create hive catalog
CREATE CATALOG IF NOT EXISTS hive PROPERTIES ( 'type'='hms', 'hive.metastore.uris' = 'thrift://eant001:9083', 'hive.version' = '3.1.3', 'hadoop.username' = 'hive', 'dfs.nameservices'='eans1', 'dfs.ha.namenodes.eans1'='eann1,eann2', 'dfs.namenode.rpc-address.eans1.eann1'='eant001:8020', 'dfs.namenode.rpc-address.eans1.eann2'='eant002:8020', 'dfs.client.failover.proxy.provider.eans1'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider' );
second: Generate TPC-DS sample data
third: Query
`
mysql> select * from customer_demographics where cd_education_status = 'College' limit 1;
Empty set (0.02 sec)
mysql> select cd_education_status, length(cd_education_status), 'College' = cd_education_status from customer_demographics where cd_education_status like '%College' limit 1;
+---------------------+-----------------------------+-----------------------------------+
| cd_education_status | length(cd_education_status) | ('College' = cd_education_status) |
+---------------------+-----------------------------+-----------------------------------+
| College | 7 | 1 |
+---------------------+-----------------------------+-----------------------------------+
1 row in set (0.04 sec)
`
Summary: The query sql
select * from customer_demographics where cd_education_status = 'College' limit 1;
has no resultset as expectWhat You Expected?
sql
select * from customer_demographics where cd_education_status = 'College' limit 1;
should have resultsetHow to Reproduce?
No response
Anything Else?
No response
Are you willing to submit PR?
Code of Conduct
The text was updated successfully, but these errors were encountered: