You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/04/26 14:05:57 UTC
[GitHub] [incubator-doris] blackfox1983 opened a new issue #3397: Cannot Create Table with syntax "DB.Table"
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] blackfox1983 commented on issue #3397: Cannot Create Table with syntax "DB.Table"
Posted by GitBox <gi...@apache.org>.
blackfox1983 commented on issue #3397:
URL: https://github.com/apache/incubator-doris/issues/3397#issuecomment-619557176
oh sorry. it's my fault.. i made a misuse...
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] blackfox1983 commented on issue #3397: Cannot Create Table with syntax "DB.Table"
Posted by GitBox <gi...@apache.org>.
blackfox1983 commented on issue #3397:
URL: https://github.com/apache/incubator-doris/issues/3397#issuecomment-619556351
I tested some case. and this bug is only in doris on ES
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org