taosdata / taosdata/TDengine

insert into csv with Invalid operation

Open
#22,912 1 comment 0 reactions 1 assignee View on GitHub

@yu285 is already working on this.

Since Sep 25, 2023.

bug
Dominant language
C
Stars
25.1k
Forks
5k
Avg merge
4d 59m
Merged PRs (30d)
7

Description

dev_2502056046.csv

建表语句:
超级表:CREATE TABLE IF NOT EXISTS acc_all_eventlog (create_time TIMESTAMP,event_time TIMESTAMP,id NCHAR(50),log_id BINARY(50),integer_id INT,company_name NCHAR(50),community_name NCHAR(50),community_uuid NCHAR(50),community_code NCHAR(100),building_id INT,building_name NCHAR(50),room_id INT,room_name NCHAR(50),room_code NCHAR(50),call_forward_num BINARY(50),door_id INT,door_name NCHAR(50),dev_id INT,dev_uuid BINARY(50),dev_name NCHAR(50),device_model_value INT,device_model_name NCHAR(20),number BINARY(50),voip_account BINARY(50),memo NCHAR(50),app_user_id INT,emp_type INT,emp_id INT,emp_uuid BINARY(50),emp_phone BINARY(50),emp_email BINARY(50),emp_name NCHAR(50),dept_name NCHAR(50),emp_cert_no NCHAR(50),emp_no NCHAR(50),emp_card_no BINARY(50),emp_gender INT,emp_room_id INT,emp_room_name NCHAR(200),event_type INT,reason NCHAR(50),event_type_name NCHAR(50),capture_image BINARY(100),face_id INT,face_age INT,face_gender INT,face_match_score INT,body_temperature NCHAR(50),position_id INT,relay_index INT,position_type INT,position_full_name NCHAR(200),inout_state INT,register_result INT,fever_temperature NCHAR(50),acc_inout_status INT,open_status INT,visitor_name NCHAR(50),visitor_phone NCHAR(50),terminal_apply_type INT,terminal_os_type INT,terminal_device_brand NCHAR(50),terminal_device_model NCHAR(50),terminal_device_version NCHAR(50),terminal_app_version NCHAR(50),terminal_language NCHAR(50),terminal_ip NCHAR(50),event_kinds INT,day INT,event_name_value NCHAR(50),police_station_id INT,police_station_name NCHAR(50),city_code NCHAR(50),city_name NCHAR(50),consuming_time INT,extend_day NCHAR(50),extend_month INT,cert_no NCHAR(50),is_have_test_content INT,real_create_time TIMESTAMP) TAGS (platform_id INT,company_id INT,community_id INT,dev_sn NCHAR(50));
子表:create table dev_2502056048_100 using acc_all_eventlog tags(1,100,100,'2502056048');

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.