'Getting streaming buffer error, but I don't using streaming for my usecase
Getting error running this query:
MERGE <base_table> t1
USING (
SELECT *
FROM (
SELECT distinct *
FROM <table_changes>
WHERE timemodified = (
SELECT MAX(timemodified)
FROM <table_changes> t4 WHERE t3.company = t4.company)
) t3
ON t1.company = t2.company
WHEN MATCHED THEN
UPDATE SET <assign values>
WHEN NOT MATCHED THEN
INSERT (<columns>) VALUES(<columns>)
Error:
UPDATE or DELETE statement over table connecteam-data-prod-v1.ct_internal_state_based_data.company_profile_meta_data_t would affect rows in the streaming buffer, which is not supported
But I don't use any streaming for this table. How can I resolve it?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
