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.