Mengueri metatable berdasarkan kondisi tertentu.
Deskripsi operasi
Hanya tabel mesin MaxCompute dan EMR yang didukung untuk pencarian.
Coba sekarang
Test
RAM authorization
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| PageNumber |
integer |
No |
Nomor halaman. |
1 |
| PageSize |
integer |
No |
Jumlah entri per halaman. Nilai default: 10. Nilai maksimum: 100. |
10 |
| AppGuid |
string |
No |
GUID workspace tempat metatable berada. |
odps.engine_name |
| Keyword |
string |
Yes |
Kata kunci yang digunakan untuk mengueri metatable. Selama proses kueri, sistem melakukan tokenisasi nama metatable dan mencocokkan nama tersebut dengan kata kunci. Jika tidak ada nama yang cocok, nilai null akan dikembalikan. Secara default, sistem menggunakan garis bawah (_) untuk melakukan tokenisasi nama. |
test |
| EntityType |
integer |
No |
Tipe metatable. Nilai yang valid: 0 dan 1. Nilai 0 menunjukkan bahwa tabel dikueri. Nilai 1 menunjukkan bahwa view dikueri. Jika Anda tidak mengonfigurasi parameter ini, semua tipe metatable akan dikueri. |
0 |
| ClusterId |
string |
No |
ID cluster EMR. Parameter ini hanya diperlukan jika Anda menyetel parameter DataSourceType ke emr. Anda dapat masuk ke konsol EMR untuk mendapatkan ID-nya. |
abc |
| DataSourceType |
string |
No |
Tipe sumber data. Nilai yang valid: odps dan emr. |
emr |
| Schema |
string |
No |
Informasi skema tabel. Anda harus mengonfigurasi parameter ini jika Anda mengaktifkan model tiga lapis MaxCompute. |
default |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
Parameter respons. |
||
| HttpStatusCode |
integer |
Kode status HTTP. |
200 |
| ErrorMessage |
string |
Pesan error. |
The specified parameters are invalid. |
| RequestId |
string |
ID permintaan. |
0bc1ec92159376**** |
| Success |
boolean |
Menunjukkan apakah permintaan berhasil. |
true |
| ErrorCode |
string |
Kode error. |
1031203110005 |
| Data |
object |
Hasil pencarian. |
|
| PageNumber |
integer |
Nomor halaman. |
1 |
| PageSize |
integer |
Jumlah entri per halaman. |
10 |
| TotalCount |
integer |
Jumlah total metatable. |
100 |
| DataEntityList |
array<object> |
Daftar metatable. |
|
|
object |
|||
| TableName |
string |
The name of the metatable. |
test_name |
| DatabaseName |
string |
The name of the metadatabase. |
abc |
| EntityType |
integer |
The type of the metatable. Valid values:
|
0 |
| ProjectName |
string |
The name of the workspace. |
test |
| ProjectId |
integer |
The ID of the workspace. |
323 |
| TableGuid |
string |
The GUID of the metatable. |
odps.engine_name.test_name |
| OwnerId |
string |
The ID of the Alibaba Cloud account used by the workspace owner. |
123 |
| ClusterId |
string |
The ID of the EMR cluster. |
abc |
| EnvType |
integer |
The type of the environment. Valid values:
|
1 |
| TenantId |
integer |
The tenant ID. |
12345 |
| Schema |
string |
The schema information of the table. You must configure this parameter if you enable the three-layer model of MaxCompute. |
default |
Contoh
Respons sukses
JSONformat
{
"HttpStatusCode": 200,
"ErrorMessage": "The specified parameters are invalid.",
"RequestId": "0bc1ec92159376****",
"Success": true,
"ErrorCode": "1031203110005",
"Data": {
"PageNumber": 1,
"PageSize": 10,
"TotalCount": 100,
"DataEntityList": [
{
"TableName": "test_name",
"DatabaseName": "abc",
"EntityType": 0,
"ProjectName": "test",
"ProjectId": 323,
"TableGuid": "odps.engine_name.test_name",
"OwnerId": "123",
"ClusterId": "abc",
"EnvType": 1,
"TenantId": 12345,
"Schema": "default"
}
]
}
}Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | Invalid.Meta.TableNotExist | The table does not exist. | |
| 400 | InvalidParameter.Meta.CommonError | The specified parameter is invalid. | |
| 400 | InvalidParameter.Meta.Illegal | The app guid parameter is invalid. | |
| 400 | InvalidParameter.Meta.IllegalDate | The date format is invalid. | |
| 400 | InvalidParameter.Meta.IllegalPageError | The parameter for paging is invalid. | |
| 400 | InvalidParameter.Meta.NotExist | The object does not exist. | |
| 400 | InternalError.UserId.Missing | An internal system error occurred. Try again later. | |
| 400 | InternalError.Meta.NoCalcEngine | An error occurred while retrieving the compute engine based on the MaxCompute project. | |
| 500 | InternalError.System | An internal system error occurred. Try again later. | |
| 500 | InternalError.Meta.TenantTimeOut | Failed to connect to the interface network. | |
| 500 | InternalError.Meta.Unknown | An unknown error occurred while processing your request. | |
| 403 | ResourceNotAuthorized.Api | You are not authorized to access the resources. | |
| 403 | Forbidden.Meta.NoTenant | The user is not the owner of any tenants. | |
| 403 | Forbidden.Access | Access is forbidden. Please first activate DataWorks Enterprise Edition or Flagship Edition. | |
| 429 | Throttling.Api | The request for this resource has exceeded your available limit. | |
| 429 | Throttling.Api.Risk | The request for this resource has exceeded your daily available limit. | |
| 429 | Throttling.System | The DataWorks system is busy. Try again later. | |
| 429 | Throttling.User | Your request is too frequent. Try again later. |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.