I am now getting this exception, all my hadoop and hbase processes are running
(nn,dnn,dn,jt,tt, hm, hr, hq)
java.net.ConnectException: Call to localhost/127.0.0.1:9000 failed on
connection exception: java.net.ConnectException: Connection refused
at org.apache.hadoop.ipc.Client.wrapException(C
Hi,
I am trying to use uniquejoin to join multiple tables with same key in one
mapreduce job.
It works well if I stage individual partition data in temporary staging
tables.
But, if I make it work on top of partitioned tables, I do not get any
output.
Does anyone know how to fix this?
I am using
It does return this,
-rw-r--r-- 3 hadoop supergroup 99 2011-09-21 13:07
/user/hive/warehouse/supplier/supplier.txt
On Sep 21, 2011, at 3:01 PM, Ayon Sinha wrote:
> I'm a bit concerned about port 9000 for the HDFS location. Is your namenode
> at port 9000? Can you run
> hadoop dfs -ls
I'm a bit concerned about port 9000 for the HDFS location. Is your namenode at
port 9000? Can you run
hadoop dfs -ls hdfs://localhost:9000/user/hive/warehouse/supplier
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
_
Here is the table info, and the query is "select acctbal, availqty, partkey
from partsupp JOIN supplier ON (partsupp.suppkey == supplier.suppkey); "
desc formatted supplier;
OK
# col_name data_type comment
key string
If you can share details of your tables and query we might be able to help. Do
a desc formatted
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
From: Krish Khambadkone
To: user@hive.apache.org
Sent: Wednesday, Se
"select * from table" does not use map-reduce
so it seems your error has to do with hadoop/map-reduce, not hive
i would run some test for map-reduce
On Wed, Sep 21, 2011 at 4:11 PM, Krish Khambadkone
wrote:
> Hi, I get this exception when I try to join two hive tables or even when I
> use a spec
Hi, I get this exception when I try to join two hive tables or even when I use
a specific WHERE clause. "SELECT *" from any individual table seems to work
fine. Any idea what is missing here. I am on hive version hive-0.7.0-cdh3u0.
java.lang.IllegalArgumentException: Can not create a Path f
Hi Rohan
As of now, we support queries with aggregate function count on columns which
are the same as index key column and are used in group-by construct. For
example,
CREATE TABLE tbl(key int, value int);
CREATE INDEX tbl_key_idx ON TABLE tbl(key) AS
'org.apache.hadoop.hive.ql.index.AggregateInde
