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

答复: Hive Sessionization

2012-03-08 Thread 董友良
Hi Praveen, Is this step has performance issue? insert overwrite table session_info_1 select transform (t.app_id, t.user_id, t.event_timestamp) using './TestLogTrans.py' as (session_id, app_id, user_id, event_timestamp, session_start_datetime, session_start_timestamp, gap_

Re: Accessing XML files in HDFS from Hive

2012-03-08 Thread dong.yajun
Hi You can write your own UDF method to parse the XML. On Thu, Mar 8, 2012 at 3:48 AM, Keaton Adams wrote: > So is there documentation or something that you can point me to that gives > a good example of how to access XML files stored in HDFS through (possibly) > an external table definition i

Repeatedly getting (java.lang.RuntimeException: Error while reading from task log url)

2012-03-08 Thread Abhishek Parolkar
Hi There! I have been doing an interesting experiment of building mac mini cluster ( http://www.scribd.com/doc/76827185/Mac-Mini-Hadoop-Cluster) I am continuously getting "*Exception in thread "Thread-69" java.lang.RuntimeException: Error while reading from task log ur*l" errors when I run hive