Question

Big Query Error Message

  • 5 May 2021
  • 1 reply
  • 24 views

Hello! I’m trying to submit the query below in BigQuery

 

SELECT
user_id,
advertiser_id,
lineitem_id,
creative_id,
country_iso_code
FROM `insights.impressions_base_2020*`
Where advertiser_id = 6812212
  AND  _TABLE_SUFFIX BETWEEN '0101' AND '0331'
  AND lineitem_id NOT IN ( '5602769671', '5580417306', '5581512841', '5581512886', '5581512871', '5571436761', '5571436743', '5572721429', '5581578220', '5581804250', '5581803806', '5581578193', '5600524932', '5601820042', '5602048460', '5619485410', '5619471991', '5576901524', '5576901506', '5576704690', '5576901530', '5581751483', '5576789161', '5576787793', '5575665759', '5577634784', '5577634796', '5577634937', '5577436762', '5571658214', '5571540670', '5571540661', '5571540643', '5571743231', '5571743270', '5571743255', '5571743213', '5576884225', '5576884246', '5576884234', '5577085868', '5574799170', '5575617522', '5581785830', '5587322866', '5587322851', '5587323007', '5587335040', '5587335013', '5587335025', '5575597089', '5576923199', '5576923178', '5575597095', '5575596948', '5576923655', '5576923628', '5580714894', '5581843393', '5581843438', '5581843417', '5581843411', '5576247537', '5576247525', '5576247522', '5577603338', '5577603347', '5576292123', '5572779542', '5572623580', '5572779971', '5572580584', '5571453525', '5572580596', '5576209422', '5576209584', '5576209401', '5571491484', '5571491478', '5572769711', '5572632616', '5571514251', '5571514443', '5587430050', '5602081829', '5601865669', '5602081817', '5602081802', '5571421887', '5572712591', '5571421911', '5572712597', '5618017181', '5618023166', '5616395277', '5617540927', '5618088686', '5618096096', '5618781727', '5617595713', '5617712584', '5616532053', '5617723621', '5616543315', '5617709221', '5616574050', '5554907417', '5628156135', '5628156222', '5628156213', '5602514155', '5617632388', '5601197652', '5575541259', '5575541244', '5576856695', '5596629083', '5596629095', '5595238497', '5594535778', '5594535769', '5593414239', '5627341402', '5602982840', '5602984061', '5598374535', '5599652536', '5575656231', '5575656363', '5575656219', '5577748475', '5584258042', '5576468589', '5587276681', '5587276549', '5587299010', '5576020973', '5575833112', '5576098955', '5576098934', '5616640540', '5617079210', '5617079192' )
GROUP BY user_id, advertiser_id, lineitem_id, creative_id, country_iso_code

 

And receiving the error message as follows;

No matching signature for operator IN for argument types INT64 and {STRING} at [10:23]

 

Can someone help me figure out where I’m going wrong?


This topic has been closed for comments

1 reply

Userlevel 6
Badge

Looks to me like lineitem_id is an integer and you are comparing against strings in the NOT IN.