https://communities.sas.com/t5/SAS-Programming/column-search-intermediate-result-exceeds-2-billion-rows/m-p/590069#M168847 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/277786">@seshu456</a>&nbsp;wrote:<BR /> <P>While reading one of the data set from SAP HANA getting this error.</P> <P>&nbsp;</P> <P>column search intermediate result exceeds 2 billion rows limitation</P> <P>&nbsp;</P> <P>Is there any way to read that data set?</P> <HR /></BLOCKQUOTE> <P>Can you show the code step and complete message from the LOG where this occurred? Or was this a pop up message of some sort?</P> <P>&nbsp;</P> <P>I don't actually see anything that you posted that indicates an error. Just that you exceeded a preset limit. And since you are saying SAP this may be an SAP limitation possibly set by a DB Admin to limit results because you aren't expected to need/use that many records.</P> Thu, 19 Sep 2019 15:29:19 GMT ballardw 2019-09-19T15:29:19Z https://communities.sas.com/t5/SAS-Programming/column-search-intermediate-result-exceeds-2-billion-rows/m-p/590003#M168820 <P>While reading one of the data set from SAP HANA getting this error.</P><P>&nbsp;</P><P>column search intermediate result exceeds 2 billion rows limitation</P><P>&nbsp;</P><P>Is there any way to read that data set?</P> Thu, 19 Sep 2019 12:49:41 GMT https://communities.sas.com/t5/SAS-Programming/column-search-intermediate-result-exceeds-2-billion-rows/m-p/590003#M168820 seshu456 2019-09-19T12:49:41Z https://communities.sas.com/t5/SAS-Programming/column-search-intermediate-result-exceeds-2-billion-rows/m-p/590069#M168847 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/277786">@seshu456</a>&nbsp;wrote:<BR /> <P>While reading one of the data set from SAP HANA getting this error.</P> <P>&nbsp;</P> <P>column search intermediate result exceeds 2 billion rows limitation</P> <P>&nbsp;</P> <P>Is there any way to read that data set?</P> <HR /></BLOCKQUOTE> <P>Can you show the code step and complete message from the LOG where this occurred? Or was this a pop up message of some sort?</P> <P>&nbsp;</P> <P>I don't actually see anything that you posted that indicates an error. Just that you exceeded a preset limit. And since you are saying SAP this may be an SAP limitation possibly set by a DB Admin to limit results because you aren't expected to need/use that many records.</P> Thu, 19 Sep 2019 15:29:19 GMT https://communities.sas.com/t5/SAS-Programming/column-search-intermediate-result-exceeds-2-billion-rows/m-p/590069#M168847 ballardw 2019-09-19T15:29:19Z