Terjemahan disediakan oleh mesin penerjemah. Jika konten terjemahan yang diberikan bertentangan dengan versi bahasa Inggris aslinya, utamakan versi bahasa Inggris.
meratakan perintah
catatan
Untuk melihat integrasi sumber AWS data mana yang mendukung PPL perintah ini, lihatCommands.
Gunakan perintah flatten untuk memperluas bidang dari jenis berikut:
struct<?,?>array<struct<?,?>>
Sintaks
Gunakan sintaks berikut:
flatten <field>
-
bidang: Bidang yang akan diratakan. Bidang harus dari tipe yang didukung.
Skema
| col_name | data_type |
|---|---|
| _waktu | string |
| menjembatani | <length:bigint, name:string>array <struktur> |
| kota | string |
| coor | struct<alt:bigint, lat:double, long:double> |
| negeri | string |
Data
| _waktu | menjembatani | kota | coor | negeri |
|---|---|---|---|---|
| 2024-09-13T 12:00:00 | [{801, Jembatan Menara}, {928, Jembatan London}] | London | {35, 51.5074, -0.1278} | Inggris |
| 2024-09-13T 12:00:00 | [{232, Pont Neuf}, {160, Pont Alexandre}] III | Paris | {35, 48.8566, 2.3522} | France |
| 2024-09-13T 12:00:00 | [{48, Jembatan Rialto}, {11, Jembatan Sighs}] | Venesia | {2, 45.4408, 12.3155} | Italy |
| 2024-09-13T 12:00:00 | [{***, Jembatan Charles}, {343, Jembatan Legiun}] | Praha | {200, 50,0755, 14.4378} | Czech Republic |
| 2024-09-13T 12:00:00 | [{375, Jembatan Rantai}, {333, Jembatan Liberty}] | Budapest | {96, 47.4979, 19.0402} | Hungary |
| 1990-09-13T 12:00:00 | NULL | Warsawa | NULL | Poland |
Contoh 1: meratakan struct
Contoh ini menunjukkan cara meratakan bidang struct.
PPLkueri:
source=table | flatten coor
| _waktu | menjembatani | kota | negeri | alt | lat | long |
|---|---|---|---|---|---|---|
| 2024-09-13T 12:00:00 | [{801, Jembatan Menara}, {928, Jembatan London}] | London | Inggris | 35 | 51.5074 | -0.1278 |
| 2024-09-13T 12:00:00 | [{232, Pont Neuf}, {160, Pont Alexandre}] III | Paris | France | 35 | 48.8566 | 2.3522 |
| 2024-09-13T 12:00:00 | [{48, Jembatan Rialto}, {11, Jembatan Sighs}] | Venesia | Italy | 2 | 45.4408 | 12.3155 |
| 2024-09-13T 12:00:00 | [{516, Jembatan Charles}, {343, Jembatan Legiun}] | Praha | Czech Republic | 200 | 50.0755 | 14.4378 |
| 2024-09-13T 12:00:00 | [{375, Jembatan Rantai}, {333, Jembatan Liberty}] | Budapest | Hungary | 96 | 47.4979 | 19.0402 |
| 1990-09-13T 12:00:00 | NULL | Warsawa | Poland | NULL | NULL | NULL |
Contoh 2: ratakan array
Contoh menunjukkan bagaimana untuk meratakan array bidang struct.
PPLkueri:
source=table | flatten bridges
| _waktu | kota | coor | negeri | length | name |
|---|---|---|---|---|---|
| 2024-09-13T 12:00:00 | London | {35, 51.5074, -0.1278} | Inggris | 801 | Jembatan Menara |
| 2024-09-13T 12:00:00 | London | {35, 51.5074, -0.1278} | Inggris | 928 | Jembatan London |
| 2024-09-13T 12:00:00 | Paris | {35, 48.8566, 2.3522} | France | 232 | Pont Neuf |
| 2024-09-13T 12:00:00 | Paris | {35, 48.8566, 2.3522} | France | 160 | Pont Alexandre III |
| 2024-09-13T 12:00:00 | Venesia | {2, 45.4408, 12.3155} | Italy | 48 | Jembatan Rialto |
| 2024-09-13T 12:00:00 | Venesia | {2, 45.4408, 12.3155} | Italy | 11 | Jembatan Sighs |
| 2024-09-13T 12:00:00 | Praha | {200, 50,0755, 14.4378} | Czech Republic | 516 | Jembatan Charles |
| 2024-09-13T 12:00:00 | Praha | {200, 50,0755, 14.4378} | Czech Republic | 343 | Jembatan Legiun |
| 2024-09-13T 12:00:00 | Budapest | {96, 47.4979, 19.0402} | Hungary | 375 | Jembatan Rantai |
| 2024-09-13T 12:00:00 | Budapest | {96, 47.4979, 19.0402} | Hungary | 333 | Jembatan Liberty |
| 1990-09-13T 12:00:00 | Warsawa | NULL | Poland | NULL | NULL |
Contoh 3: ratakan array dan struct
Contoh ini menunjukkan cara meratakan beberapa bidang.
PPLkueri:
source=table | flatten bridges | flatten coor
| _waktu | kota | negeri | length | name | alt | lat | long |
|---|---|---|---|---|---|---|---|
| 2024-09-13T 12:00:00 | London | Inggris | 801 | Jembatan Menara | 35 | 51.5074 | -0.1278 |
| 2024-09-13T 12:00:00 | London | Inggris | 928 | Jembatan London | 35 | 51.5074 | -0.1278 |
| 2024-09-13T 12:00:00 | Paris | France | 232 | Pont Neuf | 35 | 48.8566 | 2.3522 |
| 2024-09-13T 12:00:00 | Paris | France | 160 | Pont Alexandre III | 35 | 48.8566 | 2.3522 |
| 2024-09-13T 12:00:00 | Venesia | Italy | 48 | Jembatan Rialto | 2 | 45.4408 | 12.3155 |
| 2024-09-13T 12:00:00 | Venesia | Italy | 11 | Jembatan Sighs | 2 | 45.4408 | 12.3155 |
| 2024-09-13T 12:00:00 | Praha | Czech Republic | 516 | Jembatan Charles | 200 | 50.0755 | 14.4378 |
| 2024-09-13T 12:00:00 | Praha | Czech Republic | 343 | Jembatan Legiun | 200 | 50.0755 | 14.4378 |
| 2024-09-13T 12:00:00 | Budapest | Hungary | 375 | Jembatan Rantai | 96 | 47.4979 | 19.0402 |
| 2024-09-13T 12:00:00 | Budapest | Hungary | 333 | Jembatan Liberty | 96 | 47.4979 | 19.0402 |
| 1990-09-13T 12:00:00 | Warsawa | Poland | NULL | NULL | NULL | NULL | NULL |
