Removing specific INT64 id's from column BigQuery

Viewed 18

I'm having an issue removing specific INT64 id's from consideration while running a p-value script via Spyder while using BigQuery commands.

So when apply the script in this format with the specific advertising_ids removed in this syntax: advertising_id, AND advertising_id NOT in (1163160702660369000, -1925315655674023700) there is no difference in p-value vs when these id's are not removed so there is some issue

When I use AND advertising_id NOT in ('1163160702660369000', '-1925315655674023700') when advertising_id syntax is in 'advertising_id' form, I get the error:

400 Query error: No matching signature for operator IN for argument types INT64 and {STRING} at [24:26]
WITH
  prep AS (
  SELECT
    DISTINCT advertising_id,
    group_assignment
  FROM
    `omitted_for_privacy`
  WHERE
    day BETWEEN date_audience_start
    AND date_audience_end
  AND influence is null
  AND advertising_id NOT in ('1163160702660369000',
'-1925315655674023700',
'7046321939169906000')
  --and sum_cv<=4082.26 and sum_cv>0
  -- AND user_subcampaign IS NOT NULL
AND user_subcampaign=subcampaign_name
)

Please help, I can't seem to remove these advertising_id values in the script when considering the calculation of the p-values of the entire dataset.

0 Answers
Related