[
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13880211#comment-13880211
]
Shuaishuai Nie commented on HIVE-5446:
--------------------------------------
Hi [~xuefuz], I tested it on my local machine and the unit test
"external_table_with_space_in_location_path.q" failed. After I added the
missing file, the test pass. I checked HIVE QA test report here:
http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/. From the
TestMinimrCliDriver test result you can see lots of minimr tests are missing if
you compare with the list of <minimr.query.files> in the pom.xml in
itests/qtest. If this is the problem, I think we need to open a JIRA for this.
Thanks
> 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)
