DESCRIBE DATABASE shows the name of the database, its comment (if one has been set), and its root location on the filesystem. The uses of SCHEMA and DATABASE are interchangeable – they mean the same thing. DESCRIBE SCHEMA is added in Hive 0.15 (HIVE-8803). EXTENDED also shows thedata...
{DESC|DESCRIBE}[TABLE][EXTENDED]table_name{[PARTITIONclause]|[column_name]}[ASJSON] For compatibilityFORMATTEDcan be specified as a synonym forEXTENDED. Parameters EXTENDED If specified display detailed information about the specified columns, including the column statistics collected by the command, an...
{"deliveries": [{"arn": "string", "deliveryDestinationArn": "string", "deliveryDestinationType": "string", "deliverySourceName": "string", "fieldDelimiter": "string", "id": "string", "recordFields": [ "string" ], "s3DeliveryConfiguration":{"enableHiveCompatiblePath":boolean, "suffixPath...
The formatting style for command output. json text table --query (string) A JMESPath query to use in filtering the response data. --profile (string) Use a specific profile from your credential file. --region (string) The region to use. Overrides config/env settings. --version (string) Di...
hive.ql.i... OutputFormat org.apache.hadoop.hive.ql.i... Partition Provider Catalog -- Returns partition metadata such as partitioning column name, column type and comment. > DESCRIBE TABLE EXTENDED customer PARTITION (state = 'AR'); col_name data_type comment --- --- --- cust_id int...
Consultez aussi SHOW COLUMNS, SHOW CREATE VIEW, SHOW VIEWS et DROP VIEW. Sur cette page Résumé Exemple Cette page vous a-t-elle été utile ? Oui Non Faire un commentaire Rubrique suivante :DROP DATABASE Rubrique précédente :DESCRIBE Avez-vous besoin d’aide ? Essayez AWS re:Post Contact...
{ "Enabled": boolean, "LogGroupName": "string", "LogStreamName": "string" }, "ClusterJDBCURL": "string", "CopyCommand": { "CopyOptions": "string", "DataTableColumns": "string", "DataTableName": "string" }, "ProcessingConfiguration": { "Enabled": boolean, "Processors": [ { "...
This command is useful for examining the attributes of complex columns. Synopsis DESCRIBE [EXTENDED | FORMATTED] [db_name.]table_name [PARTITION partition_spec] [col_name ( [.field_name] | [.'$elem$'] | [.'$key$'] | [.'$value$'] )] Important The syntax for this statement is ...
{ "deliveries": [ { "arn": "string", "deliveryDestinationArn": "string", "deliveryDestinationType": "string", "deliverySourceName": "string", "fieldDelimiter": "string", "id": "string", "recordFields": [ "string" ], "s3DeliveryConfiguration": { "enableHiveCompatiblePath": boolean, "...
{ "deliveries": [ { "arn": "string", "deliveryDestinationArn": "string", "deliveryDestinationType": "string", "deliverySourceName": "string", "fieldDelimiter": "string", "id": "string", "recordFields": [ "string" ], "s3DeliveryConfiguration": { "enableHiveCompatiblePath": boolean, "...