I use   hive 1.1.0 cli  on computer A (linux)   the result is 
87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM        2357378283356   91501191044440048       
7326356         NULL
87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM        2357378283356   121501191035580028      
7326356         NULL
UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG        2362223711289   161501191549050061      
14837289      NULL
Y49EY895ACABHS95DRQEE8DVFEB8JSE1        2360853052224   111501191426280023      
115883224       NULL
But I use hive0.14 cli in my test enviroment the result is correct.

I use  hive 0.10 on computer B (linux) 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

Reply via email to