luocooong commented on issue #2355: URL: https://github.com/apache/drill/issues/2355#issuecomment-955185985
<pre> apache drill> show databases; +-----------------------------+ | SCHEMA_NAME | +-----------------------------+ | cp.default | | dfs.default | | dfs.root | | dfs.tmp | | information_schema | | mongo_atlas.admin | | mongo_atlas.local | | mongo_atlas.myfirstdatabase | | sys | +-----------------------------+ 9 rows selected (0.318 seconds) apache drill> use mongo_atlas.myfirstdatabase; +------+---------------------------------------------------------+ | ok | summary | +------+---------------------------------------------------------+ | true | Default schema changed to [mongo_atlas.myfirstdatabase] | +------+---------------------------------------------------------+ 1 row selected (0.099 seconds) apache drill (mongo_atlas.myfirstdatabase)> show tables; +-----------------------------+------------+ | TABLE_SCHEMA | TABLE_NAME | +-----------------------------+------------+ | mongo_atlas.myfirstdatabase | test | +-----------------------------+------------+ 1 row selected (0.248 seconds) apache drill (mongo_atlas.myfirstdatabase)> select * from test; +-----------------------------+-------------------------+ | _id | date | +-----------------------------+-------------------------+ | a"j\xC3;)\xFFc\x06\xB3j\xA9 | 2021-08-22 23:18:27.258 | +-----------------------------+-------------------------+ 1 row selected (2.196 seconds) </pre> @javier-nieto-nexplore I cannot reproduce the same set of problems on the cluster (3.6, replica set) and Atlas cloud (4.4, free). I think the difference is `Database Access` : User Name | Authentication Method | MongoDB Roles | Resources -- | -- | -- | -- test | SCRAM | atlasAdmin@admin | All Resources -- 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: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
