drop table ods.loadtest;
create external table ods.loadtest
(
c1 string
)
stored as textfile
location '/tmp/loadtest';
hive> show create table ods.loadtest;
OK
CREATE EXTERNAL TABLE `ods.loadtest`(
`c1` string)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
STORED AS I
>at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.
validateInput(OrcInputFormat.java:508)
would it be safe to assume that you are trying to load a text file into an
table stored as ORC?
your create table doesn't specify that explicitly so that means you have a
setting in your configs that says
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 a
Is there a related stack trace in the hive.log?
From: ?
Sent: Tuesday, September 06, 2016 8:38 PM
To: user@hive.apache.org
Subject: load data Failed with exception java.lang.IndexOutOfBoundsException
hi,
Can anybody reproduce following error : ( My env is hadoo
