Error running a query on BigQuery

[Shachar Grembek]

Hi,

I am using App Engine Standard with Java 8 (1.9.54). In one of my cron tasks I am making a query to BigQuery : 

QueryJobConfiguration queryConfig =

        QueryJobConfiguration.newBuilder(
                "SELECT " + "timestamp" +
                        "      FROM [XXX]" +
                        "      WHERE typing_time>3 AND time_to_respond>6 " +
                        "      ORDER BY timestamp DESC " +
                        "      LIMIT 1 " +
                        ";"
        )
                .setUseLegacySql(true)
                .build();

QueryResponse queryResponse = runQuery(queryConfig);

I get the following exception:

java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V at com.google.cloud.bigquery.BigQueryImpl.optionMap(BigQueryImpl.java:666) at com.google.cloud.bigquery.BigQueryImpl.getJob(BigQueryImpl.java:497) at com.google.cloud.bigquery.Job.isDone(Job.java:162) at com.google.cloud.bigquery.Job.waitFor(Job.java:214)

at com.myCode.runQuery

The thing is that it worked for a few weeks and it suddenly stopped working. Does anyone know what can be the reason?

Thanks

[Kenworth (Google Cloud Platform)]

Are you by any chance, running Firebase on Android? The error you posted is a known issue and a possible workaround is discussed on this Public Issue Tracker and StackOverflow thread. The problem had to do with the buildscript dependencies. If not, I highly encourage you to submit a defect report as described in this article so that proper attention will be given to it.

[Shachar Grembek]

I am not using Firebase on Android, is the workaround relevant also for other cases?

[Kenworth (Google Cloud Platform)]

Unfortunately, the workaround is confined to the buildscript related to Firebase.