doris export 导出的时候报错

Viewed 21

Doris 版本 doris-1.2.7-rc03-Unknown
表里面没有DATETIMEV2 类型的字段
创建表的语句

CREATE TABLE `ods_aba` (
  `report_start_date` date NOT NULL,
  `country_code` varchar(16) NOT NULL,
  `search_frequency_rank` int(11) NULL,
  `id` varchar(40) NULL,
  `account_id` int(11) NULL,
  `account` varchar(64) NULL,
  `account_station_id` int(11) NULL,
  `account_station` varchar(64) NULL,
  `timezone_by_station` varchar(50) NULL,
  `report_download_time` datetime NULL,
  `report_upload_time` datetime NULL,
  `ext_attrs` varchar(512) NULL,
  `create_time` datetime NULL,
  `update_time` datetime NULL,
  `report_id` int(11) NULL,
  `report_end_date` date NOT NULL,
  `latest_time` datetime NULL,
  `search_term` varchar(512) NULL,
  `clicked_asin_1` varchar(16) NULL,
  `product_title_1` text NULL,
  `click_share_1` decimalv3(15, 6) NULL,
  `conversion_share_1` decimalv3(15, 6) NULL,
  `clicked_asin_2` varchar(16) NULL,
  `product_title_2` text NULL,
  `click_share_2` decimalv3(15, 6) NULL,
  `conversion_share_2` decimalv3(15, 6) NULL,
  `clicked_asin_3` varchar(16) NULL,
  `product_title_3` text NULL,
  `click_share_3` decimalv3(15, 6) NULL,
  `conversion_share_3` decimalv3(15, 6) NULL,
  `top_clicked_brand_1` varchar(512) NULL,
  `top_clicked_brand_2` varchar(512) NULL,
  `top_clicked_brand_3` varchar(512) NULL,
  `top_clicked_category_1` varchar(256) NULL,
  `top_clicked_category_2` varchar(256) NULL,
  `top_clicked_category_3` varchar(256) NULL,
  `reporting_date` date NULL,
  `ldp_update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ''
) ENGINE=OLAP
UNIQUE KEY(`report_start_date`, `country_code`, `search_frequency_rank`)
PARTITION BY RANGE(`report_start_date`)
(PARTITION p202209 VALUES [('2022-09-01'), ('2022-10-01')),
......
PARTITION p202412 VALUES [('2024-12-01'), ('2025-01-01')))
DISTRIBUTED BY HASH(`search_frequency_rank`) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",

"in_memory" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false"
);

image.png

1 Answers

1.2.x 上 export还是行存的,还没支持新类型,您看看先改成 select * from table into outfile的方式可以不?

select into outfile