Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
DV_Reddy
Contributor
Contributor

aws athena simba odbc driver

Simba dbc driver seems to work fine for small tables but for medium to larger tables i keep running into the following errors. Data is in Athena partition using a date. All the columns in hive are either string or timestamp and don't have any nulls values. The same table doesn't throw the same error each time. 

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 40321, ErrorMsg: [Simba][Support] (40321) String value '' resulted in an invalid numeric.

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 40483, ErrorMsg: [Simba][Support] (40483) Invalid timestamp format for ''. The format should be [-]YYYY-MM-DD hh:mm:ss[.fffffffff].

Labels (4)
0 Replies