[GitHub] [incubator-doris] wyb commented on a change in pull request #3938: (#3061) add user doc for build global dict

[GitBox <gi...@apache.org>]

wyb commented on a change in pull request #3938:
URL: https://github.com/apache/incubator-doris/pull/3938#discussion_r446598831



##########
File path: docs/zh-CN/administrator-guide/load-data/spark-load-manual.md
##########
@@ -277,6 +289,48 @@ PROPERTIES
 
 ```
 
+示例2：上游数据源是hive表的情况
+```sql
+step 1:新建hive外部表
+CREATE EXTERNAL TABLE hive_t1
+(
+    k1 INT,
+    K2 SMALLINT,
+    k3 varchar(50),
+    uuid varchar(100)
+)
+ENGINE=hive
+properties
+(
+"database" = "tmp",
+"table" = "t1",
+"hive.metastore.uris" = "thrift://0.0.0.0:8080"
+);
+
+step 2: 提交load命令
+LOAD LABEL db1.label1
+(
+    DATA FROM TABLE hive_t1
+    INTO TABLE tbl1
+    COLUMNS TERMINATED BY ","
+    (k1,k2,k3)

Review comment:
       直接从hive表中读，不需要COLUMNS TERMINATED BY。
   目前还不支持指定columns，要求doris表中的所有字段都在hive表中。




----------------------------------------------------------------
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