doris icon indicating copy to clipboard operation
doris copied to clipboard

[fix](dbt-doris) avoid the restriction of having to add label_id when…

Open catpineapple opened this issue 3 years ago • 0 comments

Avoid the restriction of having to add label_id when sql is insert into + CTE

When building a dbt project, the "with ... as(select)" sql expression model is often used. However, due to the syntax limitation of Doris here, label_id or column_list must be given. The original dbt-doris code is not very compatible with this. Special SQL. Therefore, I added the "label_id" macro function to the config. When the user gives his own label_id, the user's own "label_id" is used. If not given, a time-related "label_id" is automatically generated, prefixed with: "dbt_doris_label_".

Checklist(Required)

  1. Does it affect the original behavior:
    • [✔️] Yes
    • [ ] No
    • [ ] I don't know
  2. Has unit tests been added:
    • [ ] Yes
    • [✔️] No
    • [ ] No Need
  3. Has document been added or modified:
    • [ ] Yes
    • [ ] No
    • [✔️] No Need
  4. Does it need to update dependencies:
    • [ ] Yes
    • [✔️] No
  5. Are there any changes that cannot be rolled back:
    • [ ] Yes (If Yes, please explain WHY)
    • [✔️] No

catpineapple avatar Aug 09 '22 11:08 catpineapple