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.
>