BASE DE DADOS DE CONHECIMENTO

Error "The Google BigQuery service was unable to compile the query. Bad double value"

Publicado: 23 Feb 2022
Data da última modificação: 07 Jun 2023

Problemas

When querying a Google BigQuery data source (e.g. creating an extract, loading a visualization), the following error may occur:

Error Code: 015CFBE6
The Google BigQuery service was unable to compile the query.
Bad double value: <string value>

Ambiente

  • Tableau Desktop
  • Google BigQuery

Resolução

  1. Determine which field the string value in the error message belongs to. One way to do so is to check the Tableau Desktop logs for the query that casts a field to number type, e.g. CAST(CAST(`Overall_SaleOrder`.`order_no` AS FLOAT64) AS INT64) AS `order_no`.
  2. Change the data type for this field to String instead.

Causa

One of the fields currently configured as a number data type contains a string value.
Este artigo resolveu o problema?    
PRINT THIS PAGE
Trending Articles
Results 1-3 of 50
Anexos


Todo o suporte

SUPORTE POR PRODUTO
FERRAMENTAS E DOWNLOADS
INFORMAÇÕES
ASSISTÊNCIA