You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by smilevasu6 <sr...@gmail.com> on 2014/12/10 11:56:43 UTC

Camel-Hive

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.

Re: Camel-Hive

Posted by smilevasu6 <sr...@gmail.com>.
No one is there to help me on this?



--
View this message in context: http://camel.465427.n5.nabble.com/Camel-Hive-tp5760452p5760551.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel-Hive

Posted by smilevasu6 <sr...@gmail.com>.
Hi All,

Any one is there to help me on below one please



--
View this message in context: http://camel.465427.n5.nabble.com/Camel-Hive-tp5760452p5760470.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel-Hive

Posted by Willem Jiang <wi...@gmail.com>.
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.thunga@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.
>