Yes, based on my testing,it is wrong from 0 to 99 with the content of file
1.dat, whether the column type is string or int.
hive.log:
2016-09-09T09:10:40,978 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
CliDriver (SessionState.java:printInfo(1029)) - Hive-on-MR is deprecated in
Hive 2 and may not be available in the future versions. Consider using a
different execution engine (i.e. tez, spark) or using Hive 1.X releases.
2016-09-09T09:11:17,433 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
conf.HiveConf (HiveConf.java:getLogIdVar(3177)) - Using the default value
passed in for log id: d1e08abd-5f8b-4149-a679-00ba6b4f4ab9
2016-09-09T09:11:17,462 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:compile(409)) - Compiling
command(queryId=hadoop_20160909091117_2f9e8e3b-b2e8-4312-b473-535881c1d726):
LOAD DATA LOCAL INPATH '1.dat' overwrite INTO TABLE ODS.loadtest
2016-09-09T09:11:18,016 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
metastore.HiveMetaStore (HiveMetaStore.java:logInfo(670)) - 0: get_table :
db=ODS tbl=loadtest
2016-09-09T09:11:18,016 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(280)) - ugi=hadoop
ip=unknown-ip-addr cmd=get_table : db=ODS tbl=loadtest
2016-09-09T09:11:18,162 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:compile(479)) - Semantic Analysis Completed
2016-09-09T09:11:18,163 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:getSchema(251)) - Returning Hive schema:
Schema(fieldSchemas:null, properties:null)
2016-09-09T09:11:18,167 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:compile(551)) - Completed compiling
command(queryId=hadoop_20160909091117_2f9e8e3b-b2e8-4312-b473-535881c1d726);
Time taken: 0.725 seconds
2016-09-09T09:11:18,167 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:checkConcurrency(171)) - Concurrency mode is disabled,
not creating a lock manager
2016-09-09T09:11:18,167 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:execute(1493)) - Executing
command(queryId=hadoop_20160909091117_2f9e8e3b-b2e8-4312-b473-535881c1d726):
LOAD DATA LOCAL INPATH '1.dat' overwrite INTO TABLE ODS.loadtest
2016-09-09T09:11:18,172 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:launchTask(1832)) - Starting task [Stage-0:MOVE] in
serial mode
2016-09-09T09:11:18,172 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
exec.Task (SessionState.java:printInfo(1029)) - Loading data to table
ods.loadtest from file:1.dat
2016-09-09T09:11:18,172 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
metastore.HiveMetaStore (HiveMetaStore.java:logInfo(670)) - 0: get_table :
db=ods tbl=loadtest
2016-09-09T09:11:18,173 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(280)) - ugi=hadoop
ip=unknown-ip-addr cmd=get_table : db=ods tbl=loadtest
2016-09-09T09:11:18,320 ERROR [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
exec.Task (SessionState.java:printError(1038)) - Failed with exception
java.lang.IndexOutOfBoundsException
org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.IndexOutOfBoundsException
at
org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.checkInputFormat(HiveFileFormatUtils.java:195)
at
org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.checkTextInputFormat(HiveFileFormatUtils.java:217)
at
org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.checkInputFormat(HiveFileFormatUtils.java:182)
at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:306)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:158)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:101)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1834)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1578)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1355)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1178)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1166)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:236)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
at
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:782)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:721)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:648)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: java.lang.IndexOutOfBoundsException
at java.nio.ByteBuffer.wrap(ByteBuffer.java:371)
at org.apache.hadoop.io.Text.decode(Text.java:389)
at
org.apache.hadoop.hive.ql.io.orc.ReaderImpl.ensureOrcFooter(ReaderImpl.java:271)
at
org.apache.hadoop.hive.ql.io.orc.ReaderImpl.extractMetaInfoFromFooter(ReaderImpl.java:512)
at
org.apache.hadoop.hive.ql.io.orc.ReaderImpl.<init>(ReaderImpl.java:365)
at
org.apache.hadoop.hive.ql.io.orc.OrcFile.createReader(OrcFile.java:83)
at
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.validateInput(OrcInputFormat.java:508)
at
org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.checkInputFormat(HiveFileFormatUtils.java:193)
... 22 more
2016-09-09T09:11:18,320 ERROR [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (SessionState.java:printError(1038)) - FAILED: Execution Error,
return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
2016-09-09T09:11:18,321 INFO [d1e08abd-5f8b-4149-a679-00ba6b4f4ab9 main]:
ql.Driver (Driver.java:execute(1741)) - Completed executing
command(queryId=hadoop_20160909091117_2f9e8e3b-b2e8-4312-b473-535881c1d726);
Time taken: 0.154 seconds
thanks!
From: Jason Dere<mailto:[email protected]>
Date: 2016-09-09 01:08
To: [email protected]<mailto:[email protected]>
Subject: Re: load data Failed with exception java.lang.IndexOutOfBoundsException
Is there a related stack trace in the hive.log?
________________________________
From: 镕 <[email protected]>
Sent: Tuesday, September 06, 2016 8:38 PM
To: [email protected]
Subject: load data Failed with exception java.lang.IndexOutOfBoundsException
hi,
Can anybody reproduce following error : ( My env is hadoop2.7.2 and hive2.01)
create external table ods.loadtest
(
c1 string
)
location '/tmp/loadtest';
LOAD DATA LOCAL INPATH '1.dat' overwrite INTO TABLE ODS.loadtest;
Loading data to table ods.loadtest
Failed with exception java.lang.IndexOutOfBoundsException
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MoveTask
more 1.dat
0
