hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces
Date Thu, 23 Jan 2014 05:18:35 GMT

    [ https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13879446#comment-13879446
] 

Xuefu Zhang commented on HIVE-5446:
-----------------------------------

Guys,

Please help me understand. If the data file is missing, then I would expect that the tests
relying on it would fail. Let's fix this once for all. [~shuainie] Could you please check
why the new tests didn't fail? If we can confirm that the data file is only the problem, I
can commit it.

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

Mime
View raw message