| -- |
| -- Tajo database dump |
| -- |
| |
| |
| -- |
| -- Database name: "TestTajoDump" |
| -- |
| |
| CREATE DATABASE IF NOT EXISTS "TestTajoDump"; |
| |
| -- |
| -- Name: "TestTajoDump"."TableName3"; Type: TABLE; Storage: TEXT |
| -- |
| CREATE TABLE "TestTajoDump"."TableName3" (col1 INT4, col2 INT4) USING TEXT WITH ('text.delimiter'='|', 'text.null'='\\N', 'timezone'='${table.timezone}') PARTITION BY COLUMN(col3 INT4, col4 INT4); |
| |
| -- |
| -- Table Partitions: TableName3 |
| -- |
| ALTER TABLE "TestTajoDump"."TableName3" REPAIR PARTITION; |
| |
| |
| |
| -- |
| -- Name: "TestTajoDump"."TableName4"; Type: TABLE; Storage: TEXT |
| -- |
| CREATE TABLE "TestTajoDump"."TableName4" (col1 INT4, col2 INT4) USING TEXT WITH ('text.delimiter'='|', 'text.null'='\\N', 'timezone'='${table.timezone}') PARTITION BY COLUMN(col3 TEXT, col4 DATE); |
| |
| -- |
| -- Table Partitions: TableName4 |
| -- |
| ALTER TABLE "TestTajoDump"."TableName4" REPAIR PARTITION; |