RE: Hive-645 is slow to insert query results to mysql

2012-03-11 Thread Lu, Wei
Hi Viral and Bejoy.K.S I can see that both of you are suggesting Sqoop, and I will have a try ☺. Thanks, Wei From: Bejoy Ks [mailto:bejoy...@yahoo.com] Sent: Saturday, March 10, 2012 2:11 AM To: user@hive.apache.org; Lu, Wei Subject: Re: Hive-645 is slow to insert query results to mysql Hi Wei

Re: Hive-645 is slow to insert query results to mysql

2012-03-09 Thread Bejoy Ks
http://archive.cloudera.com/cdh/3/sqoop/SqoopDevGuide.html  Regards Bejoy.K.S From: Viral Bajaria To: "Lu, Wei" ; "user@hive.apache.org" Sent: Friday, March 9, 2012 11:19 PM Subject: RE: Hive-645 is slow to insert query results to mysql Hey Wei, I hav

RE: Hive-645 is slow to insert query results to mysql

2012-03-09 Thread Viral Bajaria
From: Lu, Wei Sent: 3/8/2012 6:58 PM To: user@hive.apache.org Subject: Hive-645 is slow to insert query results to mysql Hi, I recently tried Hive-645 feature and save query results directly to Mysql table. The feature can be found here: https://issues.apache.org/jira/browse/HIVE-645

Hive-645 is slow to insert query results to mysql

2012-03-08 Thread Lu, Wei
Hi, I recently tried Hive-645 feature and save query results directly to Mysql table. The feature can be found here: https://issues.apache.org/jira/browse/HIVE-645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel. The query I tried looks like this: hive>CREATE TEMPORARY FUNCTIO