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.