时间戳

首页 > 解决方案 > BigQuery 错误“查询未返回任何结果”

sql - BigQuery 错误“查询未返回任何结果”

问题描述

SELECT address, eth_balance FROM `bigquery-public-data.crypto_ethereum.balances`
    WHERE address = '0x5245A7C4Cac42f20FC352491c4b7127c5bf30A44';

或将查询更改为：

SELECT address, eth_balance FROM `bigquery-public-data.crypto_ethereum.balances`
    WHERE address LIKE '0x5245A7C4Cac42f20FC352491c4b7127c5bf30A44';

而像这样的其他地址不会拉起地址或金额：

错误信息：This query returned no results.

标签： sqlgoogle-bigquerycryptographyethereum

解决方案

只需降低它 :-) 看起来您不小心将地址更改为大写或 BQ 将其存储为小写......无论如何，如果您将地址小写，如下所示，您将开始看到余额。

#standardSQL 
SELECT address, eth_balance 
FROM bigquery-public-data.crypto_ethereum.balances 
where address = lower('0x5245A7C4Cac42f20FC352491c4b7127c5bf30A44') ;

回报：

address                                     eth_balance
0x5245a7c4cac42f20fc352491c4b7127c5bf30a44  23743356716445772

推荐阅读