[jira] [Commented] (HIVE-21436) "Malformed ORC file" when only one data-file in external table directory

["Damien Carol (JIRA)" <ji...@apache.org>]

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

Damien Carol commented on HIVE-21436:
-------------------------------------

[~archon] how have you generated this orc file ?

> "Malformed ORC file" when only one data-file in external table directory
> ------------------------------------------------------------------------
>
>                 Key: HIVE-21436
>                 URL: https://issues.apache.org/jira/browse/HIVE-21436
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.1.0
>            Reporter: archon gum
>            Priority: Blocker
>         Attachments: 1.jpg, 2.jpg, data1.orc
>
>
> h1. env
>  * Presto 305
>  * Hive 3.1.0
>  
> h1. step
>  
> {code:java}
> -- create external table using hiveserver2
> CREATE EXTERNAL TABLE `dw.dim_date2`(
>   `d` date
> )
> STORED AS ORC
> LOCATION
>   'hdfs://datacenter1:8020/user/hive/warehouse/dw.db/dim_date2'
> ;
> -- upload the 'data1.orc' file from attachments
> -- OR
> -- insert one row using presto
> insert into dim_date2 values (current_date);
> {code}
>  
>  
> when using `hiveserver2` to query, it works only at the first query and error after then
> !1.jpg!
>  
> If I insert another row, it works
> {code:java}
> -- upload the 'data1.orc' file from attachments
> -- OR
> -- insert one row using presto
> insert into dim_date2 values (current_date);
> {code}
> !2.jpg!



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)