我正在嘗試從表中確定一組值的平均值，但出現錯誤。
我輸入了下面的查詢以確定 2013 年至 2016 年的平均客流量，但出現此錯誤 - 運算子/引數型別沒有匹配的簽名：STRUCT<INT64, INT64>, INT64。支持的簽名：FLOAT。
SELECT
station_name,
ridership_2013,
ridership_2014,
ridership_2015,
ridership_2016,
(ridership_2013 ridership_2014 ridership_2015, ridership_2016) / 4 AS Average_ridership
FROM bigquery-public-data.new_york_subway.subway_ridership_2013_present;
uj5u.com熱心網友回復：
你只是有一個錯字！試試下面
SELECT
station_name,
ridership_2013,
ridership_2014,
ridership_2015,
ridership_2016,
(ridership_2013 ridership_2014 ridership_2015 ridership_2016) / 4 AS Average_ridership
FROM bigquery-public-data.new_york_subway.subway_ridership_2013_present;
如您所見 - 錯字是逗號而不是加號ridership_2015, ridership_2016
uj5u.com熱心網友回復：
使用 CAST 將資料型別更改為 INT64。
SELECT
station_name,
CAST (ridership_2013 AS INT64),
CAST (ridership_2014 AS INT64,
CAST (ridership_2015 AS INT64),
CAST (ridership_2016 AS INT64),
(CAST(ridership_2013 AS INT64) CAST(ridership_2014 AS INT64) CAST(ridership_2015) CAST(ridership_2016 AS INT64) / 4 AS Average_ridership
FROM bigquery-public-data.new_york_subway.subway_ridership_2013_present;
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/454993.html