Skip to content

INSERT INTO table FORMAT CSV successfully but reports error msg #18785

@l1t1

Description

@l1t1

I run the bin/upload-data.sh from https://github.com/Altinity/tpc-ds

#!/bin/bash

for file_name in `ls ../data/*.dat`; do
    table_file=$(echo "${file_name##*/}")
    table_name=$(echo "${table_file%_*}" | tr '[:upper:]' '[:lower:]' | tr -d [0-9]|sed 's/__//g')
    upload_data_sql="INSERT INTO $table_name FORMAT CSV"

    echo "$upload_data_sql <-- $(du -h $file_name)"

    cat $file_name | clickhouse client --format_csv_delimiter="|" --max_partitions_per_insert_block=100 --database="tpcds" --query="$upload_data_sql"
    rm $file_name

    sleep 5
done

reports
INSERT INTO customer_address FORMAT CSV <-- 5.3M ../data/customer_address_1_64_0001.dat
Cannot set alternative signal stack for thread, errno: 12, strerror: Cannot allocate memory
Cannot set alternative signal stack for thread, errno: 12, strerror: Cannot allocate memory

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official releasecomp-build-systemBuild system (CMake, compilation, platform builds).

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions