Wednesday, September 21, 2011 2:45 PM
> Subject: Re: Exception when joining HIVE tables
>
> Here is the table info, and the query is "select acctbal, availqty, partkey
> from partsupp JOIN supplier ON (partsupp.suppkey == supplier.suppkey); "
>
> desc
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:
tions.
From: Krish Khambadkone
To: user@hive.apache.org
Sent: Wednesday, September 21, 2011 2:45 PM
Subject: Re: Exception when joining HIVE tables
Here is the table info, and the query is "select acctbal, availqty, partkey
from partsupp JOIN supplier ON (partsupp.suppkey == suppli
> -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, September 21, 2011 1:11 PM
> Subject: Exception when joining HIVE tables
>
> Hi, I get thi
, September 21, 2011 1:11 PM
Subject: Exception when joining HIVE tables
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 ve
"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
