hive> select senturl,count(*) as co from mlogs where empid != '-' group by senturl; Total jobs = 1 Launching Job 1 out of 1 Number of reduce tasks not specified. Estimated from input data size: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapreduce.job.reduces=<number> Program hanged here........................... ... View more

Now I can access the Hive tables , but when I try to use complex hive query( two select statements ) , the process hanged . @Ajay ... View more

Thanks @Jitendra Yadav . Hive --service metastore now I can access hive shell . But ... only when I start metastore service in another terminal . As I close this metastore window .. Hive stop and throw exception FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTa sk. MetaException(message:Got exception: org.apache.thrift.transport.TTransportE xception null) ... View more

@Jitendra Yadav : Hi , I didnot have Ambari installed . Do we have any command which I can run to start metastore service. ... View more

@Kuldeep Kulkarni :No I am not using Ambari I am using distributed system which has one namenode and two datanode . This for POC purpose only . This is simple unix machine which had hadoop , hive ,hbase installed. Please guide me accordingly. ... View more

@Jitendra Yadav : Thanks , I am using distributed system which has one namenode and two datanode . This for POC purpose only . Can you please elaborate more on this . I logged in Namenode assume : xx.xx.xx.xx Hadoop hdfs commands working fine. But when I try to enter into hive shell it throwing error. 1. As hive installed in Namenode so we had IP of namenode. 2. ps -aef|grep -i org.apache.hadoop.hive.metastore.HiveMetaStore o/p : hadoop 15097 13478 0 16:21 pts/2 00:00:00 grep -i org.apache.hadoop.hive.metastore.HiveMetaStore lsof -i:9083 o/p : Did not get any output for the same 3. Getting connection refused .. telnet < Namenode IP> 9083 This is simple unix machine which had hadoop , hive ,hbase installed. Please guide me on this. ... View more

@Kuldeep Kulkarni : Getting connection refused as below also why we use port 9038 telnet xx.xx.xx.xx 9038 Trying xx.xx.xx.xx... telnet: connect to address xx.xx.xx.xx: Connection refused ... View more

Sorry can you please suggest where this file should be present? @nyakkanti ... View more

@Kuldeep Kulkarni : Can you please brief that how should I check connectivity? ... View more

@nyakkanti ... View more