Modifies a foreign table.
None
1 2 | ALTER FOREIGN TABLE [ IF EXISTS ] table_name OPTIONS ( {[ ADD | SET | DROP ] option ['value']}[, ... ]); |
1 2 | ALTER FOREIGN TABLE [ IF EXISTS ] tablename OWNER TO new_owner; |
Specifies the name of an existing foreign table to be modified.
Value range: an existing foreign table name.
Name of the option to be modified.
Value range: See Parameter Description in CREATE FOREIGN TABLE.
Specifies the new value of option.
Create a foreign tablecustomer_ft to import data from GDS server 10.10.123.234 in TEXT format:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | DROP FOREIGN TABLE IF EXISTS customer_ft; CREATE FOREIGN TABLE customer_ft ( c_customer_sk integer , c_customer_id char(16) , c_current_cdemo_sk integer , c_current_hdemo_sk integer , c_current_addr_sk integer , c_first_shipto_date_sk integer , c_first_sales_date_sk integer , c_salutation char(10) , c_first_name char(20) , c_last_name char(30) , c_preferred_cust_flag char(1) , c_birth_day integer , c_birth_month integer , c_birth_year integer , c_birth_country varchar(20) , c_login char(13) , c_email_address char(50) , c_last_review_date char(10) ) SERVER gsmpp_server OPTIONS ( location 'gsfs://10.10.123.234:5000/customer1*.dat', FORMAT 'TEXT' , DELIMITER '|', encoding 'utf8', mode 'Normal')READ ONLY; |
Modify the customer_ft attribute of the foreign table. Delete the mode option.
1 | ALTER FOREIGN TABLE customer_ft options(drop mode); |