database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-20 09:07:44 +03:00
Code
6,318 Commits 302 Branches 86 Tags
Commit Graph

5 Commits

Author SHA1 Message Date
Leonid Fedorov
88404f70f1 MCOL-5013: added terminated_by, enclosed_by, escaped_by for s3dataload 2022-11-03 15:46:08 +03:00
Leonid Fedorov
d02b3403b7 Changed function name, schema and params order to achieve 
columnstore_info.load_from_s3("<bucket>", "<file_name>", "<db_name>", "<table_name>");
 2022-08-18 10:41:22 +00:00
Leonid Fedorov
242769d542 Mistype bug error handler fix 2022-07-05 18:48:30 +03:00
Leonid Fedorov
110d9cfab5 Review fixes 2022-07-04 19:52:37 +03:00
Leonid Fedorov
f5b2a6885f MCOL-5013: Load Data from S3 into Columnstore 
Introduced UDF and stored prodecure.
usage:

set columnstore_s3_key='<s3_key>';
set columnstore_s3_secret='<s3_secret>';
set columnstore_s3_region='region';

and then use UDF
select columnstore_dataload("<tablename>", "<filename>", "<bucket>", "<db_name>");
for UDF db_name can be ommited, then current connection db will be used

or stored function
call calpontsys.columnstore_load_from_s3("<tablename>", "<filename>", "<bucket>", "<db_name>");
 2022-07-04 19:52:37 +03:00