You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "lsy3993 (via GitHub)" <gi...@apache.org> on 2023/04/04 07:08:43 UTC
[GitHub] [doris] lsy3993 opened a new issue, #18379: [Bug] Can not grant ES catalog table to a user
lsy3993 opened a new issue, #18379:
URL: https://github.com/apache/doris/issues/18379
### 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 is : 1.2.1, but the master code has the same problem.
### What's Wrong?
// 1. we start a es
// 2. create es catalog
CREATE CATALOG es PROPERTIES ( "type"="es", "hosts"="http://127.0.0.1:29200");
// 3. show es table
mysql> switch es;
Query OK, 0 rows affected (0.17 sec)
mysql> show tables;
+----------------------+
| Tables_in_default_db |
+----------------------+
| test1 |
| test2 |
| test2_20220808 |
+----------------------+
// 4. create a user 'aaa'
create user aaa IDENTIFIED BY '123456';
// 5. use 2 ways to grant
// 5a. no default_db
grant SELECT_PRIV on `es`.`test1` to 'aaa'@'%';
// 5b. use default_db
grant SELECT_PRIV on `es`.`default_db`.`test1` to 'aaa'@'%';
// 6. the grant operation is succeed, but we can not query it
mysql -uaaa -p123456 -h10.16.10.14 -P19035
switch es;
mysql> show tables;
Empty set (0.00 sec)
mysql> select * from es.test1;
ERROR 1049 (42000): errCode = 2, detailMessage = Unknown database 'default_cluster:es'
mysql> select * from es.default_db.test1;
ERROR 1105 (HY000): errCode = 2, detailMessage = Unexpected exception: java.lang.NullPointerException
### What You Expected?
grant es table, and query it successfully
### 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] lsy3993 commented on issue #18379: [Bug] Can not grant ES catalog table to a user
Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on issue #18379:
URL: https://github.com/apache/doris/issues/18379#issuecomment-1495592391
mapping：
curl -XPUT "10.8、0.0.1:9200/my_test3?pretty" -H 'Content-Type: application/json' -d'
{
"mappings": {
"properties" : {
"name" : {
"type" : "text"
},
"id" : {
"type" : "long"
},
"mobile": {
"type" : "nested",
"properties":{
"first":{"type":"text"},
"last":{"type":"keyword"}
}
}
}
}
}'
--
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] morningman closed issue #18379: [Bug] Can not grant ES catalog table to a user
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #18379: [Bug] Can not grant ES catalog table to a user
URL: https://github.com/apache/doris/issues/18379
--
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