Search
 
SCRIPT & CODE EXAMPLE
 

SQL

athena drop partition

ALTER TABLE orders 
DROP PARTITION (dt = '2014-05-14', country = 'IN');
Comment

athena drop partition

ALTER TABLE table_name DROP [IF EXISTS] PARTITION (partition_spec) [, PARTITION (partition_spec)]
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql text type max length 
Sql :: how to add a index to live table sql 
Sql :: mysql increment value by 1 in update 
Sql :: tsql create unique index composite 
Sql :: how to get all table names in sql query 
Sql :: psql list rules 
Sql :: oracle wait 
Sql :: how to backup mysql database linux 
Sql :: show all tables in oracle 
Sql :: create table if not exists sql 
Sql :: concat first name and last name in mysql 
Sql :: How to fetch data in between startfromdate to starenddate in sql 
Sql :: upload database mysql command line 
Sql :: Erreur SQL sur la requête Index column size too large. The maximum column size is 767 bytes. 
Sql :: mysql delete binlog 
Sql :: import local sql into remote mysql 
Sql :: starting mysql service from mac 
Sql :: sql current timestamp 
Sql :: oracle kill session by sql_id 
Sql :: copy sql table 
Sql :: DUPLICATE column values 
Sql :: sql server pagination 
Sql :: reutrn string after character sql 
Sql :: install mysql 8 ubuntu 18.04 
Sql :: ALL_TAB_PARTITIONS 
Sql :: how to get weekday from old date in sql 
Sql :: how to delete table sqlite 
Sql :: How to View column names of a table in SQL 
Sql :: add timestamp column to existing table t-sql 
Sql :: mysql round 
ADD CONTENT
Topic
Content
Source link
Name
8+9 =