Gramática SQL de Tabla

Los objetos de tabla soportan la gramática SQL mostrada para las cargas de trabajo DDL.

Oracle AI Data Platform Workbench soporta todos los tipos de dato SQL de Spark estándar. Para obtener más información, consulte Documentación de Apache Spark - Tipos de dato soportados.

Operación	Gramática
Crear Tabla	CREATE [EXTERNAL] TABLE [IF NOT EXISTS] <catalog_name>.<schema-name>.<table-name> [ ( <column1-name><column1-type> [comment <column1-comment>], ... ) ] USING [HIVE|DELTA, CSV, TXT, ORC, JDBC, PARQUET, etc.] [ options ( <key1>=<val1>[, ...]) ] [ PARTITIONED BY (<par-column-name>[, ...]) ] [ CLUSTERED BY ( <clus-column-name>[, ...]) [ SORTED BY ( <sort-column-name> [ asc | desc ][, ...]) ] INTO <num_buckets> buckets] [ LOCATION '<path>'] [TBLPROPERTIES ( DESCRIPTION = 'some-description', '<property-name>'='<property-value>'[, ...]) ] Respuesta: <<SQL Command>> was successfully executed Error: Error: <<SQL Command>> failed due to <<reason>>
Crear tabla gestionada	Crear tabla gestionada CREATE TABLE <catalog>.<schema>.<table-name> [ ( <column1-name><column1-type> [comment <column1-comment>], ... ) ] USING <format>; Respuesta: <<SQL Command>> was successfully executed Error: Error: <<SQL Command>> failed due to <<reason>>
Crear tabla gestionada con datos	create datatable <<catalog_name>>.<<schema_name>>.<<table_name>> [ ( <column1-name><column1-type> [comment <column1-comment>], ... ) ] tblproperties ('lakehouse_storage_format'='PARQUET') using parquet with select ( <column1-name>], ... ) from parquet.'oci://bucket@namespace/folder/' Respuesta: <<SQL Command>> was successfully executed Error: Error: <<SQL Command>> failed due to <<reason>>
Crear Tabla con Soporte Uniforme	CREATE [EXTERNAL] TABLE [IF NOT EXISTS] <catalog_name>.<schema-name>.<table-name> [ ( <column1-name> <column1-type> [comment <column1-comment>], ... ) ] [TBLPROPERTIES ('delta.universalFormat.enabledFormats' = 'iceberg') ]
Modificar tabla	ALTER TABLE table_old_name RENAME TO table_new_name ALTER TABLE table_name ADD COLUMNS ( col_spec [ , ... ]) ALTER TABLE table_name DROP { COLUMN | COLUMNS } [ ( ] col_name [ , ... ] [ ) ] ALTER TABLE table_name RENAME COLUMN col_name TO col_name ALTER TABLE table_name ADD [IF NOT EXISTS] ( partition_spec [partition_spec ... ] ) ALTER TABLE table_name DROP [ IF EXISTS ] partition_spec [PURGE] ALTER TABLE table_name set tblproperties (description ='some-description')
Borrar Tabla	DROP TABLE [ IF EXISTS ] table_name [ PURGE ] Respuesta: <<SQL Command>> was successfully executed Error: Error: <<SQL Command>> failed due to <<reason>>
Mostrar tablas en un esquema	SHOW TABLES in catalog_name.schema_name [ LIKE <regex_pattern> ] regex_pattern: patrón de expresión regular que se utiliza para filtrar los resultados de la sentencia. Respuesta: <<namesake>>,tableName,isTemporary Error: <<SQL Command>> failed due to <<reason>>
Describir Tabla	DESCRIBE TABLE [ FORMAT ] catalog_name.schema_name.table_name [ PARTITION (<partition_col_name> = <partition_col_val>, ...) ] [ catalog_name.schema_name.table_name.column_name ] Formato: si se especifica EXTENDED como formato, se devuelve información de metadatos adicional (como la base de datos principal, el propietario y la hora de acceso). DESCRIBE TABLE catalog.schema.table Respuesta: col_name,data_type,comment DESCRIBE TABLE catalog.schema.table column Respuesta: info_name,info_value