Qlik Community

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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