Different Database Options
| Commands | Purpose |
|---|---|
PRAGMA table_info(<table_name>) | |
sql<br>SELECT ... <br>FROM ...<br>EXCEPT<br> ...<br> |
| Commands (for Hive) | Purpose |
|---|---|
CREATE TABLE ... | |
CREATE TABLE IF NOT EXISTS ... | |
DROP TABLE ... | |
CREATE OR REPLACE TABLE ... | |
ALTER TABLE ... RENAME TO ... | |
ALTER TABLE ... SET LOCATION | |
DESCRIBE | |
DESCRIBE FORMATTED | |
ALTER TABLE ... DROP PARITION ... | |
ALTER TABLE ... ADD PARTITION ... | |
SHOW PARTITIONS | |