Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Prakhar1
Creator III
Creator III

Error in tSnowFlakeInput

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?

Labels (3)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@Prakhar , are using dynamic schema in tSnowflakeInput?

View solution in original post

6 Replies
manodwhb
Champion II
Champion II

@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
Champion II
Champion II

@Prakhar , are using dynamic schema in tSnowflakeInput?

Prakhar1
Creator III
Creator III
Author

@manodwhb Hi , 

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

manodwhb
Champion II
Champion II

@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
Creator III
Creator III
Author

@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
Champion II
Champion II

@Prakhar, maybe that has fixed in 7.2.