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
 
 -