[ https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13863502#comment-13863502 ]
Thejas M Nair commented on HIVE-5446: ------------------------------------- +1 . Looks good. There is a typo in the error message ""Invalid UIR" , but I can take care of that while committing. > 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)