https://community.cloudera.com/t5/Support-Questions/Help-me-proceed-which-way-to-go/m-p/313524#M225573 <P>Hello everyone,&nbsp;</P><P>&nbsp;</P><P>I need your help because I do not know how to proceed.&nbsp;</P><P>&nbsp;</P><P>Right now I have a PostgreSQL database with the following table:</P><P>&nbsp;</P><P>domains</P><P>domain, source, timestamp,</P><P>domainA, yourdomains, 128989372</P><P>domainB, yourdomaisn, 128923892</P><P>domainA, cyberclub, 13934829</P><P>domainD, cyberclub, 184994420</P><P>domainA, securityTeam, 118382938</P><P>&nbsp;</P><P>&nbsp;</P><P>My goal is to make some comparisons and alter the table. The most important one is to check every line for duplicates in the table in column "domain" like the first, the third and the last line and compare their timestamps. The one with the lowest timestamp gets a new column with the number 1. The next one gets 2 ... At the end I should see which source has how many ones.</P><P>&nbsp;</P><P>&nbsp;</P><P>Which tool should I use? I got Apache Flink or Spark recommended? Or another SQL Tool? Or plain SQL with scripts? I am happy for every tip!&nbsp;</P><P>&nbsp;</P><P>Best regards&nbsp;</P><P>&nbsp;</P><P>Maurice&nbsp;</P><DIV>&nbsp;</DIV> Sun, 21 Mar 2021 20:07:09 GMT Mandrill 2021-03-21T20:07:09Z