使用1个月分区更新表格，并使用另一个表信息-Teradata

发布于 2025-01-31 08:38:55 字数 503 浏览 2 评论 0原文

我有一个桌子A（没有分区），每月都会被覆盖。我想使用分区保存此数据。实现这一目标的最佳方法是什么？

我当前的步骤：每月创建一个带有分区的新表B，使用表A信息更新表B。

如果我的步骤正确，请帮助编写相同的优化查询。我的代码在下面给出

    CREATE TABLE `A`
    AS
   select
   Col1,
   col2



   create table 'B'
   as
   SELECT
   dt DATE FORMAT 'yyyy-mm-dd',
   Col1 string
   Col2 string
   PARTITION BY RANGE_N(dt BETWEEN DATE '2022-05-23' AND DATE '2028-12-31' EACH INTERVAL '1' MONTH);



  insert into table 'B'
  select
  current_date as dt,
  a.*
  from table A a;

原文

I am having a table A (without partition) which gets overwritten every month. I want to use partition to save this data. What is the best way to achieve this?

My current steps:
Create a new table B with partition every month,
Update table B with table A information.

If my steps are correct, please help to write an optimised query for the same.
My code is given below

    CREATE TABLE `A`
    AS
   select
   Col1,
   col2



   create table 'B'
   as
   SELECT
   dt DATE FORMAT 'yyyy-mm-dd',
   Col1 string
   Col2 string
   PARTITION BY RANGE_N(dt BETWEEN DATE '2022-05-23' AND DATE '2028-12-31' EACH INTERVAL '1' MONTH);



  insert into table 'B'
  select
  current_date as dt,
  a.*
  from table A a;

分享到QQ

分享到微博