It has started working now. I don't know what I changed. I dropped every
single table from hive, explicitly created a new directory on HDFS and moved
the .csv file to that directory, ran hive again and created the table. This
time it worked. I can perform queries against the directory. Mayb
What does a simple "select * from stringmap limit 10" return ?
On Mon, Mar 12, 2012 at 12:51 PM, Keith Wiley wrote:
> On Mar 9, 2012, at 16:46 , Steven Wong wrote:
>
>> The LOCATION clause has to specify the directory that contains (only) your
>> data files.
>
> I've tried it both ways:
>
> CREA
On Mar 9, 2012, at 16:46 , Steven Wong wrote:
> The LOCATION clause has to specify the directory that contains (only) your
> data files.
I've tried it both ways:
CREATE EXTERNAL TABLE stringmap (ObjectTypeCode INT, AttributeName STRING,
AttributeValue INT, LangId INT, Value STRING, DisplayOrde
So a directory, not a specific file. I thought I tried it both ways, but I'll
switch it back the other way and try again.
Thanks.
On Mar 9, 2012, at 16:46 , Steven Wong wrote:
> The LOCATION clause has to specify the directory that contains (only) your
> data files.
The LOCATION clause has to specify the directory that contains (only) your data
files.
-Original Message-
From: Keith Wiley [mailto:kwi...@keithwiley.com]
Sent: Friday, March 09, 2012 3:44 PM
To: user@hive.apache.org
Subject: Basic statement problems
I successfully installed and used Hi
