Skip to Content
1
Aug 08, 2022 at 01:20 PM

Hana column store error 2617 exceeded 2167466761

189 Views

Hi All,

I have a HANA table with more than 2.3 billion records and when executing a query I get the following error, sap Hana column store error 2617 exceeded limit 2167466761.

The table has partitions, but when executing a full table scan I get this error, when I use the 'where' condition the query executes fine.

Select median(FIELD A) from TABLE - get error

Select median(FIELD A) from TABLE where YEAR(FIELD B) < '2017' - return results, this will run on half of the table records.

I use HANA 2 SPS 04.

Any ideas?

Thanks,

Guy