my sample csv file link – - curl -L -o ~/Downloads/toy-products-on-amazon.zip\
https://www.kaggle.com/api/v1/datasets/download/PromptCloudHQ/toy-products-on-amazon
tried to add the above file by following method:
mysql> CREATE TABLE user_behavior_inferred AS
→ SELECT * FROM FILES
→ (
→ “aws.s3.endpoint” = “XXXXX”,
→ “path” = “s3://starrocks/amazon_co-ecommerce_sample.csv”,
→ “aws.s3.enable_ssl” = “false”,
→ “aws.s3.access_key” = “3eoWgGzIw7p3IR1elwcC”,
→ “aws.s3.secret_key” = “ilbesbBgPpOfUjD5UPqgzAebnELwciGJTURJXA7O”,
→ “format” = “csv”,
→ “aws.s3.use_aws_sdk_default_behavior” = “false”,
→ “aws.s3.use_instance_profile” = “false”,
→ “aws.s3.enable_path_style_access” = “true”
→ );
Query OK, 128547 rows affected (29.37 sec)
{‘label’:‘insert_f3474108-6e99-11f0-9006-ca93c4da67cc’, ‘status’:‘VISIBLE’, ‘txnId’:‘5010’}
but there is no data in the file:
mysql> SELECT * from user_behavior_inferred LIMIT 3;
±-----+
| $1 |
±-----+
| |
| |
| |
±-----+
3 rows in set (0.03 sec)
Then tried with another method of creating table schema and then added data
created table:
mysql> DESCRIBE amazon_products;
±--------------------------------------------±---------------±-----±------±--------±------+
| Field | Type | Null | Key | Default | Extra |
±--------------------------------------------±---------------±-----±------±--------±------+
| uniq_id | varchar(65533) | YES | true | NULL | |
| product_name | varchar(65533) | YES | false | NULL | |
| manufacturer | varchar(65533) | YES | false | NULL | |
| price | varchar(65533) | YES | false | NULL | |
| number_available_in_stock | varchar(65533) | YES | false | NULL | |
| number_of_reviews | varchar(65533) | YES | false | NULL | |
| number_of_answered_questions | varchar(65533) | YES | false | NULL | |
| average_review_rating | varchar(65533) | YES | false | NULL | |
| amazon_category_and_sub_category | varchar(65533) | YES | false | NULL | |
| customers_who_bought_this_item_also_bought | varchar(65533) | YES | false | NULL | |
| description | varchar(65533) | YES | false | NULL | |
| product_information | varchar(65533) | YES | false | NULL | |
| product_description | varchar(65533) | YES | false | NULL | |
| items_customers_buy_after_viewing_this_item | varchar(65533) | YES | false | NULL | |
| customer_questions_and_answers | varchar(65533) | YES | false | NULL | |
| customer_reviews | varchar(65533) | YES | false | NULL | |
| sellers | varchar(65533) | YES | false | NULL | |
±--------------------------------------------±---------------±-----±------±--------±------+
Added data:
mysql> show load;
Empty set (0.00 sec)
mysql> LOAD LABEL amazon_products (
→ DATA INFILE(“s3://starrocks/amazon_co-ecommerce_sample.csv”)
→ INTO TABLE amazon_products
COLUMNS TERMINATED BY “,”
FORMAT AS “csv”
)
WITH BROKER
(
INTO TABLE amazon_products
→ COLUMNS TERMINATED BY “,”
→ FORMAT AS “csv”
→ )
→ WITH BROKER
→ (
→ “aws.s3.endpoint” = “XXXXX”,
→ “aws.s3.enable_ssl” = “false”,
→ “aws.s3.access_key” = “3eoWgGzIw7p3IR1elwcC”,
→ “aws.s3.secret_key” = “ilbesbBgPpOfUjD5UPqgzAebnELwciGJTURJXA7O”,
→ “aws.s3.use_instance_profile” = “false”,
→ “aws.s3.use_aws_sdk_default_behavior” = “false”,
→ “aws.s3.enable_path_style_access” = “true”
→ )
→ PROPERTIES (
→ “timeout” = “72000”,
→ “max_filter_ratio” = “0.1”,
→ “strict_mode” = “false”
→ );
Query OK, 0 rows affected (0.05 sec)
Error occurred
mysql> SELECT tracking_log FROM information_schema.load_tracking_logs WHERE job_id = 15097\G
*************************** 1. row ***************************
tracking_log: Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row:
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row: see more
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row:
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row:
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row:
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row: HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014.You would be advised to purchase models as you need them to avoid them being discontinued in subsequent yearsHope this helps
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row:
Error: Target column count: 17 doesn’t match source value column count: 2. Column separator: ‘,’, Row delimiter: ‘\n’. Row: see less","Worth Buying For The Pictures Alone (As Ever) // 4.0 // 6 April 2014 // By
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row:
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row: Copnovelist
Error: Target column count: 17 doesn’t match source value column count: 1. Column separator: ‘,’, Row delimiter: ‘\n’. Row:
Error: Target column count: 17 doesn’t match source value column count: 2. Column separator: ‘,’, Row delimiter: ‘\n’. Row: on 6 April 2014 // Part of the magic for me growing up as a boy was to buy (or be given) the new Hornby catalogue every year, even if it included 90% of the same products as the previous year. I’ve still got my old ones dating back to the 70s and 80s somewhere. These days the catalogue is especially informative in that it tells you the vintage of the rolling stock which is useful if you are dedicating your railway to one particular era and train company. | Amazing detail fabulous photography. // 5.0 // 11 April 2015 // By
KINDLY HELP ME OUT TO SOLVE THIS ERROR ..