Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5509

columnstore_info.load_from_s3 | Misleading Messages

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 23.02.4
    • 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

          Activity

            People

              leonid.fedorov Leonid Fedorov
              allen.herrera Allen Herrera
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.