Extension Constraints
IoT database warehouses support only some relational syntax.
Syntax |
Supported or Not (Y/N) |
---|---|
CREATE TABLE |
Y |
CREATE TABLE LIKE |
Y |
DROP TABLE |
Y |
INSERT |
Y |
COPY |
Y |
SELECT |
Y |
TRUNCATE |
Y |
EXPLAIN |
Y |
ANALYZE |
Y |
VACUUM |
Y |
ALTER TABLE DROP PARTITION |
Y |
ALTER TABLE ADD PARTITION |
Y |
ALTER TABLE SET WITH OPTION |
Y |
ALTER TABLE DROP COLUMN |
Y |
ALTER TABLE ADD COLUMN |
Y |
ALTER TABLE ADD NODELIST |
Y |
ALTER TABLE CHANGE OWNER |
Y |
ALTER TABLE RENAME COLUMN |
Y |
ALTER TABLE TRUNCATE PARTITION |
Y |
CREATE INDEX |
Y |
DROP INDEX |
Y |
DELETE |
Y |
ALTER TABLE |
N |
ALTER INDEX |
N |
MERGE |
N |
SELECT INTO |
Y |
UPDATE |
N |
CREATE TABLE AS |
N |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot