topic Error in tSnowFlakeInput in Talend Studio

Error in tSnowFlakeInput

Prakhar1 — Thu, 07 May 2020 01:40:49 GMT

Hi,

I am trying to connect to Snowflake and want to get the count of rows from the table, bu I am facing the below error :

Exception in component tSnowflakeInput_1 (jb_SnowFlake_Connectivity_Check)
java.lang.ArrayIndexOutOfBoundsException: 1
at org.talend.components.common.avro.JDBCResultSetIndexedRecordConverter$ResultSetIndexedRecord.get(JDBCResultSetIndexedRecordConverter.java:111)
at org.talend.daikon.di.DiOutgoingDynamicSchemaEnforcer.getDynamicValues(DiOutgoingDynamicSchemaEnforcer.java:146)

My query is :

"Select count(*) from table_name"

Can anybody help me that how to solve this error?

Re: Error in tSnowFlakeInput

manodwhb — Thu, 07 May 2020 04:40:30 GMT

@Prakhar, can you try to run that query from the metadata connection from the Talend repository? and see are you able to get this error?

Re: Error in tSnowFlakeInput

manodwhb — Thu, 07 May 2020 05:04:35 GMT

@Prakhar , are using dynamic schema in tSnowflakeInput?

Re: Error in tSnowFlakeInput

Prakhar1 — Thu, 07 May 2020 10:32:41 GMT

@manodwhb Hi ,

yes you are right i am using dynamic, is this a problem in snowflakeinput?

Re: Error in tSnowFlakeInput

manodwhb — Thu, 07 May 2020 13:10:51 GMT

@Prakhar , as part of testing, can use select * query instead of select count(*), I have not faced any issue with select * ,I believe it could be issue with count(*)

Re: Error in tSnowFlakeInput

Prakhar1 — Thu, 07 May 2020 14:50:31 GMT

@manodwhb I removed dynamic and used and integer type column and it worked in 6.4, while the dynamic is working with talend 7.2

Re: Error in tSnowFlakeInput

manodwhb — Fri, 08 May 2020 05:00:56 GMT

@Prakhar, maybe that has fixed in 7.2.