Gunakan ListDoctorHiveTables untuk mendapatkan hasil analisis tabel Hive - E-MapReduce - Alibaba Cloud - E-MapReduce

Mengambil hasil analisis beberapa tabel Hive dalam satu pengatur waktu di E-MapReduce (EMR) Doctor.

Deskripsi operasi

list Doctor Hive Tables

Coba sekarang

Coba API ini di OpenAPI Explorer tanpa perlu penandatanganan manual. Panggilan yang berhasil akan secara otomatis menghasilkan contoh kode SDK sesuai dengan parameter Anda. Unduh kode tersebut dengan kredensial bawaan yang aman untuk penggunaan lokal.

Test

RAM authorization

Tabel berikut menjelaskan otorisasi yang diperlukan untuk memanggil API ini. Anda dapat menentukannya dalam kebijakan Resource Access Management (RAM). Kolom pada tabel dijelaskan sebagai berikut:

Action: Aksi yang dapat digunakan dalam elemen Action pada pernyataan kebijakan izin RAM untuk memberikan izin guna melakukan operasi tersebut.
API: API yang dapat Anda panggil untuk melakukan aksi tersebut.
Access level: Tingkat akses yang telah ditentukan untuk setiap API. Nilai yang valid: create, list, get, update, dan delete.
Resource type: Jenis resource yang mendukung otorisasi untuk melakukan aksi tersebut. Ini menunjukkan apakah aksi tersebut mendukung izin tingkat resource. Resource yang ditentukan harus kompatibel dengan aksi tersebut. Jika tidak, kebijakan tersebut tidak akan berlaku.
- Untuk API dengan izin tingkat resource, jenis resource yang diperlukan ditandai dengan tanda bintang (*). Tentukan Nama Sumber Daya Alibaba Cloud (ARN) yang sesuai dalam elemen Resource pada kebijakan.
- Untuk API tanpa izin tingkat resource, ditampilkan sebagai All Resources. Gunakan tanda bintang (*) dalam elemen Resource pada kebijakan.
Condition key: Kunci kondisi yang didefinisikan oleh layanan. Kunci ini memungkinkan kontrol granular, berlaku baik hanya untuk aksi maupun untuk aksi yang terkait dengan resource tertentu. Selain kunci kondisi spesifik layanan, Alibaba Cloud menyediakan serangkaian common condition keys yang berlaku di semua layanan yang didukung RAM.
Dependent action: Aksi dependen yang diperlukan untuk menjalankan aksi tersebut. Untuk menyelesaikan aksi tersebut, pengguna RAM atau role RAM harus memiliki izin untuk melakukan semua aksi dependen.

Action

Access level

Resource type

Condition key

Dependent action

emr:ListDoctorHiveTables

list

*All Resource

*

None

Parameter permintaan

Parameter	Type	Required	Description	Example
RegionId	string	Yes	ID wilayah.	cn-hangzhou
ClusterId	string	Yes	ID kluster.	c-b933c5aac8fe****
NextToken	string	No	Token paginasi yang digunakan di permintaan untuk mengambil halaman hasil baru.	DD6B1B2A-5837-5237-ABE4-FF0C89568980
MaxResults	integer	No	Jumlah maksimum entri yang dikembalikan pada setiap halaman.	20
DateTime	string	Yes	Tentukan tanggal dalam standar ISO 8601. Misalnya, 2023-01-01 mewakili 1 Januari 2023.	2023-01-01
TableNames	array	No	Nama tabel yang digunakan untuk memfilter hasil kueri.	null
	string	No	The table name. The table name must follow the naming rule in Hive. A name in the {database name.table identifier} format uniquely identifies a table.	dw.dwd_creta_service_order_long_renew_long_da
OrderType	string	No	Pesanan pengurutan hasil kueri. Nilai valid: ASC: urutan menaik DESC: urutan menurun.	ASC
OrderBy	string	No	Dasar pengurutan hasil kueri. Nilai valid: partitionNum: jumlah partisi. totalFileCount: jumlah total file. largeFileCount: jumlah file Tingkat Tinggi. File Tingkat Tinggi adalah file dengan ukuran lebih dari 1 GB. mediumFileCount: jumlah file Menengah. File Menengah adalah file dengan ukuran lebih dari atau sama dengan 128 MB dan kurang dari atau sama dengan 1 GB. smallFileCount: jumlah file kecil. File kecil adalah file dengan ukuran lebih dari atau sama dengan 10 MB dan kurang dari 128 MB. tinyFileCount: jumlah file sangat kecil. File sangat kecil adalah file dengan ukuran lebih dari 0 MB dan kurang dari 10 MB. emptyFileCount: jumlah file kosong. File kosong adalah file dengan ukuran 0 MB. largeFileRatio: proporsi file Tingkat Tinggi. File Tingkat Tinggi adalah file dengan ukuran lebih dari 1 GB. mediumFileRatio: proporsi file Menengah. File Menengah adalah file dengan ukuran lebih dari atau sama dengan 128 MB dan kurang dari atau sama dengan 1 GB. smallFileRatio: proporsi file kecil. File kecil adalah file dengan ukuran lebih dari atau sama dengan 10 MB dan kurang dari 128 MB. tinyFileRatio: proporsi file sangat kecil. File sangat kecil adalah file dengan ukuran lebih dari 0 MB dan kurang dari 10 MB. emptyFileRatio: proporsi file kosong. File kosong adalah file dengan ukuran 0 MB. hotDataSize: jumlah data panas. Data panas merujuk pada data yang diakses dalam tujuh hari terakhir. WarmDataSize: jumlah data hangat. Data hangat merujuk pada data yang tidak diakses selama lebih dari 7 hari tetapi diakses dalam 30 hari terakhir. coldDataSize: jumlah data dingin. Data dingin merujuk pada data yang tidak diakses selama lebih dari 30 hari tetapi diakses dalam 90 hari terakhir. freezeDataSize: jumlah data sangat dingin. Data sangat dingin merujuk pada data yang tidak diakses selama lebih dari 90 hari. totalDataSize: jumlah total data. hotDataRatio: proporsi data panas. Data panas merujuk pada data yang diakses dalam tujuh hari terakhir. WarmDataRatio: proporsi data hangat. Data hangat merujuk pada data yang tidak diakses selama lebih dari 7 hari tetapi diakses dalam 30 hari terakhir. coldDataRatio: proporsi data dingin. Data dingin merujuk pada data yang tidak diakses selama lebih dari 30 hari tetapi diakses dalam 90 hari terakhir. freezeDataRatio: proporsi data sangat dingin. Data sangat dingin merujuk pada data yang tidak diakses selama lebih dari 90 hari. totalFileDayGrowthCount: penambahan harian jumlah total file. largeFileDayGrowthCount: penambahan harian jumlah file Tingkat Tinggi. File Tingkat Tinggi adalah file dengan ukuran lebih dari 1 GB. mediumFileDayGrowthCount: penambahan harian jumlah file Menengah. File Menengah adalah file dengan ukuran lebih dari atau sama dengan 128 MB dan kurang dari atau sama dengan 1 GB. smallFileDayGrowthCount: penambahan harian jumlah file kecil. File kecil adalah file dengan ukuran lebih dari atau sama dengan 10 MB dan kurang dari 128 MB. tinyFileDayGrowthCount: penambahan harian jumlah file sangat kecil. File sangat kecil adalah file dengan ukuran lebih dari 0 MB dan kurang dari 10 MB. emptyFileDayGrowthCount: penambahan harian jumlah file kosong. File kosong adalah file dengan ukuran 0 MB. hotDataDayGrowthSize: penambahan harian jumlah data panas. Data panas merujuk pada data yang diakses dalam tujuh hari terakhir. warmDataDayGrowthSize: penambahan harian jumlah data hangat. Data hangat merujuk pada data yang tidak diakses selama lebih dari 7 hari tetapi diakses dalam 30 hari terakhir. coldDataDayGrowthSize: penambahan harian jumlah data dingin. Data dingin merujuk pada data yang tidak diakses selama lebih dari 30 hari tetapi diakses dalam 90 hari terakhir. freezeDataDayGrowthSize: penambahan harian jumlah data sangat dingin. Data sangat dingin merujuk pada data yang tidak diakses selama lebih dari 90 hari. totalDataDayGrowthSize: penambahan harian jumlah total data. totalFileCountDayGrowthRatio: laju pertumbuhan harian jumlah total file. largeFileCountDayGrowthRatio: laju pertumbuhan harian jumlah file Tingkat Tinggi. File Tingkat Tinggi adalah file dengan ukuran lebih dari 1 GB. mediumFileCountDayGrowthRatio: laju pertumbuhan harian jumlah file Menengah. File Menengah adalah file dengan ukuran lebih dari atau sama dengan 128 MB dan kurang dari atau sama dengan 1 GB. smallFileCountDayGrowthRatio: laju pertumbuhan harian jumlah file kecil. File kecil adalah file dengan ukuran lebih dari atau sama dengan 10 MB dan kurang dari 128 MB. tinyFileCountDayGrowthRatio: laju pertumbuhan harian jumlah file sangat kecil. File sangat kecil adalah file dengan ukuran lebih dari 0 MB dan kurang dari 10 MB. emptyFileCountDayGrowthRatio: laju pertumbuhan harian jumlah file kosong. File kosong adalah file dengan ukuran 0 MB. hotDataSizeDayGrowthRatio: laju pertumbuhan harian jumlah data panas. Data panas merujuk pada data yang diakses dalam tujuh hari terakhir. warmDataSizeDayGrowthRatio: laju pertumbuhan harian jumlah data hangat. Data hangat merujuk pada data yang tidak diakses selama lebih dari 7 hari tetapi diakses dalam 30 hari terakhir. coldDataSizeDayGrowthRatio: laju pertumbuhan harian jumlah data dingin. Data dingin merujuk pada data yang tidak diakses selama lebih dari 30 hari tetapi diakses dalam 90 hari terakhir. freezeDataSizeDayGrowthRatio: laju pertumbuhan harian jumlah data sangat dingin. Data sangat dingin merujuk pada data yang tidak diakses selama lebih dari 90 hari. totalDataSizeDayGrowthRatio: laju pertumbuhan harian jumlah total data.	totalFileCount

Elemen respons

Element	Type	Description	Example
	object	The response parameters.
Data	array<object>	The analysis results of Hive tables.
	array<object>
TableName	string	The table name. The table name must follow the naming rule in Hive. A name in the {Database name.Table name} format uniquely identifies a table.	dw.dwd_creta_service_order_long_renew_long_da
Owner	string	The owner.	DW
Formats	array<object>	The table format information.
	object
FormatName	string	The name of the storage format.	TextInputFormat
FormatSize	integer	The amount of data in the format.	506930200
FormatSizeUnit	string	The unit of the amount of data in the format.	MB
FormatRatio	number	The proportion of the data in the format.	0.23
FormatDayGrowthSize	integer	The daily increment of data in the format.	1232124
FormatSizeDayGrowthRatio	number	The day-to-day growth rate of data in the format.	0.04
Metrics	object	The metric information.
PartitionNum	object	The number of partitions.
Name	string	The name of the metric.	partitionNum
Value	integer	The value of the metric.	331
Unit	string	The unit of the metric.	“”
Description	string	The description of the metric.	number of partitions
LargeFileCount	object	The number of large files. Large files are those with a size greater than 1 GB.
Name	string	The name of the metric.	largeFileCount
Value	integer	The value of the metric.	132
Unit	string	The unit of the metric.	“”
Description	string	The description of the metric.	Number of large files
MediumFileCount	object	The number of medium files. Medium files are those with a size greater than or equal to 128 MB and less than or equal to 1 GB.
Name	string	The name of the metric.	mediumFileCount
Value	integer	The value of the metric.	5
Unit	string	The unit of the metric.	“”
Description	string	The description of the metric.	Number of medium files
SmallFileCount	object	The number of small files. Small files are those with a size greater than or equal to 10 MB and less than 128 MB.
Name	string	The name of the metric.	smallFileCount
Value	integer	The value of the metric.	18
Unit	string	The unit of the metric.	"“
Description	string	The description of the metric.	Number of small files
TinyFileCount	object	The number of very small files. Very small files are those with a size greater than 0 MB and less than 10 MB.
Name	string	The name of the metric.	tinyFileCount
Value	integer	The value of the metric.	451
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Number of tiny files
EmptyFileCount	object	The number of empty files. Empty files are those with a size of 0 MB.
Name	string	The name of the metric.	emptyFileCount
Value	integer	The value of the metric.	3123
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Number of empty files
TotalFileCount	object	The total number of files.
Name	string	The name of the metric.	totalFileCount
Value	integer	The value of the metric.	123
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Number of total files
LargeFileRatio	object	The proportion of large files. Large files are those with a size greater than 1 GB.
Name	string	The name of the metric.	largeFileRatio
Value	number	The value of the metric.	0.02
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Ratio of large files
MediumFileRatio	object	The proportion of medium files. Medium files are those with a size greater than or equal to 128 MB and less than or equal to 1 GB.
Name	string	The name of the metric.	mediumFileRatio
Value	number	The value of the metric.	0.8
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Ratio of medium files
SmallFileRatio	object	The proportion of small files. Small files are those with a size greater than or equal to 10 MB and less than 128 MB.
Name	string	The name of the metric.	smallFileRatio
Value	number	The value of the metric.	0.04
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Ratio of small files
TinyFileRatio	object	The proportion of very small files. Very small files are those with a size greater than 0 MB and less than 10 MB.
Name	string	The name of the metric.	tinyFileRatio
Value	number	The value of the metric.	0.96
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Ratio of tiny files
EmptyFileRatio	object	The proportion of empty files. Empty files are those with a size of 0 MB.
Name	string	The name of the metric.	emptyFileRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Ratio of empty files
HotDataSize	object	The amount of hot data. Hot data refers to data that is accessed in previous seven days.
Name	string	The name of the metric.	hotDataSize
Value	integer	The value of the metric.	203431
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Size of the hot data size
WarmDataSize	object	The amount of warm data. Warm data refers to data that is not accessed for more than 7 days but is accessed in previous 30 days.
Name	string	The name of the metric.	warmDataSize
Value	integer	The value of the metric.	14981
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Size of the warm data size
ColdDataSize	object	The amount of cold data. Cold data refers to data that is not accessed for more than 30 days but is accessed in previous 90 days.
Name	string	The name of the metric.	coldDataSize
Value	integer	The value of the metric.	217715
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Size of the cold data size
FreezeDataSize	object	The amount of very cold data. Very cold data refers to data that is not accessed for more than 90 days.
Name	string	The name of the metric.	freezeDataSize
Value	integer	The value of the metric.	33229309
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Size of the freeze data size
TotalDataSize	object	The total amount of data.
Name	string	The name of the metric.	totalDataSize
Value	integer	The value of the metric.	33800296
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Total data size in megabytes (MB)
HotDataRatio	object	The proportion of hot data. Hot data refers to data that is accessed in previous seven days.
Name	string	The name of the metric.	hotDataRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Hot data ratio
WarmDataRatio	object	The proportion of warm data. Warm data refers to data that is not accessed for more than 7 days but is accessed in previous 30 days.
Name	string	The name of the metric.	warmDataRatio
Value	number	The value of the metric.	0.1
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Ratio of warm data
ColdDataRatio	object	The proportion of cold data. Cold data refers to data that is not accessed for more than 30 days but is accessed in previous 90 days.
Name	string	The name of the metric.	coldDataRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Cold data ratio
FreezeDataRatio	object	The proportion of very cold data. Very cold data refers to data that is not accessed for more than 90 days.
Name	string	The name of the metric.	freezeDataRatio
Value	number	The value of the metric.	0.98
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Ratio of freeze data
TotalFileDayGrowthCount	object	The daily increment of the total number of files.
Name	string	The name of the metric.	totalFileDayGrowthCount
Value	integer	The value of the metric.	100
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Day growth count of total files
LargeFileDayGrowthCount	object	The daily increment of the number of large files. Large files are those with a size greater than 1 GB.
Name	string	The name of the metric.	largeFileDayGrowthCount
Value	integer	The value of the metric.	40
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Day growth count of large files
MediumFileDayGrowthCount	object	The daily increment of the number of medium files. Medium files are those with a size greater than or equal to 128 MB and less than or equal to 1 GB.
Name	string	The name of the metric.	mediumFileDayGrowthCount
Value	integer	The value of the metric.	20
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Day growth count of medium files
SmallFileDayGrowthCount	object	The daily increment of the number of small files. Small files are those with a size greater than or equal to 10 MB and less than 128 MB.
Name	string	The name of the metric.	smallFileDayGrowthCount
Value	integer	The value of the metric.	18
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth count of small files
TinyFileDayGrowthCount	object	The daily increment of the number of very small files. Very small files are those with a size greater than 0 MB and less than 10 MB.
Name	string	The name of the metric.	tinyFileDayGrowthCount
Value	integer	The value of the metric.	482
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth count of tiny files
EmptyFileDayGrowthCount	object	The daily increment of the number of empty files. Empty files are those with a size of 0 MB.
Name	string	The name of the metric.	emptyFileDayGrowthCount
Value	integer	The value of the metric.	-20
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth count of empty files
HotDataDayGrowthSize	object	The daily increment of the amount of hot data. Hot data refers to data that is accessed in previous seven days.
Name	string	The name of the metric.	hotDataDayGrowthSize
Value	integer	The value of the metric.	203431
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Day growth size of hot data
WarmDataDayGrowthSize	object	The daily increment of the amount of warm data. Warm data refers to data that is not accessed for more than 7 days but is accessed in previous 30 days.
Name	string	The name of the metric.	warmDataDayGrowthSize
Value	integer	The value of the metric.	149841
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Day growth size of warm data
ColdDataDayGrowthSize	object	The daily increment of the amount of cold data. Cold data refers to data that is not accessed for more than 30 days but is accessed in previous 90 days.
Name	string	The name of the metric.	coldDataDayGrowthSize
Value	integer	The value of the metric.	217715
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Day growth size of cold data
FreezeDataDayGrowthSize	object	The daily increment of the amount of very cold data. Very cold data refers to data that is not accessed for more than 90 days.
Name	string	The name of the metric.	freezeDataDayGrowthSize
Value	integer	The value of the metric.	33229309
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Day growth size of freeze data
TotalDataDayGrowthSize	object	The daily increment of the total amount of data.
Name	string	The name of the metric.	totalDataDayGrowthSize
Value	integer	The value of the metric.	33800296
Unit	string	The unit of the metric.	MB
Description	string	The description of the metric.	Day growth size of total data
TotalFileCountDayGrowthRatio	object	The day-to-day growth rate of the total number of files.
Name	string	The name of the metric.	totalFileCountDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of total files
LargeFileCountDayGrowthRatio	object	The day-to-day growth rate of the number of large files. Large files are those with a size greater than 1 GB.
Name	string	The name of the metric.	largeFileCountDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of large files
MediumFileCountDayGrowthRatio	object	The day-to-day growth rate of the number of medium files. Medium files are those with a size greater than or equal to 128 MB and less than or equal to 1 GB.
Name	string	The name of the metric.	mediumFileCountDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of medium files
SmallFileCountDayGrowthRatio	object	The day-to-day growth rate of the number of small files. Small files are those with a size greater than or equal to 10 MB and less than 128 MB.
Name	string	The name of the metric.	smallFileCountDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of small files
TinyFileCountDayGrowthRatio	object	The day-to-day growth rate of the number of very small files. Very small files are those with a size greater than 0 MB and less than 10 MB.
Name	string	The name of the metric.	tinyFileCountDayGrowthRatio
Value	number	The value of the metric.	0.04
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of tiny files
EmptyFileCountDayGrowthRatio	object	The day-to-day growth rate of the number of empty files. Empty files are those with a size of 0 MB.
Name	string	The name of the metric.	emptyFileCountDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of empty files
HotDataSizeDayGrowthRatio	object	The day-to-day growth rate of the amount of hot data. Hot data refers to data that is accessed in previous seven days.
Name	string	The name of the metric.	hotDataSizeDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of hot data size
WarmDataSizeDayGrowthRatio	object	The day-to-day growth rate of the amount of warm data. Warm data refers to data that is not accessed for more than 7 days but is accessed in previous 30 days.
Name	string	The name of the metric.	warmDataSizeDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of warm data size
ColdDataSizeDayGrowthRatio	object	The day-to-day growth rate of the amount of cold data. Cold data refers to data that is not accessed for more than 30 days but is accessed in previous 90 days.
Name	string	The name of the metric.	coldDataSizeDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	""
Description	string	The description of the metric.	Day growth ratio of cold data size
FreezeDataSizeDayGrowthRatio	object	The day-to-day growth rate of the amount of very cold data. Very cold data refers to data that is not accessed for more than 90 days.
Name	string	The name of the metric.	freezeDataSizeDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of freeze data size
TotalDataSizeDayGrowthRatio	object	The day-to-day growth rate of the total amount of data.
Name	string	The name of the metric.	totalDataSizeDayGrowthRatio
Value	number	The value of the metric.	0.01
Unit	string	The unit of the metric.	”“
Description	string	The description of the metric.	Day growth ratio of total data size
Analysis	object	The analysis results.
HiveFrequencyScore	integer	The score for the access frequency of the Hive table.	70
HiveDistributionScore	integer	The score for the file sizes of the Hive table.	80
HiveFormatScore	integer	The score for the data formats of the Hive table.	60
HiveScore	integer	The overall score of the Hive table.	80
RequestId	string	The request ID.	DD6B1B2A-5837-5237-ABE4-FF0C8944****
NextToken	string	A pagination token.	DD6B1B2A-5837-5237-ABE4-FF0C89568980
MaxResults	integer	The maximum number of entries that are returned.	20
TotalCount	integer	The total number of entries returned.	200

Contoh

Respons sukses

JSONformat

{
  "Data": [
    {
      "TableName": "dw.dwd_creta_service_order_long_renew_long_da\n",
      "Owner": "DW",
      "Formats": [
        {
          "FormatName": "TextInputFormat",
          "FormatSize": 506930200,
          "FormatSizeUnit": "MB\n",
          "FormatRatio": 0.23,
          "FormatDayGrowthSize": 1232124,
          "FormatSizeDayGrowthRatio": 0.04
        }
      ],
      "Metrics": {
        "PartitionNum": {
          "Name": "partitionNum",
          "Value": 331,
          "Unit": "“”",
          "Description": "number of partitions\n"
        },
        "LargeFileCount": {
          "Name": "largeFileCount",
          "Value": 132,
          "Unit": "“”\n",
          "Description": "Number of large files\n"
        },
        "MediumFileCount": {
          "Name": "mediumFileCount",
          "Value": 5,
          "Unit": "“”\n",
          "Description": "Number of medium files"
        },
        "SmallFileCount": {
          "Name": "smallFileCount",
          "Value": 18,
          "Unit": "\"“\n",
          "Description": "Number of small files\n"
        },
        "TinyFileCount": {
          "Name": "tinyFileCount",
          "Value": 451,
          "Unit": "”“\n",
          "Description": "Number of tiny files\n"
        },
        "EmptyFileCount": {
          "Name": "emptyFileCount",
          "Value": 3123,
          "Unit": "”“\n",
          "Description": "Number of empty files\n"
        },
        "TotalFileCount": {
          "Name": "totalFileCount",
          "Value": 123,
          "Unit": "”“\n",
          "Description": "Number of total files\n"
        },
        "LargeFileRatio": {
          "Name": "largeFileRatio",
          "Value": 0.02,
          "Unit": "”“\n",
          "Description": "Ratio of large files\n"
        },
        "MediumFileRatio": {
          "Name": "mediumFileRatio",
          "Value": 0.8,
          "Unit": "”“\n",
          "Description": "Ratio of medium files\n"
        },
        "SmallFileRatio": {
          "Name": "smallFileRatio",
          "Value": 0.04,
          "Unit": "”“\n",
          "Description": "Ratio of small files\n"
        },
        "TinyFileRatio": {
          "Name": "tinyFileRatio",
          "Value": 0.96,
          "Unit": "\"\"\n",
          "Description": "Ratio of tiny files\n"
        },
        "EmptyFileRatio": {
          "Name": "emptyFileRatio",
          "Value": 0.01,
          "Unit": "\"\"\n",
          "Description": "Ratio of empty files\n"
        },
        "HotDataSize": {
          "Name": "hotDataSize",
          "Value": 203431,
          "Unit": "MB\n",
          "Description": "Size of the hot data size\n"
        },
        "WarmDataSize": {
          "Name": "warmDataSize",
          "Value": 14981,
          "Unit": "MB\n",
          "Description": "Size of the warm data size\n"
        },
        "ColdDataSize": {
          "Name": "coldDataSize",
          "Value": 217715,
          "Unit": "MB\n",
          "Description": "Size of the cold data size\n"
        },
        "FreezeDataSize": {
          "Name": "freezeDataSize",
          "Value": 33229309,
          "Unit": "MB\n",
          "Description": "Size of the freeze data size"
        },
        "TotalDataSize": {
          "Name": "totalDataSize",
          "Value": 33800296,
          "Unit": "MB\n",
          "Description": "Total data size in megabytes (MB)\n"
        },
        "HotDataRatio": {
          "Name": "hotDataRatio",
          "Value": 0.01,
          "Unit": "\"\"\n",
          "Description": "Hot data ratio\n"
        },
        "WarmDataRatio": {
          "Name": "warmDataRatio",
          "Value": 0.1,
          "Unit": "\"\"\n",
          "Description": "Ratio of warm data\n"
        },
        "ColdDataRatio": {
          "Name": "coldDataRatio",
          "Value": 0.01,
          "Unit": "\t\n\"\"\n",
          "Description": "Cold data ratio\n"
        },
        "FreezeDataRatio": {
          "Name": "freezeDataRatio",
          "Value": 0.98,
          "Unit": "\"\"\n",
          "Description": "Ratio of freeze data\n"
        },
        "TotalFileDayGrowthCount": {
          "Name": "totalFileDayGrowthCount",
          "Value": 100,
          "Unit": "\"\"",
          "Description": "Day growth count of total files\n"
        },
        "LargeFileDayGrowthCount": {
          "Name": "largeFileDayGrowthCount",
          "Value": 40,
          "Unit": "\"\"\n",
          "Description": "Day growth count of large files\n"
        },
        "MediumFileDayGrowthCount": {
          "Name": "mediumFileDayGrowthCount",
          "Value": 20,
          "Unit": "\"\"\n",
          "Description": "Day growth count of medium files\n"
        },
        "SmallFileDayGrowthCount": {
          "Name": "smallFileDayGrowthCount",
          "Value": 18,
          "Unit": "”“\n",
          "Description": "Day growth count of small files\n"
        },
        "TinyFileDayGrowthCount": {
          "Name": "tinyFileDayGrowthCount",
          "Value": 482,
          "Unit": "”“\n",
          "Description": "Day growth count of tiny files\n"
        },
        "EmptyFileDayGrowthCount": {
          "Name": "emptyFileDayGrowthCount",
          "Value": -20,
          "Unit": "”“\n",
          "Description": "Day growth count of empty files\n"
        },
        "HotDataDayGrowthSize": {
          "Name": "hotDataDayGrowthSize",
          "Value": 203431,
          "Unit": "MB\n",
          "Description": "Day growth size of hot data\n"
        },
        "WarmDataDayGrowthSize": {
          "Name": "warmDataDayGrowthSize",
          "Value": 149841,
          "Unit": "MB\n",
          "Description": "Day growth size of warm data\n"
        },
        "ColdDataDayGrowthSize": {
          "Name": "coldDataDayGrowthSize",
          "Value": 217715,
          "Unit": "MB\n",
          "Description": "Day growth size of cold data\n"
        },
        "FreezeDataDayGrowthSize": {
          "Name": "freezeDataDayGrowthSize",
          "Value": 33229309,
          "Unit": "MB\n",
          "Description": "Day growth size of freeze data\n"
        },
        "TotalDataDayGrowthSize": {
          "Name": "totalDataDayGrowthSize",
          "Value": 33800296,
          "Unit": "MB\n",
          "Description": "Day growth size of total data\n"
        },
        "TotalFileCountDayGrowthRatio": {
          "Name": "totalFileCountDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of total files\n"
        },
        "LargeFileCountDayGrowthRatio": {
          "Name": "largeFileCountDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of large files\n"
        },
        "MediumFileCountDayGrowthRatio": {
          "Name": "mediumFileCountDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of medium files\n"
        },
        "SmallFileCountDayGrowthRatio": {
          "Name": "smallFileCountDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of small files\n"
        },
        "TinyFileCountDayGrowthRatio": {
          "Name": "tinyFileCountDayGrowthRatio",
          "Value": 0.04,
          "Unit": "”“\n",
          "Description": "Day growth ratio of tiny files"
        },
        "EmptyFileCountDayGrowthRatio": {
          "Name": "emptyFileCountDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of empty files\n"
        },
        "HotDataSizeDayGrowthRatio": {
          "Name": "hotDataSizeDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of hot data size\n"
        },
        "WarmDataSizeDayGrowthRatio": {
          "Name": "warmDataSizeDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of warm data size\n"
        },
        "ColdDataSizeDayGrowthRatio": {
          "Name": "coldDataSizeDayGrowthRatio",
          "Value": 0.01,
          "Unit": "\"\"",
          "Description": "Day growth ratio of cold data size\n"
        },
        "FreezeDataSizeDayGrowthRatio": {
          "Name": "freezeDataSizeDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of freeze data size\n"
        },
        "TotalDataSizeDayGrowthRatio": {
          "Name": "totalDataSizeDayGrowthRatio",
          "Value": 0.01,
          "Unit": "”“\n",
          "Description": "Day growth ratio of total data size\n"
        }
      },
      "Analysis": {
        "HiveFrequencyScore": 70,
        "HiveDistributionScore": 80,
        "HiveFormatScore": 60,
        "HiveScore": 80
      }
    }
  ],
  "RequestId": "DD6B1B2A-5837-5237-ABE4-FF0C8944****",
  "NextToken": "DD6B1B2A-5837-5237-ABE4-FF0C89568980",
  "MaxResults": 20,
  "TotalCount": 200
}

Kode kesalahan

HTTP status code	Error code	Error message
400	ConflictParameters	Parameters that must not be used together. %s
400	IncompleteSignature	The request signature is invalid.
400	InvalidAction	The action %s requested is invalid.
400	InvalidParameter	The specified parameter %s is not valid.
400	InvalidParameterValue	The input parameter %s is invalid or out of range.
400	MissingAction	The action %s requested is missing.
400	MissingParameter	The input parameter %s that is mandatory for processing this request is not supplied.
400	NotAuthorized	You do not have permission to perform this action. %s
400	ThrottlingException	The request was denied due to request throttling. %s
500	InternalError	The request processing has failed due to some unknown error, exception or failure.
404	ResourceNotFound	The resource not found by %s.
503	ServiceFailure	The request has failed due to a temporary failure of %s service.
503	ServiceUnavailable	The request has failed due to a temporary failure of the server.

Lihat Error Codes untuk daftar lengkap.

Catatan rilis

Lihat Release Notes untuk daftar lengkap.