我正在尝试在Google BigQuery中将数据集中的两个表进行联合
使用以下代码:
def mergeTables(workingTable, table, DATASET_ID):
query ="""
SELECT
full_name,
age
FROM {DATASET_ID}.{workingTable}
UNION DISTINCT
SELECT
full_name,
age
FROM {DATASET_ID}.{table}
LIMIT 100;
"""
df = pd.read_gbq(query, "joe-python-analytics", 'standard')
print(df)
我想用联合运算符合并工作表和表格这两个表格。但是当我运行该方法时,出现了以下错误:
googleapiclient.errors.HttpError: <HttpError 400 when requesting https://www.googleapis.com/bigquery/v2/projects/j/queries/job_aalt=json returned "Encountered "" at line 6, column 15.
[Try using standard SQL (https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql)]">
我已经启用了标准SQL,但这似乎没有帮助?