hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "archon gum (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-21436) "Malformed ORC file" when only one data-file in external table directory
Date Wed, 13 Mar 2019 06:06:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-21436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

archon gum updated HIVE-21436:
------------------------------
     Attachment: data1.orc
    Description: 
h1. env
 * Presto 305
 * Hive 3.1.0

 
h1. step

 
{code:java}
-- create external table using presto
create table hive.dw.dim_date2 (
  d date
) with (
  format = 'ORC',
  external_location = '/user/hive/warehouse/dw.db/dim_date2/'
);

-- 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}
-- insert one row using presto
insert into dim_date2 values (current_date);
{code}
!2.jpg!

  was:
h1. env


* Presto 305
* Hive 3.1.0
h1. 
step

 
{code:java}
-- create external table using presto
create table hive.dw.dim_date2 (
  d date
) with (
  format = 'ORC',
  external_location = '/user/hive/warehouse/dw.db/dim_date2/'
);

-- 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}
-- insert one row using presto
insert into dim_date2 values (current_date);
{code}

!2.jpg!


> "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 presto
> create table hive.dw.dim_date2 (
>   d date
> ) with (
>   format = 'ORC',
>   external_location = '/user/hive/warehouse/dw.db/dim_date2/'
> );
> -- 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}
> -- 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)

Mime
View raw message