2088965 - loading data from HANA to IQ does not load all data

Symptom

• Creating existing local temporary table only pulling half the rows from HANA.

Environment

• SAP IQ 16 sp08.x
• All plaforms
• HANA

Cause

• Issue is only relevant for partitioned HANA tables
• The odbc leaf issues multiple queries against the table using the LIMIT clause. Some of the queries are incorrectly returning 0 rows.

Resolution

• SAP IQ bug 773093 and HANA Bug 66125
• Workaround:

           set temporary option dml_options7=1048576

Keywords

• "SAP_IQ" "HANA"
• "CREATE EXISTING LOCAL TEMPORARY TABLE'
• "PARTITIONED HANA TABLE"
• "INCORRECT NUMBER OF ROWS"

Header Data

Released On	07.01.2015 16:46:04
Release Status	Released to Customer
Component	BC-SYB-IQ Sybase IQ
Priority	Normal
Category	Problem