We don’t have camel-hive component, Do you use camel-jdbc or camel-sql instead? It more like a Hive issue instead of Camel.
-- Willem Jiang Red Hat, Inc. Web: http://www.redhat.com Blog: http://willemjiang.blogspot.com (English) http://jnn.iteye.com (Chinese) Twitter: willemjiang Weibo: 姜宁willem On December 10, 2014 at 7:13:48 PM, smilevasu6 (srinivas.thu...@gmail.com) wrote: > Hi, > > I am trying to insert into hive table like > > > insert overwrite table BD_COMPANIES > t1.BD_COM_ID,t1.BD_COM_NAME,t1.COM_FUNCTIONAL_CURRENCY,t1.BD_COM_CLOSING_ACCP_ID,t1.BD_COM_SET_OF_BOOKS,t1.BD_COM_PERIOD_SET_NAME,t1.BD_COM_LOCATION,t1.BD_COM_ATTRIBUTE1,t1.BD_COM_ATTRIBUTE2,t1.BD_COM_ATTRIBUTE3,t1.BD_COM_ATTRIBUTE4,t1.BD_COM_ATTRIBUTE5 > > values select > t2.COM_ID,t2.COM_NAME,t2.COM_FUNCTIONAL_CURRENCY,t2.COM_CLOSING_ACCP_ID,t2.COM_SET_OF_BOOKS,t2.COM_PERIOD_SET_NAME,t2.COM_LOCATION,t2.COM_ATTRIBUTE1,t2.COM_ATTRIBUTE2,t2.COM_ATTRIBUTE3,t2.COM_ATTRIBUTE4,t2.COM_ATTRIBUTE5 > > from BD_COMPANIES_T t2 left outer join BD_COMPANIES t1 on > t1.BD_COM_ID=t2.COM_ID > > > But its saying > > > java.sql.SQLException: Error while compiling statement: FAILED: > ParseException line 1:36 cannot recognize input near 't1' '.' 'BD_COM_ID' in > select clause > > > Please advice > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Camel-Hive-tp5760452.html > Sent from the Camel - Users mailing list archive at Nabble.com. >