use the standard SQL table format in the example query

GoogleCloudPlatform / pontem

Open source tools for Google Cloud Storage and Databases.

Apache License 2.0

64 stars 15 forks source link

use the standard SQL table format in the example query #240

Open ttozser opened 5 years ago

ttozser commented 5 years ago

If you mix the legacy and standard SQL syntax you get an error like this: Project name needs to be separated by dot from dataset name, not by colon in table name bigquery-public-data:human_genome_variants.simons_genome_diversity_project_sample_metadata

ldanielmadariaga commented 4 years ago

Legacy SQL is disabled for BigQuery hence it should not be used in the queries see: https://github.com/GoogleCloudPlatform/pontem/blob/015426e1ff5173843b4cf33237dc810b15956152/BigQueryWorkloadTester/src/main/java/com/google/cloud/pontem/benchmark/backends/BigQueryBackend.java#L96