[ https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thejas M Nair updated HIVE-5446: -------------------------------- Status: Open (was: Patch Available) > 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, HIVE-5446.3.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)