TION 'hdfs://hp8300one:8020/tmp/states' ;
From: Shengjun Xin
To: user@hive.apache.org
Sent: Tuesday, April 22, 2014 8:58 PM
Subject: Re: create table question
in the ql, you set relative path tmp/states, according to the error message,
you need to set
in the ql, you set relative path tmp/states, according to the error
message, you need to set absolute path
On Wed, Apr 23, 2014 at 11:23 AM, EdwardKing wrote:
> I use hadoop 2.2.0 and hive 0.13.0, I want to create a table from an
> existing file, states.hql is follows:
> CREATE EXTERNAL TABLE
I use hadoop 2.2.0 and hive 0.13.0, I want to create a table from an existing
file, states.hql is follows:
CREATE EXTERNAL TABLE states(abbreviation string, full_name
string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LOCATION 'tmp/states' ;
[hadoop@master ~]$ hadoop fs -ls
14/04/22 20:17:32
