BigQueryArgument Setter: Argument set conditions is setting "AND" in query request raw logs
Description
Release Notes
None
Attachments
6
Activity
Show:
Pinned fields
Click on the next to a field label to start pinning.
Details
Details
Created July 20, 2022 at 10:44 AM
Updated July 20, 2022 at 10:55 AM
After providing the Argument selection conditions and Argument columns of an existing bigquery table the pipeline fails.
Steps to reproduce:
Launch the latest CDAP (6.8.0)
Open BigQuery Argument Setter plugin from conditions and actions.
Fill the properties and click on validate, no errors are to be displayed.
Now deploy the pipeline. The pipeline gets failed.
In “View Raw Logs” query request is shown related to argument set conditions with AND condition.
And same query executed in BQ fetches more than 1 record as per the condition provided.
Whether it is AND or OR the query arguments should be fetched if records are matched as per set.
Query request Records always fails if more records are resulted.
The query result total rows should be "1" but is "5"
is shown in log.Expected: Pipeline should be successful with details provided in properties of an existing BigQuery table and should able to fetch the BiqQuery Query request to fetch arguments to set the pipeline with AND or OR in logs.
Actual: Pipeline gets failed and unable to fetch the BiqQuery Query request to fetch arguments to set the pipeline with only AND in logs.