blackfox1983 opened a new issue #3397:
URL: https://github.com/apache/incubator-doris/issues/3397
In MySQL manual, create table with syntax like 'db.table' works. but in
doris, it maybe not work well.
I must use syntax like below:
use mydb; create table `table`...
the case is e.g.
MySQL [(none)]> CREATE EXTERNAL TABLE `mydb.table` (
-> `k1` BIGINT(20) NULL,
-> `k2` VARCHAR(1) NULL
-> ) ENGINE=ELASTICSEARCH
-> COMMENT "ELASTICSEARCH"
-> PROPERTIES (
-> "hosts" = "http://192.168.129.6:8200";,
-> "user" = "",
-> "password" = "",
-> "index" = "mydb_table",
-> "type" = "_doc",
-> "transport" = "http",
-> "enable_docvalue_scan" = "true"
-> );
ERROR 1046 (3D000): No database selected
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
