Question: I have a `table` as below 

```
   Art      PP No        ArtDate     ArtQty OPDate       OPQTY

   102844   1100023223   02-09-2015  0      31-08-2015      0
   102844   1100023766   03-11-2015  0      05-11-2015      1
   102844   1100023766   03-11-2015  1      05-11-2015      149
   102844   1100023766   03-11-2015  149    05-11-2015      1

```

I need to `group by` and expected answer

```
 Art    PP No       ArtDate         ArtQty  OPDate       OPQTY

102844  1100023223  02-09-2015      0       31-08-2015   0
102844  1100023766  03-11-2015      150     05-11-2015  151

```

How to achieve this?

Answer: 
Normally Port use to get configured in the Configuration Files it self, available in either under "/etc/hadoop/conf/" or "/usr/local/hadoop/conf/" location "hadoop" with respected names like "pig/hive/sqoop" etc.
The Configuration named as "hdfs-site.xml/core-site.xml/hive-site.xml/mapred-site.xml...etc"
Some of the default Ports Used by Hadoop and it's Eco Systmems are:

```
Daemon                      Default Port    Configuration Paramete
Namenode                    50070           dfs.http.address
Datanodes                   50075           dfs.datanode.http.address
Secondarynamenode           50090           dfs.secondary.http.address
Backup/Checkpoint node      50105           dfs.backup.http.address
Jobracker                   50030           mapred.job.tracker.http.address
Tasktrackers                50060           mapred.task.tracker.http.address

```

Also Check Reference: [MORE DETAIL PORTS](http://www.cloudera.com/content/www/en-us/documentation/enterprise/5-2-x/topics/cdh_ig_ports_cdh5.html)
You can take advantage of Cloudera Distribution of Hadoop post numbers for each components : [Ports Used by Components of CDH 5](http://www.cloudera.com/content/www/en-us/documentation/enterprise/latest/topics/cdh_ig_ports_cdh5.html)