Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to query episodes view based on tags or tags id #936

Open
mulundapm opened this issue May 13, 2024 · 0 comments
Open

Unable to query episodes view based on tags or tags id #936

mulundapm opened this issue May 13, 2024 · 0 comments

Comments

@mulundapm
Copy link
Contributor

mulundapm commented May 13, 2024

Cant do query on episodes view table on metabase based on tagID. Trying to create a new column/ apply a filter based on tag id

contains([TagIDs] , "1175")

and got this error

400 Bad Request POST https://www.googleapis.com/bigquery/v2/projects/bccm-k8s-main/queries { "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "No matching signature for operator LIKE for argument types: JSON, STRING. Supported signatures: STRING LIKE STRING; BYTES LIKE BYTES at [2:1877]", "reason": "invalidQuery" } ], "message": "No matching signature for operator LIKE for argument types: JSON, STRING. Supported signatures: STRING LIKE STRING; BYTES LIKE BYTES at [2:1877]", "status": "INVALID_ARGUMENT" }

given that there is an episode with the following tag id

rudderstack_prod.episodes_view.TagIDs = '[294,297,157,316]'

Would still get

400 Bad Request POST https://www.googleapis.com/bigquery/v2/projects/bccm-k8s-main/queries { "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "No matching signature for operator = for argument types: JSON, STRING. Supported signature: ANY = ANY at [2:1876]", "reason": "invalidQuery" } ], "message": "No matching signature for operator = for argument types: JSON, STRING. Supported signature: ANY = ANY at [2:1876]", "status": "INVALID_ARGUMENT" }

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant