[
https://issues.apache.org/jira/browse/HIVE-21436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16794635#comment-16794635
]
archon gum commented on HIVE-21436:
-----------------------------------
[~damien.carol] presto 305 sql
{code:java}
insert into dim_date2 values (current_date);{code}
java -jar orc-tools-1.5.1-uber.jar meta data1.orc
{code:java}
Processing data file data1.orc [length: 255]
Structure for data1.orc
File Version: 0.12 with PRESTO_ORIGINAL
Rows: 1
Compression: ZLIB
Compression size: 262144
Type: struct<d:date>
Stripe Statistics:
Stripe 1:
Column 0: count: 1 hasNull: true
Column 1: count: 1 hasNull: true min: 2019-03-13 max: 2019-03-13
File Statistics:
Column 0: count: 1 hasNull: true
Column 1: count: 1 hasNull: true min: 2019-03-13 max: 2019-03-13
Stripes:
Stripe: offset: 3 data: 7 rows: 1 tail: 45 index: 24
Stream: column 1 section ROW_INDEX start: 3 length 24
Stream: column 1 section DATA start: 27 length 7
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
File length: 255 bytes
Padding length: 0 bytes
Padding ratio: 0%
User Metadata:
presto.writer.version=305
presto_query_id=20190313_060328_00174_vcbrs
presto_version=305
{code}
> "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)
