Hi,

Again there is problem with camel hive.

As i am able to connect to hive and able fetch the data from hive table.

Now i want to load the data in another hive table.

when i try to do the same some times i am getting invalid path and some
times there is no errors but data is not moving to target hive table.

Please help me

Here is my router,

from("timer://foo?period=60000").
                        
                        setBody(constant("select * from default.emp where 
salary > 5000"))
                        .to("jdbc:fromdatasource?resetAutoCommit=false")
                        .convertBodyTo(String.class)
                    .to("file:/home/cloudera/Desktop/Sri")
                    .end();
                
                from("file:/home/cloudera/Desktop/Sri").
                        setBody(constant("LOAD DATA LOCAL INPATH 
'/home/cloudera/Desktop/Sri'
OVERWRITE INTO TABLE default.emp_h"))
                        .to("jdbc:todatasource?resetAutoCommit=false")
                        .convertBodyTo(String.class)
                    .end();



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

Reply via email to