BASE DE CONNAISSANCES

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

Date de publication : 23 Feb 2022
Date de dernière modification : 07 Jun 2023

Problème

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>

Environnement

  • Tableau Desktop
  • Google BigQuery

Résolution

  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.

Cause

One of the fields currently configured as a number data type contains a string value.
Cet article vous a-t-il permis de résoudre le problème ?    
PRINT THIS PAGE
Trending Articles
Results 1-3 of 47
Pièces jointes


Toute l'assistance

ASSISTANCE PAR PRODUIT
OUTILS ET TÉLÉCHARGEMENTS
INFORMATIONS
ASSISTANCE