Hi Yu Yang have a look at this issue: https://issues.apache.org/jira/browse/HIVE-2722
2013/1/25 Yu Yang <clouder...@gmail.com> > Hi All, > > I'm working on hive 0.8.1. and meet following problem. > I use function substr(item,-4,1) to process one item in hive table, and > there is one row in which the content of the item is > "ba_s0一朝忽觉京梦醒,半世浮沉雨打萍--衣俊卿小n实录010", then the job failed. > I checked the task log, it appeared > > java.lang.StringIndexOutOfBoundsException: String index out of range > > Then I tried this program on my PC, > > > > ============================================= > > //test substring() > > public class substrtest { > > public static void main(String args[]){ > String s="ba_s0一朝忽觉京梦醒,半世浮沉雨打萍--衣俊卿小n实录010"; > int len=s.length(); > System.out.println(len); > String r=s.substring(28, 29); > System.out.println(r); > } > } > ======================================= > > It worked. So I am confused why hive gave me index out of range exception. > > can anyone help? > > > > -- Best wishs! Fangkun.Cao