taosdata/TDengine

The super table parameter continueIfFail: 0, STOP insertion!

Open

#22.399 aperta il 10 ago 2023

Vedi su GitHub
 (2 commenti) (0 reazioni) (0 assegnatari)C (5002 fork)batch import
help wantedquestion

Metriche repository

Star
 (24.849 star)
Metriche merge PR
 (Merge medio 1g 1h) (4 PR mergiate in 30 g)

Descrizione

I am trying to use taosbenchmark to test the performance. I have created a super table with 500 columns and the last one is c499. Now, I want to insert a new column called c500 into all of the sub-tables using this json file.

{
    "filetype": "insert",
    "cfgdir": "/etc/taos",
    "host": "127.0.0.1",
    "port": 6030,
    "user": "root",
    "connection_pool_size": 8,
    "thread_count": 16,
    "result_file": "insert_res.txt",
    "confirm_parameter_prompt": "no",
    "insert_interval": 0,
    "interlace_rows": 0,
    "num_of_records_per_req": 10000,
    "prepared_rand": 10000,
    "chinese": "no",
    "databases": [
        {
            "dbinfo": {
                "name": "test",
                "drop": "no",
                "replica": 1,
                "precision": "ms"
            },
            "super_tables": [
                {
                    "name": "meters",
                    "child_table_exists": "yes",
                    "childtable_count": 1000,
                    "childtable_prefix": "d",
                    "escape_character": "yes",
                    "auto_create_table": "no",
                    "batch_create_tbl_num": 5,
                    "data_source": "rand",
                    "insert_mode": "taosc",
                    "non_stop_mode": "no",
                    "insert_rows": 10000,
                    "childtable_limit": 1000,
                    "childtable_offset": 0,
                    "interlace_rows": 0,
                    "partial_col_num": 0,
                    "disorder_ratio": 50,
                    "columns": [
                        {
                            "type": "FLOAT",
                            "name": "c500",
                            "count": 1,
                            "max": 30,
                            "min": 1
                        }
                    ]
                }
            ]
        }
    ]
}

However, when I use this json file to do insertion, I met this error: WARN: The super table parameter continueIfFail: 0, STOP insertion!. Where am I wrong?

Guida contributor