PrettyJSONEachRow 형식
PrettyJSONEachRow 형식
PrettyJSONEachRow 형식은 JSONEachRow와 달리 새 줄 구분자와 4칸 들여쓰기로 JSON을 예쁘게(pretty) 포맷팅해요. 별칭은 PrettyJSONLines, PrettyNDJSON입니다. 출력 전용 형식입니다.
출처: 문서
본문
| Input | Output | Alias |
|---|---|---|
| ✗ | ✔ | PrettyJSONLines , PrettyNDJSON |
설명 (Description)
JSONEachRow와 다른 점은 JSON이 새 줄 구분자와 4칸 들여쓰기로 예쁘게 포맷팅된다는 점뿐입니다.
사용 예시 (Example usage)
데이터 읽기 (Reading data)
PrettyJSONEachRow 형식을 사용하여 데이터를 읽습니다:
SELECT *
FROM football
FORMAT PrettyJSONEachRow
출력은 JSON 형식이 됩니다:
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Sutton United",
"away_team": "Bradford City",
"home_team_goals": 1,
"away_team_goals": 4
}
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Swindon Town",
"away_team": "Barrow",
"home_team_goals": 2,
"away_team_goals": 1
}
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Tranmere Rovers",
"away_team": "Oldham Athletic",
"home_team_goals": 2,
"away_team_goals": 0
}
{
"date": "2022-05-02",
"season": 2021,
"home_team": "Port Vale",
"away_team": "Newport County",
"home_team_goals": 1,
"away_team_goals": 2
}
{
"date": "2022-05-02",
"season": 2021,
"home_team": "Salford City",
"away_team": "Mansfield Town",
"home_team_goals": 2,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Barrow",
"away_team": "Northampton Town",
"home_team_goals": 1,
"away_team_goals": 3
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Bradford City",
"away_team": "Carlisle United",
"home_team_goals": 2,
"away_team_goals": 0
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Bristol Rovers",
"away_team": "Scunthorpe United",
"home_team_goals": 7,
"away_team_goals": 0
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Exeter City",
"away_team": "Port Vale",
"home_team_goals": 0,
"away_team_goals": 1
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Harrogate Town A.F.C.",
"away_team": "Sutton United",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Hartlepool United",
"away_team": "Colchester United",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Leyton Orient",
"away_team": "Tranmere Rovers",
"home_team_goals": 0,
"away_team_goals": 1
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Mansfield Town",
"away_team": "Forest Green Rovers",
"home_team_goals": 2,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Newport County",
"away_team": "Rochdale",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Oldham Athletic",
"away_team": "Crawley Town",
"home_team_goals": 3,
"away_team_goals": 3
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Stevenage Borough",
"away_team": "Salford City",
"home_team_goals": 4,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Walsall",
"away_team": "Swindon Town",
"home_team_goals": 0,
"away_team_goals": 3
}