You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Shuaishuai Nie (JIRA)" <ji...@apache.org> on 2013/10/04 19:17:42 UTC

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

Shuaishuai Nie created HIVE-5446:
------------------------------------

             Summary: 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

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#6144)