1、[MERGE|APPEND|DELETE] 数据合并类型,默认为 APPEND,表示本次导入是普通的追加写操作。MERGE 和 DELETE 类型仅适用于 Unique Key 模型表,其中 MERGE 类型需要配合[DELETE ON]语句使用,以标注 Delete Flag列,而DELETE类型则表示本次导入的所有数据皆为删除数据。 2、DATA INFILE 指定需要导入的文件路径,可以是多...
DATA INFILE("hdfs://linux01:8020/input/file-10*")INTOTABLE`my_table1`PARTITION(p1) COLUMNS TERMINATEDBY"," FORMATAS"parquet" (id, tmp_salary, tmp_score)SET( salary=tmp_salary+1000, score=tmp_score+10), DATA INFILE("hdfs://linux01:8020/input/file-20*")INTOTABLE`my_table2` COLUMNS...
-T data.txt http://host:port/api/testDb/testTbl/_stream_load 1. 2. 3. 4. 5. 这个示例表示第四列为 Delete Label 列,并且当值为1时,表示对应行为删除操作。 Broker Load LOAD LABEL example_db.my_label ( MERGE DATA INFILE("hdfs://abc.com:8888/user/palo/test/ml/file1") INTO TABLE e...
DATA INFILE("hdfs://hdfs_host:hdfs_port/input/file-10*")INTOTABLE`my_table1`PARTITION(p1) COLUMNS TERMINATEDBY"," (k1, tmp_k2, tmp_k3)SET( k2=tmp_k2+1, k3=tmp_k3+1) DATA INFILE("hdfs://hdfs_host:hdfs_port/input/file-20*")INTOTABLE`my_table2` COLUMNS TERMINATEDBY"," (k1...
LOADLABELdb1.label1([MERGE|APPEND|DELETE]DATAINFILE("hdfs://abc.com:8888/user/palo/test/ml/file1")INTOTABLEtbl1COLUMNSTERMINATEDBY","(tmp_c1,tmp_c2,label_c3)SET(id=tmp_c2,name=tmp_c1,)[DELETEONlabel_c3=true])WITHBROKER'broker'("username"="user","password"="pass")PROPERTIES("timeou...
[MERGE|APPEND|DELETE] DATA INFILE("hdfs://abc.com:8888/user/palo/test/ml/file1") INTO TABLE tbl1 COLUMNS TERMINATED BY "," (tmp_c1,tmp_c2, label_c3) SET ( id=tmp_c2, name=tmp_c1, ) [DELETE ON label=true] ) WITH BROKER 'broker' ...
LOADLABELdb1.label1([MERGE|APPEND|DELETE]DATAINFILE("hdfs://abc.com:8888/user/palo/test/ml/file1")INTOTABLEtbl1COLUMNSTERMINATEDBY","(tmp_c1,tmp_c2,label_c3)SET(id=tmp_c2,name=tmp_c1,)[DELETEONlabel=true])WITHBROKER'broker'("username"="user","password"="pass")PROPERTIES("timeout"...
数据合并类型,默认为 APPEND,表示本次导入是普通的追加写操作。MERGE 和 DELETE 类型仅适用于 Unique Key 模型表,其中 MERGE 类型需要配合[DELETE ON]语句使用,以标注 Delete Flag列,而DELETE类型则表示本次导入的所有数据皆为删除数据。 DATA INFILE 指定需要导入的文件路径,可以是多个,可以使用通配符。路径最终必须...
[MERGE|APPEND|DELETE] DATA INFILE("hdfs://abc.com:8888/user/palo/test/ml/file1") INTO TABLE tbl1 COLUMNS TERMINATED BY "," (tmp_c1,tmp_c2, label_c3) SET ( id=tmp_c2, name=tmp_c1, ) [DELETE ON label=true] ) WITH BROKER 'broker' ...
DATA INFILE ('file_path', ...) [NEGATIVE] INTO TABLE tbl_name [PARTITION (p1, p2)] [COLUMNS TERMINATED BY separator ] [(col1, ...)] [PRECEDING FILTER predicate] [SET (k1=f1(xx), k2=f2(xx))] [WHERE predicate] * broker_properties: ...