Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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