[ https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13861744#comment-13861744 ]
Shuaishuai Nie commented on HIVE-5446: -------------------------------------- Hi [~xuefuz], thanks for the advice. I run the unit test with the latest trunk and the problem still exist, so I think we still need the fix. Also I have validated that the failed tests in HIVE QA is not related to the patch. > Hive can CREATE an external table but not SELECT from it when file path have > spaces > ----------------------------------------------------------------------------------- > > Key: HIVE-5446 > URL: https://issues.apache.org/jira/browse/HIVE-5446 > Project: Hive > Issue Type: Bug > Reporter: Shuaishuai Nie > Assignee: Shuaishuai Nie > Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch > > > 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 -- This message was sent by Atlassian JIRA (v6.1.5#6160)