Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@Prakhar , are using dynamic schema in tSnowflakeInput?
@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?
@Prakhar , are using dynamic schema in tSnowflakeInput?
@manodwhb Hi ,
yes you are right i am using dynamic, is this a problem in snowflakeinput?
@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(*)
@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
@Prakhar, maybe that has fixed in 7.2.