chdb-io / chdb-server-bak

API Server for chDB, an in-process SQL OLAP Engine powered by ClickHouse
https://chdb.io
Apache License 2.0
21 stars 4 forks source link

400 response on sending multiline JSONEachRow requests #10

Open akvlad opened 9 months ago

akvlad commented 9 months ago
  1. Create a db:
    cat <<EOF | curl -X POST http://a:b@localhost:8123/ --data-binary @-
    CREATE DATABASE a;
    EOF
  2. 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
  3. 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

4. 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
lmangani commented 9 months ago

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