tBigQueryInput getting StringIndexOutOfBoundsException in release 7.2.1

[Anonymous]

Using release 7.2.1 ... using tBigQueryInput and tLogRow like the example in the document ... https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/vwx5WuXNi7g0W_rK1Pi1AQ

project_id is someProject

dataset id is demos

schema for table some_user_native and project 

first_name String

customerid String

email String

query is

"select first_name, customerid, email from demos.some_user_native"

tBigQueryInput linked to tLogRow

Running the job resulted in 

Exception in component tBigQueryInput_4
java.lang.StringIndexOutOfBoundsException: String index out of range: -14
at java.lang.String.substring(Unknown Source)

I tried to run insert and update statements and getting the same error.

Does anyone encounter similar issues?

[Anonymous]

Hi,

    Could you please try it once again by giving the Length parameter details in the schema for each column? If the error persists, could you please create a jira ticket for the same?

https://jira.talendforge.org/secure/Dashboard.jspa

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Hi Nikhil,

It seems to be working now ... but ...

Here is a few things I noticed ...

1. In the previous release, I don't need to save the change before running.  I think NOW I need to save after the change in order to run with the change.

2. When I use an alias for the table, it gives me the StringIndexOutOfBountsException.  I tried to do this in the select, update, insert and getting the StringIndexOutOfBountsException.

For example ... I got this select query statement working in Talend ... 

select first_name, customerid, email from demos.some_user_native 

but not this ...

select su.first_name, su.customerid, su.email from demos.some_user_native su

Both of these statements worked in GCP BigQuery Query editor.