Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Reproduction
CREATE DATABASE db1;
|
|
CREATE TABLE db1.tab1 (
|
id INT,
|
color varchar(50), |
quantity INT
|
) ENGINE=ColumnStore;
|
|
# See developer comments for key/secret |
SET columnstore_s3_region='us-west-2'; |
SET columnstore_s3_key='x'; |
SET columnstore_s3_secret='x'; |
CALL columnstore_info.load_from_s3('s3://allens-spark-test-bucket/','junk_data.csv','db1', 'tab1', ',', '"', ''); |
|
select count(*) from db1.tab1;
|
Notice the message
Success = false
and inserted =* 0 *
+----------------------------------------------------------------------------------------------------+
|
| columnstore_dataload(bucket, filename, dbname, table_name, terminated_by, enclosed_by, escaped_by) |
|
+----------------------------------------------------------------------------------------------------+
|
| {"success": false, "inserted": 0, "processed": 0} | |
+----------------------------------------------------------------------------------------------------+
|
1 row in set (3.100 sec) |
|
Query OK, 0 rows affected (3.100 sec) |
But in reality the records were indeed created
Attachments
Issue Links
- relates to
-
MCOL-5013 Support Load data from AWS S3 : UDF : columnstore_info.load_from_s3
- Closed