Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I encountered an error while using tBigQueryInput component to extract data
Simple flow as below but run with ERROR
Hit the ERROR below
Double checked and confirmed the authentication is all good. Query is able to run in Google BigQuery.
The table is actually raw data from google analytics
I also try to setup a free Trial Google BigQuery, import some simple data set. Setup bigquery connection using the same method and was able to extract data, this is to confirm that my connection setup method is correct.
Any idea what could possibly caused the ERROR above? Tried to google but still couldn't find the resolution.
Regards,
MC Lee
try to run the query without square brackets or in tBigQueryInput defined schema, tick visitorID nullable.
make changes in defined schema accept null value,
Also make changes in your query as below:
"SELECT visitorID,visitorNumber,visitID from 445885.ga_sessions_2018067 LIMIT 100"
I have removed colon from the respective query
Yes, exactly the same configuration and query yet still throw the same error
okay, i saw a slash in your code tab. I believe you need to handle that.
Hi Guys
I am getting a similar error. I have entered the correct client Id and secret and as per the documentation when I execute the job I should be given a URL to get the authorization code. Instead I get the following exception
Exception in component tBigQueryInput_1
java.lang.NullPointerException
at com.google.api.client.repackaged.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:191)
at com.google.api.client.util.Preconditions.checkNotNull(Preconditions.java:127)
at com.google.api.client.json.jackson2.JacksonFactory.createJsonParser(JacksonFactory.java:92)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:85)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:81)
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:88)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:362)
[statistics] disconnected
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at
Any clues what could be wrong. The job is simple BigqueryInput to tLogRow.
Thank You
Sid
Hello,
Are you running a query with tBigQueryInput, that results with zero rows?
Here exists a jira issue:https://jira.talendforge.org/browse/TBD-1593.
This issue has been fixed on 5.5.3, 5.6.2, 6.0.0M5.
Best regards
Sabrina
I habe the same problem! I have entered the correct client Id and secret. when I execute the job I should be given a URL to get the authorization code. Instead I get the following exception
Exception in component tBigQueryInput_1
java.lang.NullPointerException
at com.google.api.client.repackaged.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:191)
at com.google.api.client.util.Preconditions.checkNotNull(Preconditions.java:127)
at com.google.api.client.json.jackson2.JacksonFactory.createJsonParser(JacksonFactory.java:92)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:85)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:81)
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:88)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:362)
[statistics] disconnected
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at
Can someone help?