You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello Team,
I have done a presto set-up with BigQuery integration. but now I am not able to view my materialized view table in the presto. Also, some view tables are shown in the presto, but when I run the select query (select * from bigquery.adgebraco.conversion_view limit 10; )I will get the below error for only view tables.
This is for view table
select * from bigquery.adgebraco.conversion_view limit 10;
Query 20250206_070129_00004_7asuc failed: com.google.cloud.bigquery.BigQueryException: Provided Schema does not match Table adgebra-qa:adgebraco._pbc_1be598d08bef482bb46978f25f44ee63. Invalid schema update. Updating field collation is not supported. Field productids has changed collation from "und:ci" to ""
And below error for materialized view, which is not in the presto
presto> select * from bigquery.adgebraco.detailed_analysis_view limit 10;
Query 20250206_070054_00003_7asuc failed: Table type 'MATERIALIZED_VIEW' of table 'adgebraco.detailed_analysis_view' is not supported
I am using Presto CLI 0.290-6a04267 version. Below is my bigquery. properties file
connector.name=bigquery
bigquery.project-id=adgebra-qa
bigquery.credentials-file=/etc/presto/credentials/credentials.json
bigquery.default-dataset=adgebraco
bigquery.views-enabled=true
bigquery.force-standard-sql=true
bigquery.view-materialization-project=adgebra-qa
bigquery.view-materialization-dataset=adgebraco
bigquery.location=asia-south1
Let me know if you need further information from my end.
Thank yoy
The text was updated successfully, but these errors were encountered:
Hello Team,
I have done a presto set-up with BigQuery integration. but now I am not able to view my materialized view table in the presto. Also, some view tables are shown in the presto, but when I run the select query (select * from bigquery.adgebraco.conversion_view limit 10; )I will get the below error for only view tables.
This is for view table
select * from bigquery.adgebraco.conversion_view limit 10;
Query 20250206_070129_00004_7asuc failed: com.google.cloud.bigquery.BigQueryException: Provided Schema does not match Table adgebra-qa:adgebraco._pbc_1be598d08bef482bb46978f25f44ee63. Invalid schema update. Updating field collation is not supported. Field productids has changed collation from "und:ci" to ""
And below error for materialized view, which is not in the presto
presto> select * from bigquery.adgebraco.detailed_analysis_view limit 10;
Query 20250206_070054_00003_7asuc failed: Table type 'MATERIALIZED_VIEW' of table 'adgebraco.detailed_analysis_view' is not supported
I am using Presto CLI 0.290-6a04267 version. Below is my bigquery. properties file
connector.name=bigquery
bigquery.project-id=adgebra-qa
bigquery.credentials-file=/etc/presto/credentials/credentials.json
bigquery.default-dataset=adgebraco
bigquery.views-enabled=true
bigquery.force-standard-sql=true
bigquery.view-materialization-project=adgebra-qa
bigquery.view-materialization-dataset=adgebraco
bigquery.location=asia-south1
Let me know if you need further information from my end.
Thank yoy
The text was updated successfully, but these errors were encountered: