[ https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13879391#comment-13879391 ]
Jason Dere commented on HIVE-5446: ---------------------------------- Hey, is the commit for this fix missing file data/files/ext_test_space/folder+with space/data.txt? I don't see it on git. I would have thought that any of the pre commit tests run after this commit would have failed on this test since the required data file is missing. > 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 > Fix For: 0.13.0 > > Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, > HIVE-5446.4.patch, HIVE-5446.5.patch, HIVE-5446.7.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)