[HIVE-5446] Hive can CREATE an external table but not SELECT from it when file path have spaces

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Assignee: Shuaishuai Nie
• Reporter: Shuaishuai Nie
• Created: 04/Oct/13 17:16
• Updated: 14/Jul/14 19:57
• Resolved: 10/Jan/14 21:12

Description

Create external table table1 (age int,
gender string, totBil float,
dirBill float, alkphos int,
sgpt int, sgot int, totProt float,
aLB float, aG float, sel int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION 'hdfs://namenodehost:9000/hive newtable';

select * from table1;
return nothing even there is file in the target folder

Issue Links

• is related to: HIVE-6293 Not all minimr tests are executed or reported in precommit test run
• links to: Review Board link