Skip to content

400 Error while craeting embeddings running setup notebook #55

@Mona19

Description

@Mona19

~/Open_Data_QnA/dbconnectors/BQConnector.py:459, in BQConnector.get_column_samples(self, columns_df)
454 for index, row in columns_df.iterrows():
455 get_column_sample_sql=f'''SELECT STRING_AGG(CAST(value AS STRING)) as sample_values FROM UNNEST((SELECT APPROX_TOP_COUNT({row["column_name"]},5) as osn
456 FROM {row["project_id"]}.{row["table_schema"]}.{row["table_name"]}
...
--> 494 raise exceptions.from_http_response(response)
496 if expect_json and response.content:
497 return response.json()

BadRequest: 400 POST https://bigquery.googleapis.com/bigquery/v2/projects/nyct-predictive-maintenance/queries?prettyPrint=false: No matching signature for operator - for argument types: STRING, STRING. Supported signatures: INT64 - INT64; NUMERIC - NUMERIC; BIGNUMERIC - BIGNUMERIC; FLOAT64 - FLOAT64; DATE - INT64; DATE - DATE; TIMESTAMP - TIMESTAMP; DATETIME - DATETIME; TIME - TIME; TIMESTAMP - INTERVAL; DATE - INTERVAL; DATETIME - INTERVAL; INTERVAL - INTERVAL at [1:96]
Output is truncated. View as a scrollable element or open in a text editor. Adjust cell output settings...

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions