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