You have chosen to sponsor your bid up to a maximum amount of .
We have a large table with 2 ID columns. (2 billion rows). I need a script to run and compare the 2 columns and group by to create a results table that would include:
ID1, ID2, COUNT.
The end results table could be 15 billion rows.
I need this urgent
Mysql and other DBs are not fast enough and we need some sort of search technology like SOLR to generate the results table very very fast.