Member since
02-24-2016
87
Posts
18
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
4161 | 12-18-2017 11:47 AM | |
11570 | 11-08-2017 01:54 PM | |
65559 | 05-06-2016 11:48 AM |
04-25-2016
01:03 PM
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
04-25-2016
12:56 PM
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
04-21-2016
06:24 AM
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
04-20-2016
01:49 PM
@Jitendra Yadav : Hi , I didnot have Ambari installed . Do we have any command which I can run to start metastore service.
... View more
04-20-2016
11:47 AM
@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
04-20-2016
10:55 AM
@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
04-20-2016
10:34 AM
@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
04-20-2016
10:27 AM
Sorry can you please suggest where this file should be present? @nyakkanti
... View more
04-20-2016
10:16 AM
@Kuldeep Kulkarni : Can you please brief that how should I check connectivity?
... View more
- « Previous
- Next »