Re: Re: load data Failed with exception java.lang.IndexOutOfBoundsException

2016-09-08 Thread C R
file has more than two characters,that is a little interesting. I can not understand the result of function checkInputFormat is OrcInputFormat,maybe that is just right. Thanks. From: Stephen Sprague<mailto:sprag...@gmail.com> Date: 2016-09-09 12:47 To: user@hi

Re: Re: load data Failed with exception java.lang.IndexOutOfBoundsException

2016-09-08 Thread Stephen Sprague
>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

Re: Re: load data Failed with exception java.lang.IndexOutOfBoundsException

2016-09-08 Thread C R
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