Doris建立表報錯Failed to find enough host with storage medium問題解決
Doris create table報錯:
mysql> CREATE TABLE `test` (
-> `id` bigint(11) NOT NULL,
-> `name` varchar(255) DEFAULT NULL,
-> `score` bigint(11) DEFAULT NULL
-> ) ENGINE=olap
-> DISTRIBUTED BY HASH (id) BUCKETS 1
-> PROPERTIES (
-> "storage_medium" = "SSD",
-> "replication_allocation" = "tag.location.default: 1"
-> );
ERROR 1064 (HY000): errCode = 2, detailMessage = Failed to find enough host with storage medium and tag(SSD/{"location" : "default"}) in all backends. need: 1
錯誤原因:根據錯誤提示,是因為be配置檔案裡沒有找到足夠多的 storage medium導致的。
解決方法:
修改be.conf,然後配置多個storage_root_path:
storage_root_path = /data/doris/doris.HDD,50;/root/doris/doris.SSD,1;/root/doris-2
如果目錄不存在,需要手動建立
# mkdir -p /data/doris/doris.HDD
# mkdir -p /root/doris/doris.SSD
# mkdir -p /root/doris-2
重啟be後問題得到解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15498/viewspace-2920904/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SCP報錯:Host key verification failed.AI
- mongodb find報錯怎麼解決MongoDB
- Laravel5的資料庫表建立問題 資料庫遷移操作報錯問題解決Laravel資料庫
- 解決 Inkscape 報錯 Duplicate 問題
- Mac SSH 連線出現 Host key verification failed. 錯誤解決MacAI
- Could not resolve host: 'localhost 報錯解決辦法localhost
- 解決can't find -lGL的問題
- Could not find jar tool executable問題解決JAR
- 解決eslint空格報錯等問題EsLint
- 設定autotrace的報錯問題解決
- 解決cookies儲存中文報錯問題Cookie
- 【Ubuntu】unknown host問題解決辦法Ubuntu
- REMOTE HOST IDENTIFICATION HAS CHANGED 問題解決REMIDE
- 使用API28報錯問題及解決API
- jquery-weui微信支付報錯問題解決jQueryUI
- matplotlib中文報錯問題及解決方案
- mac 下PyCharm執行報錯問題解決MacPyCharm
- Check_icmp check_host_alive報錯解決方法
- android APK INSTALL_FAILED_INSUFFICIENT_STORAGE 問題AndroidAPKAI
- command 'gcc' failed with exit status 1錯誤問題的解決辦法GCAI
- 解決ssh的"Write failed: Broken pipe"問題AI
- VMware 啟動報錯 "Failed to lock the file"解決辦法AI
- Not enough server storage is available to process this command.ServerAI
- dblink建立後訪問提示密碼錯誤問題解決密碼
- 解決Tomcat啟動報錯問題:Failed to destroy end point associated with ProtocolHandler["ajp-nio-8009"]TomcatAIProtocol
- windows 7 下面建立資料庫報DIM-00014錯誤問題解決Windows資料庫
- 解決MMM啟動監控報錯的問題
- 解決vue使用Sass時候的報錯問題Vue
- vm安裝ubuntu後,update報錯問題解決Ubuntu
- 解決mysql_query()報錯的相關問題MySql
- "ScrollView can host only one direct child"問題解決View
- centos6.5報錯:checking filesystems failed問題處理CentOSAI
- ssh連線遠端伺服器出現Host key verification failed. lost connection問題的解決伺服器AI
- Ping:Transmit Failed, Error Code 65問題解決MITAIError
- socket write failed(24) _Netbackup的問題解決AI
- oracle 10.2.0.3 dbca建庫報Failed to retrieve size of raw device 問題解決方法OracleAIdev
- JOB建立,解決網友問題
- Uncaught Error: Bootstrap‘s JavaScript requires jQuery報錯問題解決ErrorbootJavaScriptUIjQuery