Sql

Search

athena create table

CREATE EXTERNAL TABLE [IF NOT EXISTS]
 [db_name.]table_name [(col_name data_type [COMMENT col_comment] [, ...] )]
 [COMMENT table_comment]
 [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
 [CLUSTERED BY (col_name, col_name, ...) INTO num_buckets BUCKETS]
 [ROW FORMAT row_format]
 [STORED AS file_format] 
 [WITH SERDEPROPERTIES (...)]
 [LOCATION 's3://bucket_name/[folder]/']
 [TBLPROPERTIES ( ['has_encrypted_data'='true | false',] ['classification'='aws_glue_classification',] property_name=property_value [, ...] ) ]

Comment

PREVIOUS	NEXT

Code Example
Sql :: limit offset sql server
Sql :: is sql fast
Sql :: encrypt and decrypt in sql server
Sql :: snowflake select from stage
Sql :: PL SQL VARRAY of records
Sql :: lower case in sql
Sql :: how to find unique element in sql
Sql :: mysql count rows returned
Sql :: function in postgresql
Sql :: sqlite show table structure
Sql :: sql column to row
Sql :: mysql case when in select
Sql :: exec procedure pl sql
Sql :: Using GROUP BY in MySQL Join Table
Sql :: sql primary key syntax
Sql :: postgresql change user role grant
Sql :: sql String comparisons case sensitive
Sql :: pl sql search in all packages
Sql :: truncate table in sql
Sql :: oracle list days between two dates
Sql :: ms sql print more than 1 variable
Sql :: nth highest salary in sql
Sql :: postgresql could not start server mac
Sql :: creating a view in sql
Sql :: sql view index
Sql :: json not contains mysql
Sql :: how to get max salary in each department in sql
Sql :: mysql switch case
Sql :: get stored procedure text sql server
Sql :: what is cursor in sql server with example

Search

SQL

athena create table

ADD CONTENT