FAQ
Correction: Create external table test.

Ram
On Monday, November 19, 2012 4:29:04 PM UTC-5, Ram Krishnamurthy wrote:

I have recently installed CDH4 using Cloudera Manager.
I have Hive installed as well.

The issue I am having is referencing hdfs location on Hive Create external
table command.

Here are the steps I am using:

a. Use hadoop fs -put test.txt command (test.txt exists and is formatted
correctly)
b. In Hive I am going in and executing the following:

CREATE TABLE test
(
SERIES_ID STRING,
TEST_ID STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\|' ESCAPED BY '\\'
STORED AS TEXTFILE
LOCATION '/test.txt';

I get no error.
but when i do count it is 0 records.

What am I doing wrong?

Thanks, Ram

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 4 | next ›
Discussion Overview
groupscm-users @
categorieshadoop
postedNov 19, '12 at 9:29p
activeNov 20, '12 at 3:43p
posts4
users3
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase