Error in tSnowFlakeInput

[Prakhar1]

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?

[manodwhb]

@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?

[manodwhb · Accepted solution]

@Prakhar , are using dynamic schema in tSnowflakeInput?

[Prakhar1]

@manodwhb Hi , 

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

[manodwhb]

@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(*)

[Prakhar1]

@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

[manodwhb]

@Prakhar, maybe that has fixed in 7.2.