-
Notifications
You must be signed in to change notification settings - Fork 8.3k
INSERT INTO table FORMAT CSV successfully but reports error msg #18785
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-build-systemBuild system (CMake, compilation, platform builds).Build system (CMake, compilation, platform builds).
Description
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-build-systemBuild system (CMake, compilation, platform builds).Build system (CMake, compilation, platform builds).