CSVWithNames

توثيق تنسيق CSV

الإدخال	الإخراج	الاسم البديل
✔	✔

​

الوصف

يطبع أيضًا صف العناوين الذي يحتوي على أسماء الأعمدة، وذلك على نحو مماثل لـ TabSeparatedWithNames.

​

مثال للاستخدام

​

إدراج البيانات

اعتبارًا من الإصدار 23.1، سيكتشف ClickHouse تلقائيًا صفوف الرؤوس في ملفات CSV عند استخدام التنسيق CSV، لذا لا حاجة إلى استخدام CSVWithNames أو CSVWithNamesAndTypes.

باستخدام ملف CSV التالي المسمى football.csv:

date,season,home_team,away_team,home_team_goals,away_team_goals
2022-04-30,2021,Sutton United,Bradford City,1,4
2022-04-30,2021,Swindon Town,Barrow,2,1
2022-04-30,2021,Tranmere Rovers,Oldham Athletic,2,0
2022-05-02,2021,Salford City,Mansfield Town,2,2
2022-05-02,2021,Port Vale,Newport County,1,2
2022-05-07,2021,Barrow,Northampton Town,1,3
2022-05-07,2021,Bradford City,Carlisle United,2,0
2022-05-07,2021,Bristol Rovers,Scunthorpe United,7,0
2022-05-07,2021,Exeter City,Port Vale,0,1
2022-05-07,2021,Harrogate Town A.F.C.,Sutton United,0,2
2022-05-07,2021,Hartlepool United,Colchester United,0,2
2022-05-07,2021,Leyton Orient,Tranmere Rovers,0,1
2022-05-07,2021,Mansfield Town,Forest Green Rovers,2,2
2022-05-07,2021,Newport County,Rochdale,0,2
2022-05-07,2021,Oldham Athletic,Crawley Town,3,3
2022-05-07,2021,Stevenage Borough,Salford City,4,2
2022-05-07,2021,Walsall,Swindon Town,0,3

أنشئ جدولًا:

CREATE TABLE football
(
    `date` Date,
    `season` Int16,
    `home_team` LowCardinality(String),
    `away_team` LowCardinality(String),
    `home_team_goals` Int8,
    `away_team_goals` Int8
)
ENGINE = MergeTree
ORDER BY (date, home_team);

أدرِج البيانات باستخدام تنسيق CSVWithNames:

INSERT INTO football FROM INFILE 'football.csv' FORMAT CSVWithNames;

​

قراءة البيانات

اقرأ البيانات باستخدام تنسيق CSVWithNames:

SELECT *
FROM football
FORMAT CSVWithNames

سيكون الناتج ملف CSV بصفّ عناوين واحد:

"date","season","home_team","away_team","home_team_goals","away_team_goals"
"2022-04-30",2021,"Sutton United","Bradford City",1,4
"2022-04-30",2021,"Swindon Town","Barrow",2,1
"2022-04-30",2021,"Tranmere Rovers","Oldham Athletic",2,0
"2022-05-02",2021,"Port Vale","Newport County",1,2
"2022-05-02",2021,"Salford City","Mansfield Town",2,2
"2022-05-07",2021,"Barrow","Northampton Town",1,3
"2022-05-07",2021,"Bradford City","Carlisle United",2,0
"2022-05-07",2021,"Bristol Rovers","Scunthorpe United",7,0
"2022-05-07",2021,"Exeter City","Port Vale",0,1
"2022-05-07",2021,"Harrogate Town A.F.C.","Sutton United",0,2
"2022-05-07",2021,"Hartlepool United","Colchester United",0,2
"2022-05-07",2021,"Leyton Orient","Tranmere Rovers",0,1
"2022-05-07",2021,"Mansfield Town","Forest Green Rovers",2,2
"2022-05-07",2021,"Newport County","Rochdale",0,2
"2022-05-07",2021,"Oldham Athletic","Crawley Town",3,3
"2022-05-07",2021,"Stevenage Borough","Salford City",4,2
"2022-05-07",2021,"Walsall","Swindon Town",0,3

​

إعدادات التنسيق

إذا كان الإعداد input_format_with_names_use_header مضبوطًا على 1، فستُطابَق أعمدة بيانات الإدخال مع أعمدة الجدول بحسب أسمائها، وسيُتخطّى أي عمود يحمل اسمًا غير معروف إذا كان الإعداد input_format_skip_unknown_fields مضبوطًا على 1. أما خلاف ذلك، فسيُتخطّى الصف الأول.