Topic 2 Question 8
Which of the following statements about Legacy SQL and Standard SQL is not true?
Standard SQL is the preferred query language for BigQuery.
If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.
One difference between the two query languages is how you specify fully-qualified table names (i.e. table names that include their associated project name).
You need to set a query language for each dataset and the default is Standard SQL.
解説
You do not set a query language for each dataset. It is set each time you run a query and the default query language is Legacy SQL. Standard SQL has been the preferred query language since BigQuery 2.0 was released. In legacy SQL, to query a table with a project-qualified name, you use a colon, :, as a separator. In standard SQL, you use a period, ., instead. Due to the differences in syntax between the two query languages (such as with project-qualified table names), if you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL. Reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql
コメント(4)
Answer: D Description: Query language is not set at dataset level. It depends on from where we are trying to access Bigquery tables. Webs default is leagacy whereas Cloud console is Standard.
👍 10[Removed]2020/03/28Answer : D
👍 5[Removed]2020/03/21Answer: D https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql#changing_from_the_default_dialect The interface you use to query your data determines which query dialect is the default: In the Cloud Console and the client libraries, standard SQL is the default. In the bq command-line tool and the REST API, legacy SQL is the default.
👍 3groovygorilla2021/07/10
シャッフルモード