Can you also supply the table's DDL and a few lines of your raw data? Daniel
> On 1 באפר׳ 2015, at 09:16, "r7raul1...@163.com" <r7raul1...@163.com> wrote: > > > > > I use hive 0.14 the result is > 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM 2357378283356 91501191044440048 > 7326356 NULL > 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM 2357378283356 121501191035580028 > 7326356 NULL > UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG 2362223711289 161501191549050061 > 14837289 NULL > Y49EY895ACABHS95DRQEE8DVFEB8JSE1 2360853052224 111501191426280023 > 115883224 NULL > > I use hive 0.10 the result is > 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM 2357378283356 91501191044440048 > 7326356 2015-01-19 10:44:44 > 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM 2357378283356 121501191035580028 > 7326356 2015-01-19 10:35:58 > UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG 2362223711289 161501191549050061 > 14837289 2015-01-19 15:49:05 > Y49EY895ACABHS95DRQEE8DVFEB8JSE1 2360853052224 111501191426280023 > 115883224 2015-01-19 14:26:28 > > Why ? I attach my log. Also in my log I found 2015-04-01 09:55:38,409 WARN > [main] org.apache.hadoop.hive.serde2.lazy.LazyStruct: Extra bytes detected at > the end of the row! Ignoring similar problems. > > r7raul1...@163.com > <log.TXT>