Hive > user > May 2009

Hi all, I've been trying to use the Hive JDBC client today with some frustration. My goal was to execute a simple "SHOW TABLES" statement in Hive. If I start the Hive server with HIVE_PORT=10000 hive ...

Hi guys, I found that HiveServer can fetch metadata thourgh Hive class after generated a task like DDLTask, and meanwhile Hive class is a client who ask HiveServer for metadata. So I guess it may be ...

I have some mappers already coded in Java. So I want to use it as much as possible in Hive environment. Then, how can I call a Java mapper to "select transform" in Hive? For example, what is wrong ...

Hello. Can anybody help me please? When I was running hive from ( from pref select transform(pref.id, pref.pref) as (oid, opref) I came up with an execution error saying FAILED: Execution Error, ...

Hi all, We had a mapreduce job scaning records and generating perhaps more than 10 <key,value pairs each record. Here is mappers' pseudo-code map(key, value, ouput, reporter) { if(key.contains(a)) { ...

Hi. Are there plans to write a standard deviation aggregate function ? I had to build my own which translated into multiple hive queries. While it works, a build-in function would have been much ...

Hi all: I got a problem when I use Hive release-0.3.0-rc1 on top of Hadoop-0.19.1, When I followed the HiveGetingStarted to the step of " SELECT a.foo FROM invites a WHERE a.ds='<DATE '; " I got no ...

Hi there, I'm currently getting my feet wet with Hive and am very impressed how quick and easy it was to get going and try things out. I am trying to run a query using count(distinct) on two separate ...

It would be great if someone could shed some light on whether it has been tried/tested somewhat at FB? We would like to upgrade our Hadoop cluster from 0.19 to 0.20 and would like to make sure Hive ...

We are building a small (4 machine) cluster to test Hadoop/Hive. Is 0.20.0 the best version of Hadoop to use with Hive, or should we use a previous version? Thanks, Scott

Hi all, I found hive will generate only one job for doing a query like "select count(distinct ..) from ...", and there is only one reducer works for the job. The load of that reduer will be very ...

I'm seeing tasks killed, with the following exception in the log: 2009-05-06 04:58:20,799 WARN org.apache.hadoop.mapred.TaskTracker: Error running child java.io.IOException: Filesystem closed at ...

Hi all, Is there any articles or words about map side aggregation? Thanks, Min -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: ...

Hi, I have a data format like this: F1 \t F2 \t F3 \t K1=V1 \t K2=V2 \t K3=V3\n I've tried to create a table using: CREATE TABLE test ( f1 STRING, f2 STRING, f3 STRING, kv MAP<STRING, STRING ) ...

Hey guys, I tried to add an external partition for my web_log table, but failed like below, hive ALTER TABLE web_log ADD PARTITION (logdate='20090519') LOCATION '/user/zhoumin/web_log/20090519/'; ...

Hi Hive users, I just released a tool to import data from SQL databases into files stored on HDFS ("Sqoop"; see http://issues.apache.org/jira/browse/hadoop-5815). An extension that I'm now working on ...

Does anyone know if it's possible to use Hive with Amazon Elastic MapReduce? -Steve

Weeee! Great work guys. :) Should we also have a news section in the landing page: http://hadoop.apache.org/hive/ so that new users can see there's a release out. /Johan Ashish Thusoo wrote:

Hadoop Fans, Lately, we've been spending a lot of time on the East Coast, and one thing is clear: Hadoop is everywhere. Hadoop usage on the East Coast tends to be slightly different. There are still ...

Hadoop Fans, just a quick note that we are hosting two days of Hadoop training in Washington DC area (Alexandria, VA) on June 22 and 23. We cover Hadoop, Hive, Pig and more with a focus on hands-on ...

Hi. I have a process that is written in hive that is a lot of queries, it moves quite a bit of data around. I've been working on stabilizing/automating the process and would like to stop the process ...

Hi Folks, Is there sufficient interest in a Hive developer meet? We could organize something if enough people are interested in it. Please let me know. Thanks, Ashish

Hi folks, I have put up a short tutorial on running SQL queries on EC2 against files in S3 using Hive and Hadoop. Please find it here: http://wiki.apache.org/hadoop/Hive/HiveAws/HivingS3nRemotely ...

Just wanted to follow up on this and let everyone know that Cloudera and Y! are teaming up to offer two day-long training sessions for free on the day after the summit (June 11th). We'll cover Hadoop ...