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
Here are the steps I am using:
a. Use hadoop fs -put test.txt command (test.txt exists and is formatted
b. In Hive I am going in and executing the following:
CREATE TABLE test
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\|' ESCAPED BY '\\'
STORED AS TEXTFILE
I get no error.
but when i do count it is 0 records.
What am I doing wrong?