chdb-server-bak icon indicating copy to clipboard operation
chdb-server-bak copied to clipboard

400 response on sending multiline JSONEachRow requests

Open akvlad opened this issue 2 years ago • 1 comments

  1. Create a db:
cat <<EOF | curl -X POST http://a:b@localhost:8123/ --data-binary @-
CREATE DATABASE a;
EOF
  1. create a table
cat <<EOF | curl -X POST http://a:b@localhost:8123/?database=a --data-binary @-
CREATE TABLE IF NOT EXISTS time_series  (date Date,fingerprint UInt64,labels String, name String)
    ENGINE = ReplacingMergeTree(date) PARTITION BY date ORDER BY fingerprint;
EOF
  1. send one line of data into the table:
cat <<EOF | curl -X POST 'http://a:b@localhost:8123/?query=INSERT%20INTO%20a.time_series(date,%20fingerprint,%20labels,%20name)%20FORMAT%20JSONEachRow' --data-binary @-
{"fingerprint":"15239659101592556481","timestamp_ns":"1699265700000000000","value":null,"string":"FREQ_TEST_0"}

EOF
  1. send several lines of data into the table
cat <<EOF | curl -v -X POST 'http://a:b@localhost:8123/?query=INSERT%20INTO%20a.time_series(date,%20fingerprint,%20labels,%20name)%20FORMAT%20JSONEachRow' --data-binary @-
{"fingerprint":"15239659101592556481","timestamp_ns":"1699265700000000000","value":null,"string":"FREQ_TEST_0"}
{"fingerprint":"15239659101592556481","timestamp_ns":"1699265700000000000","value":null,"string":"FREQ_TEST_0"}

EOF

AR: p.4 doesn't work with error 400 ER: p.4 should work same as p.3

akvlad avatar Nov 06 '23 10:11 akvlad

This should pass with the latest version, please re-break 😉

lmangani avatar Nov 11 '23 18:11 lmangani