#DateForumTypeThreadPost
219 Jul 2016 @ 06:14 PDTDatabaseReplyFunction quantile throws a numeric overflow error in a large tableThank you Fred and Dnoeth. I tried the OLAP option, but it takes too long. I worked with my busessiness user and reduced the amount of data we are pulling. That works for now. For Dnoeth's sug...
118 Jul 2016 @ 12:33 PDTDatabaseTopicFunction quantile throws a numeric overflow error in a large tableI have a large table and it holds about 33 billion records. I need to run simple quantile function but it failed with a numeric overflow error. SELECT acct_id, QUANTILE (10, ACCT_ID) AS decile &nb...