JSONCompactStringsEachRowWithNamesAndTypes

الإدخال	الإخراج	الاسم المستعار
✔	✔

الوصف

يختلف عن تنسيق JSONCompactEachRow إذ يطبع أيضًا صفَّين للترويسة يتضمنان أسماء الأعمدة وأنواعها، على غرار TabSeparatedWithNamesAndTypes.

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

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

باستخدام ملف JSON يتضمن البيانات التالية، والمسمّى football.json:

["date", "season", "home_team", "away_team", "home_team_goals", "away_team_goals"]
["Date", "Int16", "LowCardinality(String)", "LowCardinality(String)", "Int8", "Int8"]
["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"]

أدرج البيانات:

INSERT INTO football FROM INFILE 'football.json' FORMAT JSONCompactStringsEachRowWithNamesAndTypes;

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

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

SELECT *
FROM football
FORMAT JSONCompactStringsEachRowWithNamesAndTypes

سيكون الإخراج بتنسيق JSON:

["date", "season", "home_team", "away_team", "home_team_goals", "away_team_goals"]
["Date", "Int16", "LowCardinality(String)", "LowCardinality(String)", "Int8", "Int8"]
["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. وإلا فسيتم تخطي الصف الأول.

إذا كان الإعداد input_format_with_types_use_header مضبوطًا على 1، فستُقارَن أنواع بيانات الإدخال بأنواع الأعمدة المقابلة في الجدول. وإلا فسيتم تخطي الصف الثاني.

​الوصف

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

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

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

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

الوصف

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

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

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

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