You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Daniel Haviv <da...@veracity-group.com> on 2014/12/10 16:54:16 UTC
Concatenating ORC files
Hi,
I'm trying to use the new concatenate command merge small ORC files and
file right away:
alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
concatenate;
Diagnostic Messages for this Task:
Error: java.lang.IllegalArgumentException: Column has wrong number of index
entries found: 0 expected: 1
at
org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
at
org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
at
org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
at
org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
at
org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
at
org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Is there some property I need to set for ORC to be able to support
concatenation?
Thanks,
Daniel
Re: Concatenating ORC files
Posted by Daniel Haviv <da...@veracity-group.com>.
HI Prasanth,
The first attempt had ("orc.compress"="Snappy") and all the files under it
were created the same way so I'm assuming they all should have indexes
created.
In the second attempt I used ("orc.create.index"="false",
"orc.compress"="Snappy").
Thanks,
Daniel
ll
On Wed, Dec 10, 2014 at 9:04 PM, Prasanth Jayachandran <
pjayachandran@hortonworks.com> wrote:
> Hi Daniel
>
> In you first run, are there some files with “orc.create.index”=“false”?
> What are the table properties used to create ORC files in both cases?
>
> - Prasanth
>
>
> On Wed, Dec 10, 2014 at 7:55 AM, Daniel Haviv <
> daniel.haviv@veracity-group.com> wrote:
>
>> Hi,
>> I'm trying to use the new concatenate command merge small ORC files and
>> file right away:
>>
>> alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
>> concatenate;
>>
>> Diagnostic Messages for this Task:
>> Error: java.lang.IllegalArgumentException: Column has wrong number of
>> index entries found: 0 expected: 1
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
>> at
>> org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
>> at
>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
>> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at javax.security.auth.Subject.doAs(Subject.java:415)
>> at
>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>
>>
>> Is there some property I need to set for ORC to be able to support
>> concatenation?
>>
>> Thanks,
>> Daniel
>>
>>
>>
>
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity
> to which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
Re: Concatenating ORC files
Posted by Prasanth Jayachandran <pj...@hortonworks.com>.
Hi Daniel
In you first run, are there some files with “orc.create.index”=“false”? What are the table properties used to create ORC files in both cases?
- Prasanth
On Wed, Dec 10, 2014 at 7:55 AM, Daniel Haviv
<da...@veracity-group.com> wrote:
> Hi,
> I'm trying to use the new concatenate command merge small ORC files and
> file right away:
> alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
> concatenate;
> Diagnostic Messages for this Task:
> Error: java.lang.IllegalArgumentException: Column has wrong number of index
> entries found: 0 expected: 1
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
> at
> org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
> at
> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:415)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
> Is there some property I need to set for ORC to be able to support
> concatenation?
> Thanks,
> Daniel
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: Concatenating ORC files
Posted by Daniel Haviv <da...@veracity-group.com>.
Thanks a lot
I'll try it out
Daniel
> On 12 בדצמ׳ 2014, at 03:45, Prasanth Jayachandran <pj...@hortonworks.com> wrote:
>
> Thanks Daniel for filing the jira and the test case. I have put up a patch in HIVE-9067 jira that should fix this issue.
>
> - Prasanth
>
>
>> On Thu, Dec 11, 2014 at 3:29 AM, Daniel Haviv <da...@veracity-group.com> wrote:
>> Hi,
>> I've created a JIRA with a test case:
>> https://issues.apache.org/jira/browse/HIVE-9080
>>
>> Thanks!
>> Daniel
>>
>>> On Thu, Dec 11, 2014 at 12:49 AM, Prasanth Jayachandran <pj...@hortonworks.com> wrote:
>>> I am unable to reproduce the case that causes exception that you are seeing. Will be great if you can provide a repro.
>>>
>>> - Prasanth
>>>
>>>
>>>> On Wed, Dec 10, 2014 at 1:43 PM, Prasanth Jayachandran <pj...@hortonworks.com> wrote:
>>>> I can see a bug for the case 2 where orc index is disabled. I have created a jira to track that issue.
>>>> https://issues.apache.org/jira/browse/HIVE-9067
>>>>
>>>> I am not sure why does it fail in case 1 though. Can you create a jira with a reproducible case? I can take a look at it.
>>>>
>>>> - Prasanth
>>>>
>>>>
>>>>> On Wed, Dec 10, 2014 at 10:37 AM, Daniel Haviv <da...@veracity-group.com> wrote:
>>>>> I've made a little experiment and recreated the table with 'orc.create.index'='FALSE' and now it fails on something else:
>>>>> Error: java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$StringStatisticsImpl cannot be cast to org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$BooleanStatisticsImpl
>>>>> at org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.map(MergeFileMapper.java:115)
>>>>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
>>>>> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>>>>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>>>>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>>>>> at java.security.AccessController.doPrivileged(Native Method)
>>>>> at javax.security.auth.Subject.doAs(Subject.java:415)
>>>>> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>>>>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>>>>
>>>>> It seems that the concatenation feature needs more work..
>>>>>
>>>>> Daniel
>>>>>
>>>>>> On Wed, Dec 10, 2014 at 4:54 PM, Daniel Haviv <da...@veracity-group.com> wrote:
>>>>>> Hi,
>>>>>> I'm trying to use the new concatenate command merge small ORC files and file right away:
>>>>>>
>>>>>> alter table requests partition(day_ts=1418083200, hour_ts=1418151600) concatenate;
>>>>>>
>>>>>> Diagnostic Messages for this Task:
>>>>>> Error: java.lang.IllegalArgumentException: Column has wrong number of index entries found: 0 expected: 1
>>>>>> at org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
>>>>>> at org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
>>>>>> at org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
>>>>>> at org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
>>>>>> at org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
>>>>>> at org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
>>>>>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
>>>>>> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>>>>>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>>>>>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>>>>>> at java.security.AccessController.doPrivileged(Native Method)
>>>>>> at javax.security.auth.Subject.doAs(Subject.java:415)
>>>>>> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>>>>>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>>>>>
>>>>>>
>>>>>> Is there some property I need to set for ORC to be able to support concatenation?
>>>>>>
>>>>>> Thanks,
>>>>>> Daniel
>>>
>>>
>>> CONFIDENTIALITY NOTICE
>>> NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
>
>
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
Re: Concatenating ORC files
Posted by Prasanth Jayachandran <pj...@hortonworks.com>.
Thanks Daniel for filing the jira and the test case. I have put up a patch in HIVE-9067 jira that should fix this issue.
- Prasanth
On Thu, Dec 11, 2014 at 3:29 AM, Daniel Haviv
<da...@veracity-group.com> wrote:
> Hi,
> I've created a JIRA with a test case:
> https://issues.apache.org/jira/browse/HIVE-9080
> Thanks!
> Daniel
> On Thu, Dec 11, 2014 at 12:49 AM, Prasanth Jayachandran <
> pjayachandran@hortonworks.com> wrote:
>> I am unable to reproduce the case that causes exception that you are
>> seeing. Will be great if you can provide a repro.
>>
>> - Prasanth
>>
>>
>> On Wed, Dec 10, 2014 at 1:43 PM, Prasanth Jayachandran <
>> pjayachandran@hortonworks.com> wrote:
>>
>>> I can see a bug for the case 2 where orc index is disabled. I have
>>> created a jira to track that issue.
>>> https://issues.apache.org/jira/browse/HIVE-9067
>>>
>>> I am not sure why does it fail in case 1 though. Can you create a jira
>>> with a reproducible case? I can take a look at it.
>>>
>>> - Prasanth
>>>
>>>
>>> On Wed, Dec 10, 2014 at 10:37 AM, Daniel Haviv <
>>> daniel.haviv@veracity-group.com> wrote:
>>>
>>>> I've made a little experiment and recreated the table
>>>> with 'orc.create.index'='FALSE' and now it fails on something else:
>>>> Error: java.io.IOException:
>>>> org.apache.hadoop.hive.ql.metadata.HiveException:
>>>> java.lang.ClassCastException:
>>>> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$StringStatisticsImpl
>>>> cannot be cast to
>>>> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$BooleanStatisticsImpl
>>>> at
>>>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.map(MergeFileMapper.java:115)
>>>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
>>>> at
>>>> org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>>>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>>>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>>>> at java.security.AccessController.doPrivileged(Native Method)
>>>> at javax.security.auth.Subject.doAs(Subject.java:415)
>>>> at
>>>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>>>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>>>
>>>> It seems that the concatenation feature needs more work..
>>>>
>>>> Daniel
>>>>
>>>> On Wed, Dec 10, 2014 at 4:54 PM, Daniel Haviv <
>>>> daniel.haviv@veracity-group.com> wrote:
>>>>
>>>>> Hi,
>>>>> I'm trying to use the new concatenate command merge small ORC files and
>>>>> file right away:
>>>>>
>>>>> alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
>>>>> concatenate;
>>>>>
>>>>> Diagnostic Messages for this Task:
>>>>> Error: java.lang.IllegalArgumentException: Column has wrong number of
>>>>> index entries found: 0 expected: 1
>>>>> at
>>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
>>>>> at
>>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
>>>>> at
>>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
>>>>> at
>>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
>>>>> at
>>>>> org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
>>>>> at
>>>>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
>>>>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
>>>>> at
>>>>> org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>>>>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>>>>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>>>>> at java.security.AccessController.doPrivileged(Native Method)
>>>>> at javax.security.auth.Subject.doAs(Subject.java:415)
>>>>> at
>>>>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>>>>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>>>>
>>>>>
>>>>> Is there some property I need to set for ORC to be able to support
>>>>> concatenation?
>>>>>
>>>>> Thanks,
>>>>> Daniel
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>> CONFIDENTIALITY NOTICE
>> NOTICE: This message is intended for the use of the individual or entity
>> to which it is addressed and may contain information that is confidential,
>> privileged and exempt from disclosure under applicable law. If the reader
>> of this message is not the intended recipient, you are hereby notified that
>> any printing, copying, dissemination, distribution, disclosure or
>> forwarding of this communication is strictly prohibited. If you have
>> received this communication in error, please contact the sender immediately
>> and delete it from your system. Thank You.
>>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: Concatenating ORC files
Posted by Daniel Haviv <da...@veracity-group.com>.
Hi,
I've created a JIRA with a test case:
https://issues.apache.org/jira/browse/HIVE-9080
Thanks!
Daniel
On Thu, Dec 11, 2014 at 12:49 AM, Prasanth Jayachandran <
pjayachandran@hortonworks.com> wrote:
> I am unable to reproduce the case that causes exception that you are
> seeing. Will be great if you can provide a repro.
>
> - Prasanth
>
>
> On Wed, Dec 10, 2014 at 1:43 PM, Prasanth Jayachandran <
> pjayachandran@hortonworks.com> wrote:
>
>> I can see a bug for the case 2 where orc index is disabled. I have
>> created a jira to track that issue.
>> https://issues.apache.org/jira/browse/HIVE-9067
>>
>> I am not sure why does it fail in case 1 though. Can you create a jira
>> with a reproducible case? I can take a look at it.
>>
>> - Prasanth
>>
>>
>> On Wed, Dec 10, 2014 at 10:37 AM, Daniel Haviv <
>> daniel.haviv@veracity-group.com> wrote:
>>
>>> I've made a little experiment and recreated the table
>>> with 'orc.create.index'='FALSE' and now it fails on something else:
>>> Error: java.io.IOException:
>>> org.apache.hadoop.hive.ql.metadata.HiveException:
>>> java.lang.ClassCastException:
>>> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$StringStatisticsImpl
>>> cannot be cast to
>>> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$BooleanStatisticsImpl
>>> at
>>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.map(MergeFileMapper.java:115)
>>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
>>> at
>>> org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>>> at java.security.AccessController.doPrivileged(Native Method)
>>> at javax.security.auth.Subject.doAs(Subject.java:415)
>>> at
>>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>>
>>> It seems that the concatenation feature needs more work..
>>>
>>> Daniel
>>>
>>> On Wed, Dec 10, 2014 at 4:54 PM, Daniel Haviv <
>>> daniel.haviv@veracity-group.com> wrote:
>>>
>>>> Hi,
>>>> I'm trying to use the new concatenate command merge small ORC files and
>>>> file right away:
>>>>
>>>> alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
>>>> concatenate;
>>>>
>>>> Diagnostic Messages for this Task:
>>>> Error: java.lang.IllegalArgumentException: Column has wrong number of
>>>> index entries found: 0 expected: 1
>>>> at
>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
>>>> at
>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
>>>> at
>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
>>>> at
>>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
>>>> at
>>>> org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
>>>> at
>>>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
>>>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
>>>> at
>>>> org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>>>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>>>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>>>> at java.security.AccessController.doPrivileged(Native Method)
>>>> at javax.security.auth.Subject.doAs(Subject.java:415)
>>>> at
>>>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>>>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>>>
>>>>
>>>> Is there some property I need to set for ORC to be able to support
>>>> concatenation?
>>>>
>>>> Thanks,
>>>> Daniel
>>>>
>>>>
>>>>
>>>
>>
>
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity
> to which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
>
Re: Concatenating ORC files
Posted by Prasanth Jayachandran <pj...@hortonworks.com>.
I am unable to reproduce the case that causes exception that you are seeing. Will be great if you can provide a repro.
- Prasanth
On Wed, Dec 10, 2014 at 1:43 PM, Prasanth Jayachandran
<pj...@hortonworks.com> wrote:
> I can see a bug for the case 2 where orc index is disabled. I have created a jira to track that issue.
> https://issues.apache.org/jira/browse/HIVE-9067
> I am not sure why does it fail in case 1 though. Can you create a jira with a reproducible case? I can take a look at it.
> - Prasanth
> On Wed, Dec 10, 2014 at 10:37 AM, Daniel Haviv
> <da...@veracity-group.com> wrote:
>> I've made a little experiment and recreated the table
>> with 'orc.create.index'='FALSE' and now it fails on something else:
>> Error: java.io.IOException:
>> org.apache.hadoop.hive.ql.metadata.HiveException:
>> java.lang.ClassCastException:
>> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$StringStatisticsImpl
>> cannot be cast to
>> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$BooleanStatisticsImpl
>> at
>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.map(MergeFileMapper.java:115)
>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
>> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at javax.security.auth.Subject.doAs(Subject.java:415)
>> at
>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>> It seems that the concatenation feature needs more work..
>> Daniel
>> On Wed, Dec 10, 2014 at 4:54 PM, Daniel Haviv <
>> daniel.haviv@veracity-group.com> wrote:
>>> Hi,
>>> I'm trying to use the new concatenate command merge small ORC files and
>>> file right away:
>>>
>>> alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
>>> concatenate;
>>>
>>> Diagnostic Messages for this Task:
>>> Error: java.lang.IllegalArgumentException: Column has wrong number of
>>> index entries found: 0 expected: 1
>>> at
>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
>>> at
>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
>>> at
>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
>>> at
>>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
>>> at
>>> org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
>>> at
>>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
>>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
>>> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>>> at java.security.AccessController.doPrivileged(Native Method)
>>> at javax.security.auth.Subject.doAs(Subject.java:415)
>>> at
>>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>>
>>>
>>> Is there some property I need to set for ORC to be able to support
>>> concatenation?
>>>
>>> Thanks,
>>> Daniel
>>>
>>>
>>>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: Concatenating ORC files
Posted by Prasanth Jayachandran <pj...@hortonworks.com>.
I can see a bug for the case 2 where orc index is disabled. I have created a jira to track that issue.
https://issues.apache.org/jira/browse/HIVE-9067
I am not sure why does it fail in case 1 though. Can you create a jira with a reproducible case? I can take a look at it.
- Prasanth
On Wed, Dec 10, 2014 at 10:37 AM, Daniel Haviv
<da...@veracity-group.com> wrote:
> I've made a little experiment and recreated the table
> with 'orc.create.index'='FALSE' and now it fails on something else:
> Error: java.io.IOException:
> org.apache.hadoop.hive.ql.metadata.HiveException:
> java.lang.ClassCastException:
> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$StringStatisticsImpl
> cannot be cast to
> org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$BooleanStatisticsImpl
> at
> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.map(MergeFileMapper.java:115)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:415)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
> It seems that the concatenation feature needs more work..
> Daniel
> On Wed, Dec 10, 2014 at 4:54 PM, Daniel Haviv <
> daniel.haviv@veracity-group.com> wrote:
>> Hi,
>> I'm trying to use the new concatenate command merge small ORC files and
>> file right away:
>>
>> alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
>> concatenate;
>>
>> Diagnostic Messages for this Task:
>> Error: java.lang.IllegalArgumentException: Column has wrong number of
>> index entries found: 0 expected: 1
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
>> at
>> org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
>> at
>> org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
>> at
>> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
>> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
>> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
>> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
>> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at javax.security.auth.Subject.doAs(Subject.java:415)
>> at
>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
>> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>>
>>
>> Is there some property I need to set for ORC to be able to support
>> concatenation?
>>
>> Thanks,
>> Daniel
>>
>>
>>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: Concatenating ORC files
Posted by Daniel Haviv <da...@veracity-group.com>.
I've made a little experiment and recreated the table
with 'orc.create.index'='FALSE' and now it fails on something else:
Error: java.io.IOException:
org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.ClassCastException:
org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$StringStatisticsImpl
cannot be cast to
org.apache.hadoop.hive.ql.io.orc.ColumnStatisticsImpl$BooleanStatisticsImpl
at
org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.map(MergeFileMapper.java:115)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
It seems that the concatenation feature needs more work..
Daniel
On Wed, Dec 10, 2014 at 4:54 PM, Daniel Haviv <
daniel.haviv@veracity-group.com> wrote:
> Hi,
> I'm trying to use the new concatenate command merge small ORC files and
> file right away:
>
> alter table requests partition(day_ts=1418083200, hour_ts=1418151600)
> concatenate;
>
> Diagnostic Messages for this Task:
> Error: java.lang.IllegalArgumentException: Column has wrong number of
> index entries found: 0 expected: 1
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl$TreeWriter.writeStripe(WriterImpl.java:726)
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl$StructTreeWriter.writeStripe(WriterImpl.java:1614)
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl.flushStripe(WriterImpl.java:1996)
> at
> org.apache.hadoop.hive.ql.io.orc.WriterImpl.close(WriterImpl.java:2288)
> at
> org.apache.hadoop.hive.ql.exec.OrcFileMergeOperator.closeOp(OrcFileMergeOperator.java:215)
> at
> org.apache.hadoop.hive.ql.io.merge.MergeFileMapper.close(MergeFileMapper.java:98)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
> at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:415)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
> at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>
>
> Is there some property I need to set for ORC to be able to support
> concatenation?
>
> Thanks,
> Daniel
>
>
>