Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
DV_Reddy
New 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)